Eclipse Community Forums: Eclipse Process Manager (Stardust) » Oracle error "table or view does not exist", but application starts fine

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 08:51

Eclipse User

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 09:07

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:12:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter