Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Scheufen
Messages: 61
Registered: October 2011
Member

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(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
at ag.carnot.db.jdbc.Session.createLockTableEntry(Session.java:993)
at ag.carnot.db.jdbc.Session.doBatchInsert(Session.java:680)
at ag.carnot.db.jdbc.Session.flush(Session.java:1679)
at ag.carnot.workflow.runtime.spring.SpringSessionInterceptor$1.doInConnection(SpringSessionInterceptor.java:105)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342)
at ag.carnot.workflow.runtime.spring.SpringSessionInterceptor.invoke(SpringSessionInterceptor.java:52)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(MethodInvocationImpl.java:123)
at ag.carnot.workflow.runtime.spring.SpringConfigurationInterceptor.invoke(SpringConfigurationInterceptor.java:94)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(MethodInvocationImpl.java:123)
at ag.carnot.workflow.runtime.beans.interceptors.PropertyLayerProviderInterceptor.invoke(PropertyLayerProviderInterceptor.java:107)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(MethodInvocationImpl.java:123)
at ag.carnot.workflow.runtime.beans.interceptors.DebugInterceptor.invoke(DebugInterceptor.java:45)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(MethodInvocationImpl.java:123)
at ag.carnot.workflow.runtime.spring.SpringTxInterceptor$1.doInTransaction(SpringTxInterceptor.java:64)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at ag.carnot.workflow.runtime.spring.SpringTxInterceptor.invoke(SpringTxInterceptor.java:49)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.proceed(MethodInvocationImpl.java:123)
at ag.carnot.workflow.runtime.interceptor.MethodInvocationImpl.execute(MethodInvocationImpl.java:61)
at ag.carnot.workflow.runtime.beans.InvocationManager.invoke(InvocationManager.java:46)
at $Proxy83.startProcess(Unknown Source)
at ag.carnot.workflow.runtime.spring.WorkflowServiceBean.startProcess(WorkflowServiceBean.java:274)
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(SpringServiceFactory.java:172)
at $Proxy83.startProcess(Unknown Source)
at com.infinity.bpm.ui.web.processportal.common.PPUtils.startProcess(PPUtils.java:736)
at com.infinity.bpm.ui.web.processportal.launchpad.StartableProcessModel.select(StartableProcessModel.java:78)
at com.infinity.bpm.ui.web.processportal.launchpad.StartableProcessModel.selectAction(StartableProcessModel.java:52)
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 Scheufen
Messages: 61
Registered: October 2011
Member

The solution was simple. In the carnot.properties 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: Thu Oct 23 11:04:20 GMT 2014

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

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