My Oracle Support Banner

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

Last updated on JANUARY 29, 2022

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.


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(
at fuego.server.persistence.Persistence.getNextInstanceIn(
at fuego.server.AbstractInstanceService.create(
at fuego.server.execution.microactivity.BeginMicroActivity.createInstance(
at fuego.server.execution.microactivity.GlobalCreationMicroActivity$GlobalCreationCilExecution.afterTaskExecution(
at fuego.server.execution.TaskExecution.executeCIL(
... 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 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(
at fuego.jdbc.FaultTolerantPreparedStatement.executeUpdate(
at fuego.jdbc.DatabaseManager.getNextValForSequence(
at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getNextInstanceIn(


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.