[jboss-user] [JBoss jBPM] - Re: Problem deleting a process containing a subProcess

[dd974]

Hi, 

I've change to JBPM 3.2.GA but my problem is still there. 
I have the error : 

anonymous wrote : 
  | 3:06:03,439 ERROR [JDBCExceptionReporter] Integrity constraint violation FK_PROCIN_SPROCTKN table: JBPM_PROCESSINSTANCE in statement [delete from JBPM_TOKEN where ID_=? and VERSION_=?]
  | 13:06:03,439 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.graph.exe.Token#11]
  | 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
  | 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2307)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2439)
  | 	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
  | 	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
  | 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
  | 	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  | 	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
  | 	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
  | 	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
  | 	at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:253)
  | 	at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:211)
  | 	at org.jbpm.svc.Services.close(Services.java:222)
  | 	at org.jbpm.JbpmContext.close(JbpmContext.java:139)
  | 	at com.editag.process.ProcessExecutorThread.run(ProcessExecutorThread.java:193)
  | Caused by: java.sql.SQLException: Integrity constraint violation FK_PROCIN_SPROCTKN table: JBPM_PROCESSINSTANCE in statement [delete from JBPM_TOKEN where ID_=? and VERSION_=?]
  | 	at org.hsqldb.jdbc.Util.throwError(Unknown Source)
  | 	at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
  | 	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2293)
  | 	... 15 more
  | 13:06:03,449 ERROR [DbPersistenceService] hibernate commit failed
  | org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.graph.exe.Token#11]
  | 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
  | 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2307)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2439)
  | 	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
  | 	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
  | 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
  | 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
  | 	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  | 	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
  | 	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
  | 	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
  | 	at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:253)
  | 	at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:211)
  | 	at org.jbpm.svc.Services.close(Services.java:222)
  | 	at org.jbpm.JbpmContext.close(JbpmContext.java:139)
  | 	at com.editag.process.ProcessExecutorThread.run(ProcessExecutorThread.java:193)
  | Caused by: java.sql.SQLException: Integrity constraint violation FK_PROCIN_SPROCTKN table: JBPM_PROCESSINSTANCE in statement [delete from JBPM_TOKEN where ID_=? and VERSION_=?]
  | 	at org.hsqldb.jdbc.Util.throwError(Unknown Source)
  | 	at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
  | 	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2293)
  | 	... 15 more
  | 
  | 

Can anyone help me ? 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067783#4067783

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067783