"ORA-00942: table or view does not exist" Is Thrown When Trying To Execute A BPM Task (Doc ID 1159423.1)

Last updated on OCTOBER 24, 2016

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.
***Checked for relevance on 30-May-2012***

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)

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