0 Replies Latest reply on Jul 29, 2014 3:07 PM by hdost3

    Issues with GetActiveUnitOfWork - key violation

    hdost3

      I have a BPEL which has been fine without a single transaction, but there is a desire to use a single transaction and therefore GetActiveUnitOfWork. All Adapters have Get Active Unit Of Work enabled. I am working to duplicate information from one database ("Source") and to another ("Target"). There are foreign key relationships between three tables Top 1->many Middle 1->many Bottom

       

      The flow of the BPEL is as such:

      1. Select from Source Top

      2. Select from Target Top

      3. Compare and insert the set subtraction (Source - Target)

      4. Select from Source Middle

      5. Select from Target Middle

      6. Compare and insert the set subtraction (Source - Target)

      7. Select from Source Bottom

      8. Select from Target Bottom

      9. Compare and insert the set subtraction (Source - Target)

       

      When the process completes it rolls back because of a foreign key relation violation. It states that the Bottom's foreign key has been violated more specifically. Any Advice would be wonderful.