[jboss-user] [jBPM] - Re: JBPM5.3-installer, jbpm-console persistence error

Sam Mano [https://community.jboss.org/people/artist123] created the discussion "Re: JBPM5.3-installer, jbpm-console persistence error" To view the discussion, visit: https://community.jboss.org/message/750579#750579 -------------------------------------------------------------- add to my privious post... after restate the all and try using the ant start.demo.db... I go the following error... :\JBPM\jbpm-installer>ant start.demo.db uildfile: D:\JBPM\jbpm-installer\build.xml heck.jboss.version: ownload.db.driver.check:     [echo] Checking if db driver jar has been downloaded ... ownload.mysql.driver: nstall.db.files:    [mkdir] Created dir: D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main     [copy] Copying 1 file to D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main     [copy] Copying 1 file to D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main tart.jboss: heck.jboss.version: tart.jboss5: heck.jboss.version: tart.jboss7: tart.human.task:    [javac] D:\JBPM\jbpm-installer\build.xml:844: warning: 'includeantruntime' was not set, defaulting to build.sysclass ath=last; set to false for repeatable builds     [java] 0    26/07 17:48:42,883[main] ERROR hibernate.util.JDBCExceptionReporter.logExceptions  - Table 'task.organi ationalentity' doesn't exist     [java] 0    26/07 17:48:42,883[main] ERROR event.def.AbstractFlushingEventListener.performExecutions  - Could not s nchronize database state with session     [java] org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)     [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321)     [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)     [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)     [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)     [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)     [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 )     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)     [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)     [java]     ... 14 more     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:516)     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)     [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)     [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)     [java]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)     [java]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)     [java]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)     [java]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)     [java]     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)     [java]     ... 17 more     [java] 30   26/07 17:48:42,913[main] WARN  service.persistence.TaskLocalTransactionManager.commit  - Unable to begi transaction     [java] javax.persistence.RollbackException: Error while commiting the transaction     [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 )     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)     [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321)     [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)     [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)     [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)     [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)     [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)     [java]     ... 6 more     [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)     [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)     [java]     ... 14 more     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:516)     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)     [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)     [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)     [java]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)     [java]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)     [java]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)     [java]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)     [java]     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)     [java]     ... 17 more     [java] 110  26/07 17:48:42,993[main] ERROR service.persistence.TaskPersistenceManager.endTransaction  - Unable to c mmit, rolling back transaction.     [java] java.lang.RuntimeException: Unable to commit transaction     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 59)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 )     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] Caused by: javax.persistence.RollbackException: Error while commiting the transaction     [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55)     [java]     ... 5 more     [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)     [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)     [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321)     [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)     [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)     [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)     [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)     [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)     [java]     ... 6 more     [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)     [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)     [java]     ... 14 more     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:516)     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)     [java]     at com.mysql.jdbc.Util.getInstance(Util.java:386)     [java]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)     [java]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)     [java]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)     [java]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)     [java]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)     [java]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)     [java]     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)     [java]     at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)     [java]     ... 17 more     [java] 210  26/07 17:48:43,093[main] WARN  service.persistence.TaskLocalTransactionManager.rollback  - Unable to ro lback transaction     [java] java.lang.IllegalStateException: Transaction not active     [java]     at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 )     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] 300  26/07 17:48:43,183[main] WARN  service.persistence.TaskLocalTransactionManager.rollback  - Unable to ro lback transaction     [java] java.lang.IllegalStateException: Transaction not active     [java]     at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.rollBackTransaction(TaskPersistenceManager.j va:97)     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:984)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] 320  26/07 17:48:43,203[main] ERROR service.persistence.TaskPersistenceManager.rollBackTransaction  - Unable to rollback transaction (or to mark as 'to rollback')!     [java] java.lang.RuntimeException: Unable to rollback transaction     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:77)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.rollBackTransaction(TaskPersistenceManager.j va:97)     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:984)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] Caused by: java.lang.IllegalStateException: Transaction not active     [java]     at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70)     [java]     ... 5 more     [java] Exception in thread "main" java.lang.RuntimeException: Could not commit transaction     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:994)     [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957)     [java]     at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119)     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)     [java] Caused by: java.lang.RuntimeException: Unable to rollback transaction     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:77)     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 )     [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)     [java]     ... 3 more     [java] Caused by: java.lang.IllegalStateException: Transaction not active     [java]     at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70)     [java]     ... 5 more     [java] Java Result: 1 tart.demo.db: UILD SUCCESSFUL  -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/750579#750579] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]