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

Sam Mano do-not-reply at jboss.com
Thu Jul 26 17:52:58 EDT 2012 

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120726/f2b950cf/attachment-0001.html

More information about the jboss-user mailing list