Problem deleting a process containing a subProcess
Hi,
I'm using JBPM 3.1.2 and I have a process containing 1 sub process.
When my processInstance has finished , I've put
graphSession.deleteProcessInstance(processInstance.getId());
But I have the error following :
12:45:18,408 ERROR [TaskThread] The process throws exception on close:
12:45:18,408 INFO [STDOUT] org.jbpm.JbpmException: problem closing services {persistence=org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session}
12:45:18,408 INFO [STDOUT] at org.jbpm.svc.Services.close(Services.java:223)
12:45:18,408 INFO [STDOUT] at org.jbpm.JbpmContext.close(JbpmContext.java:139)
12:45:18,408 INFO [STDOUT] at com.editag.web.business.bean.TaskThread.run(TaskThread.java:112)
12:45:18,408 INFO [STDOUT] Caused by: org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session
12:45:18,408 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:172)
12:45:18,408 INFO [STDOUT] at org.jbpm.svc.Services.close(Services.java:211)
12:45:18,408 INFO [STDOUT] ... 2 more
12:45:18,408 INFO [STDOUT] Caused by: org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.graph.exe.Token#2355]
12:45:18,408 INFO [STDOUT] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
12:45:18,408 INFO [STDOUT] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
12:45:18,428 INFO [STDOUT] at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2307)
12:45:18,428 INFO [STDOUT] at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2439)
12:45:18,428 INFO [STDOUT] at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
12:45:18,428 INFO [STDOUT] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
12:45:18,428 INFO [STDOUT] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
12:45:18,428 INFO [STDOUT] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
12:45:18,428 INFO [STDOUT] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
12:45:18,428 INFO [STDOUT] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
12:45:18,428 INFO [STDOUT] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
12:45:18,428 INFO [STDOUT] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
12:45:18,428 INFO [STDOUT] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
12:45:18,428 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:162)
12:45:18,428 INFO [STDOUT] ... 3 more
12:45:18,428 INFO [STDOUT] Caused by: java.sql.SQLException: Integrity constraint violation FK_PROCIN_SPROCTKN table: JBPM_PROCESSINSTANCE in statement [delete from JBPM_TOKEN where ID_=? and VERSION_=?]
12:45:18,428 INFO [STDOUT] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
12:45:18,428 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
12:45:18,438 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
12:45:18,438 INFO [STDOUT] at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2293)
12:45:18,438 INFO [STDOUT] ... 14 more
I've found answers to my question for more recently versions but I can't change my version. Can someone help me ?
Thank you.
