[jboss-user] [JBoss jBPM] - unable to start a process instance in a console
maruthi.sura
do-not-reply at jboss.com
Tue Jun 9 06:44:40 EDT 2009
i 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 at 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
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4236315#4236315
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4236315
More information about the jboss-user
mailing list