ORA-01427 During Synchronization
(Doc ID 394996.1)
Last updated on FEBRUARY 21, 2024
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |