6 Replies Latest reply on Apr 11, 2008 4:22 PM by Mauricio Salatino

    Error on the end of the execution

    Victor Abc Newbie

      Hi All,

      What does it mean the following error:

      
      2008-04-09 15:45:19,125 [http-8090-1] ERROR org.jbpm.db.SchedulerSession - java.lang.IllegalArgumentException: Parameter processInstance does not exist as a named parameter in [
      
       delete from org.jbpm.scheduler.exe.Timer t
       where t.processInstance = :processInstance
      
       ]
      
      


      It is ocurring after an ActionHandler for an end-state is executed.

      The ActionHandler only has one instruction: System.out.println(....) and no more.

      I also tried removing the ActionHanbler for the end-state and the error follows.


      Any help would be greatly appreciated.
      Regards,

      Victor

        • 1. Re: Error on the end of the execution
          Mauricio Salatino Master

           

          Parameter processInstance does not exist as a named parameter in [
          
           delete from org.jbpm.scheduler.exe.Timer t
           where t.processInstance = :processInstance
          
           ]
          


          That means that the field processInstance doesn't exists in the Timer table in your persistence database. This may be cause of the use of and old version of jpdl or beacause your mapping are wrong..
          check the hibernte.cfg.xml config file.. look for the Timer mappings..
          and check the tables in your database.

          • 2. Re: Error on the end of the execution
            Victor Abc Newbie

            Hi salaboy,

            Thank you very much for your response.

            I am using jbpm-jpdl-3.2.2 and I created the jbpm database with the script mysql.create.sql from jbpm-starters-kit-3.1.4 And then I ran jbpm.jpdl.mysql.sql from jbpm-jpdl-3.2.2.

            But I see that Timer table is not changed with jbpm.jpdl.mysql.sql and so it is not coincide with Timer.hbm.xml from jbpm-jpdl.jar.

            Thank you very much once again and I need to know how to create the database correctly.

            Regards,

            Victor

            • 3. Re: Error on the end of the execution
              Victor Abc Newbie

              I forgot to tell you that if I create the database directly from bpm.jpdl.mysql.sql in jbpm-jpdl-3.2.2 package I get the following error:

              
              2008-04-09 19:39:46,463 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Unknown column 'DESCRIPTION_' in 'field list'
              2008-04-09 19:39:46,563 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22
              2008-04-09 19:39:46,563 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Unknown column 'DESCRIPTION_' in 'field list'
              2008-04-09 19:39:46,623 [main] ERROR org.jbpm.persistence.db.DbPersistenceService - hibernate commit failed
              org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.node.TaskNode]
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
               at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
               at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
               at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
               at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
               at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
               at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131)
               at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122)
               at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
               at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
               at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
               at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
               at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
               at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:256)
               at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:214)
               at org.jbpm.svc.Services.close(Services.java:225)
               at org.jbpm.JbpmContext.close(JbpmContext.java:139)
               at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.instalarProcesos(JBPMSeguimiento.java:67)
               at ar.com.dsv.base.config.BootstrapServlet.init(BootstrapServlet.java:47)
               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
               at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
               at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
               at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
               at org.apache.catalina.core.StandardService.start(StandardService.java:448)
               at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
               at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
               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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
              Caused by: java.sql.SQLException: Unknown column 'DESCRIPTION_' in 'field list'
               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.executeUpdate(PreparedStatement.java:1159)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
               at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
               ... 61 more
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              2008-04-09 19:39:46,884 [main] ERROR org.jbpm.svc.Services - problem closing service 'persistence'
              org.jbpm.persistence.JbpmPersistenceException: hibernate commit failed
               at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:219)
               at org.jbpm.svc.Services.close(Services.java:225)
               at org.jbpm.JbpmContext.close(JbpmContext.java:139)
               at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.instalarProcesos(JBPMSeguimiento.java:67)
               at ar.com.dsv.base.config.BootstrapServlet.init(BootstrapServlet.java:47)
               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
               at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
               at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
               at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
               at org.apache.catalina.core.StandardService.start(StandardService.java:448)
               at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
               at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
               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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
              Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.node.TaskNode]
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
               at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
               at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
               at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
               at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
               at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
               at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131)
               at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122)
               at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
               at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
               at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
               at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
               at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
               at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:256)
               at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:214)
               ... 30 more
              Caused by: java.sql.SQLException: Unknown column 'DESCRIPTION_' in 'field list'
               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.executeUpdate(PreparedStatement.java:1159)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
               at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
               ... 61 more
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              2008-04-09 19:39:47,034 [main] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASLC] - StandardWrapper.Throwable
              org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.node.StartState]
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
               at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
               at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
               at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
               at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
               at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
               at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
               at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
               at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
               at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:77)
               at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
               at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.instalarProcesos(JBPMSeguimiento.java:54)
               at ar.com.dsv.base.config.BootstrapServlet.init(BootstrapServlet.java:47)
               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
               at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
               at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
               at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
               at org.apache.catalina.core.StandardService.start(StandardService.java:448)
               at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
               at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
               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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
              Caused by: java.sql.SQLException: Unknown column 'DESCRIPTION_' in 'field list'
               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.executeUpdate(PreparedStatement.java:1159)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
               at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
               ... 64 more
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              2008-04-09 19:39:47,124 [main] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASLC] - Servlet /SASLC threw load() exception
              java.sql.SQLException: Unknown column 'DESCRIPTION_' in 'field list'
               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.executeUpdate(PreparedStatement.java:1159)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
               at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
               at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
               at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
               at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
               at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
               at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
               at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
               at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
               at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
               at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
               at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
               at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
               at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
               at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
               at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
               at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
               at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:77)
               at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
               at ar.com.dsv.saslc.seguimiento.workflow.jbpm.JBPMSeguimiento.instalarProcesos(JBPMSeguimiento.java:54)
               at ar.com.dsv.base.config.BootstrapServlet.init(BootstrapServlet.java:47)
               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
               at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
               at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
               at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
               at org.apache.catalina.core.StandardService.start(StandardService.java:448)
               at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
               at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
               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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
              Hibernate: select parametro0_.oid as oid, parametro0_.codigo as codigo, parametro0_.valor as valor, parametro0_.estado as estado from parametro parametro0_ where (codigo=? )and(estado=? )
              
              



              • 4. Re: Error on the end of the execution
                Victor Abc Newbie

                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
                
                




                • 5. Re: Error on the end of the execution
                  Victor Abc Newbie

                  I could resolve the problem by manually changing jbpm.jpdl.mysql.sql.

                  In my opinion: salaboy you must response a question if you will follow the thread. That is, if you know the problem in deep. However thank you for your contribution.

                  I hope that my solution to be the correct one.

                  Regards,

                  Victor

                  • 6. Re: Error on the end of the execution
                    Mauricio Salatino Master

                    Sorry for my response...
                    i don't understand what are you trying to say with


                    In my opinion: salaboy you must response a question if you will follow the thread. That is, if you know the problem in deep.


                    I have no deep knowledge about this. I only remember have a similar problem with PostgreSQL, so i answer your question based in my little experience..

                    I wish i have guide you to your solution...

                    Thanks you!