Troubleshooting
Problem
After other non-production environment upgrades were success, a development system failed to upgrade.
ORA-02002: error while writing to audit trail\nORA-00942: table or view does not exist
Symptom
Upgrade does not proceed. Full stack seen in ce_system0.log:
2023-01-11T09:20:54.530 00000191 ENG FNRCD0009E - ERROR ObjectStoreUpgrade(os1) Background task (UpgraderTask:os1) terminated abnormally\ncom.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 2,002, Message 'ORA-02002: error while writing to audit trail\nORA-00942: table or view does not exist\nORA-00942: table or view does not exist\n' ObjectStore: "os1", SQL: ""SELECT 1 FROM OS1.ElasticSearchQueue WHERE (1=2)""\n at com.filenet.engine.dbpersist.DBOracleContext.throwEngineException(DBOracleContext.java:407)\n at com.filenet.engine.dbpersist.DBExecutionElement.execute(DBExecutionElement.java:294)\n at com.filenet.engine.dbpersist.DBExecutionContext.getNextResult(DBExecutionContext.java:109)\n at com.filenet.engine.dbpersist.DBStatementBase.execute(DBStatementBase.java:277)\n at com.filenet.engine.dbpersist.DBContext.tableExists(DBContext.java:2450)\n at com.filenet.engine.dbpersist.DBContext.tableExists(DBContext.java:2430)\n at com.filenet.engine.upgrade.db.UpgradeSchema$7.doIn(UpgradeSchema.java:473)\n at com.filenet.engine.upgrade.db.UpgradeSchema.executeZosQueryInLt(UpgradeSchema.java:1166)\n at com.filenet.engine.upgrade.db.UpgradeSchema.tableExists(UpgradeSchema.java:477)\n at com.filenet.engine.upgrade.db.UpgradeSchema.addColumnIfNotExists(UpgradeSchema.java:209)\n at com.filenet.engine.upgrade.db.UpgradeTableColumnDefinition.upgradeSystemColumns(UpgradeTableColumnDefinition.java:337)\n at com.filenet.engine.upgrade.db.UpgradeTableColumnDefinition.upgradeTableColumnIndex(UpgradeTableColumnDefinition.java:180)\n at com.filenet.engine.upgrade.ObjectStoreUpgrader.upgradeDb(ObjectStoreUpgrader.java:216)\n at com.filenet.engine.upgrade.ObjectStore521Upgrader.doUpgrade(ObjectStore521Upgrader.java:36)\n at com.filenet.engine.upgrade.UpgraderTask.execute(UpgraderTask.java:162)\n at com.filenet.engine.tasks.BackgroundTask.safeExecute(BackgroundTask.java:268)\n at com.filenet.engine.tasks.BackgroundTask$BackgroundTaskPrivilegedExceptionAction.run(BackgroundTask.java:1147)\n at com.filenet.engine.context.CallState._doAsSecurityContext(CallState.java:285)\n at com.filenet.engine.context.CallState.doAsSystem(CallState.java:335)\n at com.filenet.engine.tasks.BackgroundTask.run(BackgroundTask.java:200)\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)\n at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)\n at java.lang.Thread.run(Thread.java:818)\nCaused by: java.sql.SQLSyntaxErrorException: ORA-02002: error while writing to audit trail\nORA-00942: table or view does not exist\nORA-00942: table or view does not exist\n\n at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)\n at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)\n at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)\n at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)\n at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)\n at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)\n at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)\n at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:937)\n at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)\n at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)\n at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)\n at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)\n at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)\n at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3941)\n at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1010)\n at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:1075)\n at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:646)\n at com.filenet.engine.dbpersist.DBExecutionElement.execute(DBExecutionElement.java:246)\n ... 21 more\nCaused by: Error : 2002, Position : 22, Sql = SELECT 1 FROM OS1.ElasticSearchQueue WHERE (1=2), OriginalSql = SELECT 1 FROM OS1.ElasticSearchQueue WHERE (1=2), Error Msg = ORA-02002: error while writing to audit trail\nORA-00942: table or view does not exist\nORA-00942: table or view does not exist\n\n at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)\n
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"ARM Category":[{"code":"a8m0z0000004D40AAE","label":"Content Engine"},{"code":"a8m0z000000cx4VAAQ","label":"Content Engine-\u003EDatabase"}],"ARM Case Number":"TS011806486","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.1;and future releases"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
28 April 2025
UID
ibm16854889