[jboss-user] [JBoss jBPM] - Re: Error on the end of the execution
victorl
do-not-reply at jboss.com
Wed Apr 9 18:57:17 EDT 2008
Excuse me salaboy in previous message I pasted a wrong exception. So if I create the database directly from bpm.jpdl.mysql.sql in jbpm-jpdl-3.2.2 package I get this error:
|
| 2008-04-09 19:52:51,662 [http-8090-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
| 2008-04-09 19:52:51,662 [http-8090-1] ERROR org.hibernate.util.JDBCExceptionReporter - Table 'saslc_jbpm.jbpm_exceptionhandler' doesn't exist
| org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers#1]
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)
| at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
| at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
| at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
| at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
| at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
| at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:785)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241)
| at org.hibernate.loader.Loader.doList(Loader.java:2220)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
| at org.hibernate.loader.Loader.list(Loader.java:2099)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
| at ar.com.dsv.saslc.seguimiento.workflow.jbpm.InicioProcesoAlta.iniciar(InicioProcesoAlta.java:26)
| at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.iniciarTramite(JBPMSeguimiento.java:80)
| at ar.com.dsv.saslc.tramite.negocio.TramiteBO.guardarTramite(TramiteBO.java:750)
| at ar.com.dsv.saslc.agenda.turno.actions.TramiteActionBase.guardarDatosVecino(TramiteActionBase.java:320)
| 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:585)
| at ar.com.dsv.base.actions.DispatchActionGenerico.dispatchMethod(DispatchActionGenerico.java:80)
| at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
| at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
| at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
| at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
| at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
| at ar.com.dsv.base.hbSession.ControladorSessionHB.doFilter(ControladorSessionHB.java:50)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
| at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
| at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
| at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: java.sql.SQLException: Table 'saslc_jbpm.jbpm_exceptionhandler' doesn't exist
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
| at org.hibernate.loader.Loader.doQuery(Loader.java:674)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
| at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
| ... 48 more
| 2008-04-09 19:52:51,893 [http-8090-1] ERROR org.jbpm.db.GraphSession - org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers#1]
| org.jbpm.JbpmException: couldn't find process definition 'alta'
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:170)
| at ar.com.dsv.saslc.seguimiento.workflow.jbpm.InicioProcesoAlta.iniciar(InicioProcesoAlta.java:26)
| at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.iniciarTramite(JBPMSeguimiento.java:80)
| at ar.com.dsv.saslc.tramite.negocio.TramiteBO.guardarTramite(TramiteBO.java:750)
| at ar.com.dsv.saslc.agenda.turno.actions.TramiteActionBase.guardarDatosVecino(TramiteActionBase.java:320)
| 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:585)
| at ar.com.dsv.base.actions.DispatchActionGenerico.dispatchMethod(DispatchActionGenerico.java:80)
| at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
| at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
| at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
| at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
| at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
| at ar.com.dsv.base.hbSession.ControladorSessionHB.doFilter(ControladorSessionHB.java:50)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
| at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
| at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
| at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
| at java.lang.Thread.run(Thread.java:595)
| Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers#1]
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)
| at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
| at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
| at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
| at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
| at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
| at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:785)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241)
| at org.hibernate.loader.Loader.doList(Loader.java:2220)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
| at org.hibernate.loader.Loader.list(Loader.java:2099)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
| ... 31 more
| Caused by: java.sql.SQLException: Table 'saslc_jbpm.jbpm_exceptionhandler' doesn't exist
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
| at org.hibernate.loader.Loader.doQuery(Loader.java:674)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
| at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
| ... 48 more
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4143008#4143008
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4143008
More information about the jboss-user
mailing list