'Oracle entries could not be found' Caused due to ORA-00942: table or view does not exist Error

(Doc ID 1585811.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Business Process Management Suite - Version 10.3.2 and later
Information in this document applies to any platform.

Symptoms

Cannot connect a client PAPI application to PAPI services due to the following exception:

05 Aug 2013 15:19:04,467 [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' yourserver.net 169.71.222.222 ERROR PapiWS : createBPMProcessInstanceUsingPAPI method - Error creating ALBPM instance using PAPI
fuego.papi.exception.DirectoryServiceNotAvailableException: Directory Service: 'OBPM10g_SIT_FDI' is not available.
at fuego.papi.impl.ProcessServiceFactoryImpl.obtainSchemaId(ProcessServiceFactoryImpl.java:200)
at fuego.papi.impl.ProcessServiceFactoryImpl.create(ProcessServiceFactoryImpl.java:75)
at fuego.papi.impl.ProcessServiceFactoryImpl.create(ProcessServiceFactoryImpl.java:63)
at fuego.papi.ProcessService.create(ProcessService.java:335)
at com.oracle.gcrm.bpm.albpm.utils.PapiWS.createBPMProcessInstanceUsingPAPI(Unknown Source)
at com.oracle.gcrm.bpm.fw.message.mdb.ServiceMessageGenerator.sendMessage(ServiceMessageGenerator.java:251)
at com.oracle.gcrm.bpm.fw.message.mdb.ServiceMessageGenerator.handleParsedMessage(ServiceMessageGenerator.java:82)
at com.oracle.gcrm.bpm.fw.message.mdb.BpmFrameworkMdb.onMessage(BpmFrameworkMdb.java:67)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4585)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:4271)
at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3747)
at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5096)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: fuego.directory.exception.InvalidSchemaException: Directory [OBPM10g_SIT_FDI] has not been correctly initialized.
Detail:Even though a Directory Service is currently present at the specified location, the expected Oracle entries could not be found. Either the schema has not been created or the existing directory corresponds to a different Oracle version.

at fuego.directory.provider.jdbc.oracle.OraclePersistenceManager.mapSQLException(OraclePersistenceManager.java:126)
at fuego.directory.provider.jdbc.datadirect.oracle.DataDirectOraclePersistenceManager.mapSQLException(DataDirectOraclePersistenceManager.java:51)
at fuego.directory.provider.jdbc.JDBCServiceAccessor.mapSQLException(JDBCServiceAccessor.java:78)
at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.getSchemaInfo(JDBCAuthenticationAccessor.java:168)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
at $Proxy106.getSchemaInfo(Unknown Source)
at fuego.directory.provider.Factory.obtainSchemaInfo(Factory.java:555)
at fuego.directory.provider.DirectorySessionImpl.loadSchemaInfo(DirectorySessionImpl.java:528)
at fuego.directory.provider.DirectorySessionImpl.connect(DirectorySessionImpl.java:245)
at fuego.directory.provider.Factory.startSession(Factory.java:405)
at fuego.directory.Directory.startAnonymousSession(Directory.java:214)
at fuego.papi.impl.ProcessServiceFactoryImpl.obtainSchemaId(ProcessServiceFactoryImpl.java:193)
... 18 more
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at albpm.jdbc.base.BaseExceptions.createException(Unknown Source)
at albpm.jdbc.base.BaseExceptions.getException(Unknown Source)
at albpm.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at albpm.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at albpm.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at albpm.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at fuego.jdbc.FaultTolerantPreparedStatement.executeQuery(FaultTolerantPreparedStatement.java:598)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.executeQuery(JDBCPersistenceManager.java:193)
at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.getSchemaInfo(JDBCAuthenticationAccessor.java:151)
... 30 more

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