• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
Posts: 3
New Member
5/12/2016 10:52 PM
It worked!  Thank you very much!