Mobile Server Error: java.sql.SQLException: ORA-00942: table or view does n
CEGMay 9 2007 — edited May 17 2007I am new to Oracle Database Lite and I do not know where to start look for a solution to the error below. Any assistance that you can provide would be helpful.
This error is coming during the actual Sync operation from the oracle lite sync. The synchronization seems to be trying to access table(s) that it expects to be on the client and it is not finding it/them.
Here is the entire mobile server error:
Sync Session Exception Stack Trace:
java.sql.SQLException: ORA-00942: table or view does not exist
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.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
at oracle.lite.sync.BlobSafePreparedStatement.executeUpdate(BlobSafePreparedStatement.java:192)
at oracle.lite.sync.Subscription.execPrepUpdate(Subscription.java:6168)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(DmlProcessorM.java:736)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(DmlProcessorM.java:75)
at oracle.lite.sync.DmlProcessorDB.reExecuteDml(DmlProcessorDB.java:210)
at oracle.lite.sync.DmlProcessorDB.flushIs(DmlProcessorDB.java:230)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(DmlProcessorM.java:631)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(DmlProcessorM.java:75)
at oracle.lite.sync.HeliosSession.executeIU(HeliosSession.java:3398)
at oracle.lite.sync.HeliosSession.startSession(HeliosSession.java:3885)
at oracle.lite.sync.resume.Client$1.run(Client.java:109)
at oracle.lite.sync.resume.ThreadPool$PoolTask.run(ThreadPool.java:31)
Thannks in advance for your assistance.