Prev
Next
Forums Integration / Customization S3 Customization/Development

tsBeginDBTransaction error is Operation illegal while in transaction (20).

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Lilyb
New Member
Posts: 3
New Member
5/12/2016 10:33 PM

    I'm developing a custom program (update job) to invoke a copy of AP30.3, and keep getting the following error:

    File SYSTEST/TXTAXTABLE.

    tsBeginDBTransaction error is Operation illegal while in transaction (20).

    Does anyone know what this means and how to fix it?

    Thank you

    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    5/12/2016 10:47 PM
      Do you have a 910-AUDIT-BEGIN in your PD? When logic encounters that, it places the DB in a "transaction state".
      Chances are that AP30.2 does its own 910-AUDIT-BEGIN. Transaction within a transaction state not allowed

      You will need to break them up.
      In your PD
      910-AUDIT-BEGIN
      do all necessary updated
      920-AUDIT-END

      INVOKE AP30.3

      or if the only update is via AP30.3, you don't need the 910-AUDIT-BEGIN or END in your PD
      Lilyb
      New Member
      Posts: 3
      New Member
      5/12/2016 10:52 PM
        It worked!  Thank you very much!