"ORA-00942: table or view does not exist" Is Thrown When Trying To Execute A BPM Task
(Doc ID 1159423.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle Business Process Management Suite - Version 10.3.1 to 10.3.1 [Release AS10gR3]Information in this document applies to any platform.
Symptoms
After you setup the Engine repository in BPM Process Administrator through an External Resource pointing to a Weblogic datasource JNDI name and you run any application in BPM Workspace, you might get an error as follows:
Caused by: fuego.transaction.DatAbaseException: An error occurred while accesing the database.
Detalle:SQL statement: 'unknown'
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getNextInstanceIn(JdbcProcessInstancePersMgr.java:896)
at fuego.server.persistence.Persistence.getNextInstanceIn(Persistence.java:407)
at fuego.server.AbstractInstanceService.create(AbstractInstanceService.java:302)
at fuego.server.execution.microactivity.BeginMicroActivity.createInstance(BeginMicroActivity.java:91)
at fuego.server.execution.microactivity.GlobalCreationMicroActivity$GlobalCreationCilExecution.afterTaskExecution(GlobalCreationMicroActivity.java:187)
at fuego.server.execution.TaskExecution.executeCIL(TaskExecution.java:539)
... 68 more
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:159)
at fuego.jdbc.FaultTolerantPreparedStatement.executeUpdate(FaultTolerantPreparedStatement.java:623)
at fuego.jdbc.DatabaseManager.getNextValForSequence(DatabaseManager.java:991)
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getNextInstanceIn(JdbcProcessInstancePersMgr.java:893)
Detalle:SQL statement: 'unknown'
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getNextInstanceIn(JdbcProcessInstancePersMgr.java:896)
at fuego.server.persistence.Persistence.getNextInstanceIn(Persistence.java:407)
at fuego.server.AbstractInstanceService.create(AbstractInstanceService.java:302)
at fuego.server.execution.microactivity.BeginMicroActivity.createInstance(BeginMicroActivity.java:91)
at fuego.server.execution.microactivity.GlobalCreationMicroActivity$GlobalCreationCilExecution.afterTaskExecution(GlobalCreationMicroActivity.java:187)
at fuego.server.execution.TaskExecution.executeCIL(TaskExecution.java:539)
... 68 more
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:159)
at fuego.jdbc.FaultTolerantPreparedStatement.executeUpdate(FaultTolerantPreparedStatement.java:623)
at fuego.jdbc.DatabaseManager.getNextValForSequence(DatabaseManager.java:991)
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getNextInstanceIn(JdbcProcessInstancePersMgr.java:893)
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 |
| Cause |
| Solution |
| References |