NullMGP Cycle Exception Stack Trace java.Sql.Sqlexception: Ora-00904 (Doc ID 402592.1)

Last updated on JANUARY 29, 2015

Applies to:

Oracle Lite - Version 10.2.0.1.0 to 10.3.0.3.0 [Release 10.2 to 10.3]
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2013***

Symptoms

After performing an installation of the Oracle Lite Mobile Server utilizing a pre-created syncserver tablespace, the Message Generator Process (MGP) reports a:

java.sql.SQLException: ORA-00904: "ACI"."CRR": invalid identifier
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
at oracle.jdbc.ttc7.TTC7Proto .doOall7(TTC7Protocol.java:1478)
at oracle.jdbc.ttc7.TTC7Proto .parseExecuteDescribe(TTC7Protocol.java:677)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:387)
at oracle.lite.sync.MGP.addFastPushClients(Unknown Source)
at oracle.lite.sync.MGP.fast_push(Unknown Source)
at oracle.lite.sync.MGP.start(Unknown Source)
at oracle.lite.sync.MgpJob.execute(Unknown Source)
at oracle.lite.job.JobThread.run(Unknown Source)

Reviewing of the repository.log file will show that the Repository Wizard actually experienced a failure during the creation of the Mobile Repository: ORA-39726: unsupported add/drop column operation on compressed tables causing numerous ORA-904 errors to occur for the CRR identifier.
.

Changes

The syncserver tablespace was pre-created using the compression option: DEFAULT COMPRESS

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