Oracle error "table or view does not exist", but application starts fine [message #740380] |
Tue, 18 October 2011 12:51 |
|
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 |
|
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).
|
|
|
Powered by
FUDForum. Page generated in 0.02727 seconds