[jboss-user] [JBoss jBPM] - jBPM 4 CR1 AsyncActivity Unit Test fails due to FK constrain

[joshsiaw]

Hi, I just installed jBPM4 CR1 yesterday and have been trying out the examples and testing the api. I tried to run testAsyncActivity on JUnit and it failed with this error. Btw, I'm using MySQL 5 for the JBPM db.


  | 19:11:49,159 FIN | [ProcessDefinitionImpl] creating new execution for process 'AsyncActivity'
  | 19:11:49,159 FIN | [DefaultIdGenerator] generated execution id AsyncActivity.7
  | 19:11:49,159 FIN | [ExecuteActivity] executing activity(18093512)
  | 19:11:49,174 FIN | [JobExecutorMessageSession] sending message ExecuteActivityMessage
  | 19:11:49,221 FIN | [ExecuteJobCmd] executing job ExecuteActivityMessage[8]...
  | 19:11:49,237 FIN | [ExecuteActivity] executing activity(generate pdf)
  | 19:11:49,237 FIN | [JobExecutorMessageSession] sending message ExecuteActivityMessage
  | 19:11:49,237 FIN | [ExecuteJobCmd] executed job ExecuteActivityMessage[8]
  | 19:11:49,284 FIN | [ExecuteJobCmd] executing job ExecuteActivityMessage[9]...
  | 19:11:49,299 FIN | [ExecuteActivity] executing activity(calculate primes)
  | 19:11:49,299 FIN | [ExecuteActivity] executing activity(end)
  | 19:11:49,299 FIN | [Execution] process-instance ends with state ended
  | 19:11:49,315 FIN | [DbSessionImpl] deleting process instance AsyncActivity.7
  | 19:11:49,315 FIN | [ExecuteJobCmd] executed job ExecuteActivityMessage[9]
  | 19:11:49,315 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000
  | 19:11:49,315 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
  | ### EXCEPTION ###########################################
  | 19:11:49,315 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.jpdl.internal.model.JpdlExecution#7]
  | 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
  | 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
  | 	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
  | 	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
  | 

Basically the test is failing to delete the process instance after the jobs are done and the process reaches the end state. Does anyone have a solution for this problem? Did I setup my db connection incorrectly?

Any help would be appreciated. Thanks.

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

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