ora-00942 table or view does not exist
parditoJun 16 2008 — edited Jul 22 2008Hi everybody!
I'm trying to synchronize my client but i get the next error:
Rastreo de pila de excepciones de sesión de sincronización:
java.sql.SQLException: ORA-00942: la tabla o vista no existe
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(Unknown Source)
at oracle.lite.sync.Subscription.execPrepUpdate(Unknown Source)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
at oracle.lite.sync.DmlProcessorDB.reExecuteDml(Unknown Source)
at oracle.lite.sync.DmlProcessorDB.flushIs(Unknown Source)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
at oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
at oracle.lite.sync.HeliosSession.executeIU(Unknown Source)
at oracle.lite.sync.HeliosSession.startSession(Unknown Source)
at oracle.lite.sync.resume.Client$1.run(Unknown Source)
at oracle.lite.sync.resume.ThreadPool$PoolTask.run(Unknown Source)
I've read this is because there is an CVR$* table that does not exists and i need to drop the publication item and create a new one.. but i don't know which pubItem i need to delete.
I'll appreciate any help.