5 Replies Latest reply on Apr 3, 2007 7:24 PM by dslevine

    jBPM 3.1 w Spring, integrity constraint violations (JBPMUSER

      Using jBPM with Spring and Hibernate, I am sometimes getting:

      java.sql.BatchUpdateException: ORA-02291: integrity constraint (JBPMUSER.FK_LOG_TASKINST) violated - parent key not found

      When signalling/ending a task. Only sometimes though, and seemingly randomly. Some notable behaviour:

      - The task-assign gets triggered on the new task, before it errs and reverts back to the old task. (Aside: I send emails on new task assign, which is non-roll-back-able. What should I be using for an alert email post-commit?)

      - After getting the error and things "all" rolling back (?), I can resubmit the exact same operation and it succeeds the second time.

      I'm using Hibernate 3.1 still.

      I'm thinking that it might have to do with Spring transaction management, and am tracing through the source but having a hard time discerning the problem. If others have experienced similar issues please share your war stories.

      Thanks!