Simulation Engine Does Not Run: appserver.dao: BaseDAO: execution failed - wrapping exception: java.sql.SQLException (Doc ID 552614.1)

Last updated on APRIL 16, 2015

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a simulation:

An error window opens with the message: 'Error occurred in calculating simulation population.'

and in log file:

ERROR appserver.dao: BaseDAO: execution failed - wrapping exception: java.sql.SQLException
java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.demantra.applicationServer.services.dao.AbstractSelectDAO.executeStatement(AbstractSelectDAO.java:75)
at com.demantra.applicationServer.services.dao.BaseDAO.execute(BaseDAO.java:138)
at com.demantra.applicationServer.metaDataObjects.simulation.SimulationList.getPopulationCount(SimulationList.java:1115)
at com.demantra.applicationServer.metaDataObjects.simulation.SimulationList.allowSimulation(SimulationList.java:1032)
at com.demantra.applicationServer.metaDataObjects.simulation.SimulationList.requestSimulation(SimulationList.java:913)
at com.demantra.bridge.server.SoapBridge.runSimulation(SoapBridge.java:3655)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.visit(InvokeTaskVisitor.java:227)
at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.invoke(InvokeTaskVisitor.java:115)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.access$000(InvokeTaskVisitor.java:49)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor$1.process(InvokeTaskVisitor.java:103)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:188)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visitOther(LogProcessTaskVisitor.java:171)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visit(LogProcessTaskVisitor.java:160)
at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.apply(LogProcessTaskVisitor.java:123)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:118)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.apply(InvokeTaskVisitor.java:100)
at com.demantra.tunnel.server.controller.TaskDispatcher.invokeImmediately(TaskDispatcher.java:219)
at com.demantra.tunnel.server.controller.TaskDispatcher.dispatchTask(TaskDispatcher.java:145)
at com.demantra.tunnel.server.controller.TaskDispatcher.dispatch(TaskDispatcher.java:84)
at com.demantra.tunnel.server.controller.TaskDispatcher.apply(TaskDispatcher.java:74)
at com.demantra.tunnel.server.controller.RequestDispatcher.processTask(RequestDispatcher.java:129)
at com.demantra.tunnel.server.controller.RequestDispatcher.processRequest(RequestDispatcher.java:86)
at com.demantra.tunnel.server.RequestDispatcherServlet.processRequest(RequestDispatcherServlet.java:79)
at com.demantra.tunnel.server.RequestDispatcherServlet.doPost(RequestDispatcherServlet.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
at java.lang.Thread.run(Thread.java:534)


Steps To Reproduce:
1. Loaded Customer Data
2. Run Simulation Engine
3. Open Worksheet, Run Simulation

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