ORA-00936 Error Repeatedly In Engine Logs (Doc ID 1500939.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Business Process Management Suite - Version 10.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 03-November-2014***

Symptoms

Following error is seen repeatedly in the engine logs

Caused by: [BEA][Oracle JDBC Driver][Oracle]ORA-00936: missing expression

fuego.transaction.DatabaseException: An error occurred while accesing the database.
Detail:SQL statement: 'SELECT PROCESSID, INSTID, THREADID, NAME, PARENTTHREAD, PRIORITY, CREATIONTIME, AUTHOR, PARTICIPANT, NEXTPARTICIPANT, PROCESSDEADLINE, ACTIVITYDEADLINE, RECEIVETIME, ACTIVATIONTIME, ACTIVITYNAME, NTHREADS, CTHREADS, TOTALTHREADS, STATE, SOURCEACTIVITYNAME, ROLEIN, PENDINGITEMID, LASTRESULT, ITEMDEADLINE, NREMARKS, NATTACHMENTS, NCHANGES, FCTHREAD, V_ARTIFACTGROUP, V_ARTIFACTTYPE, V_ARTIFACTUUID, V_ASSOCEMAILID, V_CONTENTUUID, V_CORRBATCHID, V_DCSCOURTIDNUM, V_DCSPRODUCTNAME, V_DCSPRODUCTTYPE, V_DCSSRCFILENAME, V_FILELANDINGDATE, V_FILENAME, V_JURISDICTION, V_LEGARTBATCHID, V_LEGARTIFACTUUID, V_PDFURIROOT, V_PDFUUID, V_PDFURI, V_PROCBATCHID, V_PROVIDERLOGIN, V_PROVIDERNAME, V_QUERYREQUESTOR, V_QUERYRESPONDER, V_RECEIPTDATE, V_RECEIPTIDNUM, V_RECEIPTMETHOD, V_SERIALNUMBER, V_SHORTVENUENAME, V_SOURCEARTIFACTID, V_XAMPEXFILENAME FROM PPROCINSTANCE WHERE (PROCESSID=332 ) AND (((STATE NOT IN (1056,17440,1088,17472)) AND ())) ORDER BY RECEIVETIME ASC'

at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.getInstancesByFilter(JdbcProcessInstancePersMgr.java:535)
at fuego.server.persistence.Persistence.getInstancesByFilter(Persistence.java:321)
at fuego.server.ProcessInstanceManager.getInstancesByFilter(ProcessInstanceManager.java:132)
at fuego.server.AbstractProcessBean$34.execute(AbstractProcessBean.java:1667)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:304)
at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:470)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:551)
at fuego.transaction.TransactionAction.start(TransactionAction.java:212)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123)
at fuego.server.execution.DefaultEngineExecution.executeWithoutComponentImmediate(DefaultEngineExecution.java:199)
at fuego.server.execution.EngineExecution.executeWithoutComponentImmediate(EngineExecution.java:95)
at fuego.server.AbstractProcessBean.getInstancesByFilter(AbstractProcessBean.java:1661)
at fuego.ejbengine.EJBProcessControlAdapter.getInstancesByFilter(EJBProcessControlAdapter.java:370)
at fuego.papi.impl.j2ee.EJSRemoteStatelessEJBProcessControl_ac6abeae.getInstancesByFilter(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:726)
at java.security.AccessController.doPrivileged(AccessController.java:246)
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:724)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1160)
at $Proxy126.getInstancesByFilter(Unknown Source)
at fuego.papi.impl.j2ee._EJBProcessControlInterface_Stub.getInstancesByFilter(_EJBProcessControlInterface_Stub.java:2196)
at fuego.papi.impl.j2ee.EJBProcessControlInterfaceWrapper.getInstancesByFilter(EJBProcessControlInterfaceWrapper.java:1185)
at sun.reflect.GeneratedMethodAccessor524.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at fuego.papi.impl.AbstractProcessControlHandler.invokeInternal(AbstractProcessControlHandler.java:72)
at fuego.papi.impl.j2ee.EJBProcessControlHandler.doInvoke(EJBProcessControlHandler.java:116)
at fuego.papi.impl.j2ee.EJBProcessControlHandler.invoke(EJBProcessControlHandler.java:70)
at $Proxy125.getInstancesByFilter(Unknown Source)
at fuego.papi.impl.InstanceCache.getInstancesByFilter(InstanceCache.java:322)
at fuego.papi.impl.ProcessServiceImpl.getInstancesByFilter(ProcessServiceImpl.java:1369)
at fuego.papi.impl.ProcessServiceSessionImpl.processesGetInstancesByFilter(ProcessServiceSessionImpl.java:2396)
at fuego.papi.impl.SessionViewManager.getInstancesByView(SessionViewManager.java:516)
at fuego.papi.impl.ProcessServiceSessionImpl.viewGetInstances(ProcessServiceSessionImpl.java:2415)
at fuego.workspace.model.common.PapiBean.getInstancesByView(PapiBean.java:632)
..

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