Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » Eclipse Process Manager (Stardust) » Oracle error "table or view does not exist", but application starts fine(Getting Oracle exceptions about missing tables after login)
Oracle error "table or view does not exist", but application starts fine [message #740380] Tue, 18 October 2011 12:51 Go to next message
Jan Hendrik Scheufen is currently offline Jan Hendrik ScheufenFriend
Messages: 77
Registered: October 2011

I deployed a Hello World model to a IPP runtime on Tomcat with Oracle as backend. When the web application has started, I login and click on the My Startable Processes link. The following error shows up in the log.

12:01:29 WARN [rocessor22] ApplicationException - Error during flush.
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(
at ag.carnot.db.jdbc.Session.createLockTableEntry(
at ag.carnot.db.jdbc.Session.doBatchInsert(
at ag.carnot.db.jdbc.Session.flush(
at ag.carnot.workflow.runtime.spring.SpringSessionInterceptor$1.doInConnection(
at org.springframework.jdbc.core.JdbcTemplate.execute(
at ag.carnot.workflow.runtime.spring.SpringSessionInterceptor.invoke(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(
at ag.carnot.workflow.runtime.spring.SpringConfigurationInterceptor.invoke(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(
at ag.carnot.workflow.runtime.beans.interceptors.PropertyLayerProviderInterceptor.invoke(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(
at ag.carnot.workflow.runtime.beans.interceptors.DebugInterceptor.invoke(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(
at ag.carnot.workflow.runtime.spring.SpringTxInterceptor$1.doInTransaction(
at ag.carnot.workflow.runtime.spring.SpringTxInterceptor.invoke(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.execute(
at ag.carnot.workflow.runtime.beans.InvocationManager.invoke(
at $Proxy83.startProcess(Unknown Source)
at ag.carnot.workflow.runtime.spring.WorkflowServiceBean.startProcess(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at ag.carnot.workflow.runtime.spring.SpringServiceFactory$SpringServiceInvocationHandler.invoke(
at $Proxy83.startProcess(Unknown Source)
at com.infinity.bpm.ui.web.processportal.common.PPUtils.startProcess(
at com.infinity.bpm.ui.web.processportal.launchpad.StartableProcessModel.selectAction(
Re: Oracle error "table or view does not exist", but application starts fine [message #740392 is a reply to message #740380] Tue, 18 October 2011 13:07 Go to previous message
Jan Hendrik Scheufen is currently offline Jan Hendrik ScheufenFriend
Messages: 77
Registered: October 2011

The solution was simple. In the file set

AuditTrail.UseLockTables = false

Lock tables are not required for Oracle. See also the chapter "Tuning for concurrency" and "Proxy Lock Table Administration" in the online documentation.

If you're getting this error message preventing the web application to start at all, then some typical other causes for this error include:

  • Wrong value for property AuditTrail.Schema. If this property is empty, then Stardust will use the connecting user's schema. If this is not intended, then the connecting user needs to have access rights to the specified schema and the schema can be set via this property.
  • The wrong database or connection user has been configured for the datasource
  • The schema has not been created yet (rarely, but it happens).

Previous Topic:TypeMismatchException for javax.transaction.UserTransaction during server start on JBoss
Next Topic:Invalid JAXP setup, javax.xml.transform.TransformerConfigurationException
Goto Forum:

Current Time: Wed Jun 20 04:18:38 GMT 2018

Powered by FUDForum. Page generated in 0.02159 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top