• 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!