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

[dd974]

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 :

anonymous wrote : 
  | 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.


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

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