ORA-01427 During Synchronization (Doc ID 394996.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.0.0.0.1 to 10.2.0.2.0 [Release 10.0 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Oct-2012***


Symptoms

You have created a new Mobile Application or Modify the Publication/Publication items of an existing App.

When you synchronize you receive the Server Error as follows:

MAGIC_CHECK returned incorrect for OLITE.DEPT
MAGIC_CHECK returned incorrect for OLITE.VR_ZIP_CODES
MAGIC_CHECK returned incorrect for C$ALL_SEQUENCE_PARTITIONS
MAGIC_CHECK returned incorrect for C$APP_PUB_PROPERTIES
MAGIC_CHECK returned incorrect for C$SEQ_CLIENTSSync session exception stack trace:
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2973)
at oracle.lite.sync.Subscription.execPrepDirect(Subscription.java:6122)
at oracle.lite.sync.HeliosSession.cleanupMaps(HeliosSession.java:6464)
at oracle.lite.sync.HeliosSession.startSession(HeliosSession.java:4851)
at oracle.lite.sync.resume.Client$1.run(Client.java:111)
at oracle.lite.sync.resume.ThreadPool$PoolTask.run(ThreadPool.java:31)

Changes

Mobile Repository  Object has been modified.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms