unable to start a process instance in a console
maruthi.sura Jun 9, 2009 6:44 AMi tried using database oracle 10g.with jbpm4.0.CR1. when i click start button to create a process instance i got the following execption.but when i used hsqldb as database am able to create a process instance.
[JDBCExceptionReporter] SQL Error: -28, SQLState: S0022 ERROR [JDBCExceptionReporter] Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] 16:05:45,290 INFO [DefaultCommandService] exception while executing command org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd@19ac87 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2231) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findDeploymentPropertyByProcessDefinitionId(RepositorySessionImpl.java:184) at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:171) at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:45) at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:53) at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37) at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54) at org.jbpm.enterprise.internal.jta.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:73) at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceById(ExecutionServiceImpl.java:49) at org.jbpm.integration.console.ProcessManagementImpl.newInstance(ProcessManagementImpl.java:203) 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 org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:64) at $Proxy164.newInstance(Unknown Source) at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:118) 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 org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117) at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166) at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:453) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573) at org.hibernate.loader.Loader.doQuery(Loader.java:696) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2228) ... 63 more 16:05:45,310 ERROR [STDERR] 262595 [http-127.0.0.1-8080-2] ERROR org.jboss.resteasy.core.SynchronousDispatcher - failed to execute 16:05:45,310 ERROR [STDERR] javax.ws.rs.WebApplicationException: java.lang.RuntimeException: Unexpected invocation exception: null 16:05:45,311 ERROR [STDERR] at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:123) 16:05:45,311 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 16:05:45,311 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 16:05:45,311 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 16:05:45,311 ERROR [STDERR] at java.lang.reflect.Method.invoke(Unknown Source) 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117) 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260) 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232) 16:05:45,311 ERROR [STDERR] at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166) 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142) 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173) 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93) 16:05:45,312 ERROR [STDERR] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68) 16:05:45,312 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 16:05:45,312 ERROR [STDERR] at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) 16:05:45,312 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) 16:05:45,313 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) 16:05:45,313 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) 16:05:45,314 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) 16:05:45,314 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 16:05:45,314 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 16:05:45,314 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) 16:05:45,314 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 16:05:45,314 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) 16:05:45,314 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) 16:05:45,314 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601) 16:05:45,314 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 16:05:45,314 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 16:05:45,315 ERROR [STDERR] Caused by: java.lang.RuntimeException: Unexpected invocation exception: null 16:05:45,315 ERROR [STDERR] at org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:80) 16:05:45,315 ERROR [STDERR] at $Proxy164.newInstance(Unknown Source) 16:05:45,315 ERROR [STDERR] at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:118) 16:05:45,315 ERROR [STDERR] ... 38 more 16:05:45,316 ERROR [STDERR] Caused by: java.lang.reflect.InvocationTargetException 16:05:45,316 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 16:05:45,316 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 16:05:45,316 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 16:05:45,316 ERROR [STDERR] at java.lang.reflect.Method.invoke(Unknown Source) 16:05:45,316 ERROR [STDERR] at org.jboss.bpm.console.server.util.InvocationProxy.invoke(InvocationProxy.java:64) 16:05:45,316 ERROR [STDERR] ... 40 more 16:05:45,316 ERROR [STDERR] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query 16:05:45,316 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) 16:05:45,316 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2231) 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2120) 16:05:45,317 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) 16:05:45,317 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) 16:05:45,317 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) 16:05:45,317 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) 16:05:45,317 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) 16:05:45,318 ERROR [STDERR] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findDeploymentPropertyByProcessDefinitionId(RepositorySessionImpl.java:184) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:171) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionById(RepositorySessionImpl.java:45) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:53) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54) 16:05:45,318 ERROR [STDERR] at org.jbpm.enterprise.internal.jta.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:73) 16:05:45,318 ERROR [STDERR] at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceById(ExecutionServiceImpl.java:49) 16:05:45,319 ERROR [STDERR] at org.jbpm.integration.console.ProcessManagementImpl.newInstance(ProcessManagementImpl.java:203) 16:05:45,319 ERROR [STDERR] ... 45 more 16:05:45,319 ERROR [STDERR] Caused by: java.sql.SQLException: Column not found: ROWNUM in statement [select * from ( select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='EndMultiple-3' ) where rownum <= ?] 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.Util.throwError(Unknown Source) 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) 16:05:45,319 ERROR [STDERR] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465) 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:453) 16:05:45,319 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) 16:05:45,320 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573) 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:696) 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) 16:05:45,320 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2228) 16:05:45,320 ERROR [STDERR] ... 63 more
Thanks & Regards
Maruthi