PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/12/2016 6:52 PM by  Lilyb
tsBeginDBTransaction error is Operation illegal while in transaction (20).
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lilyb
Analyst
Private
New Member
(5 points)
New Member
Posts:3


Send Message:

--
05/12/2016 6: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
    Private
    Private
    Veteran Member
    (823 points)
    Veteran Member
    Posts:287


    Send Message:

    --
    05/12/2016 6: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
    Analyst
    Private
    New Member
    (5 points)
    New Member
    Posts:3


    Send Message:

    --
    05/12/2016 6:52 PM
    It worked!  Thank you very much!
    You are not authorized to post a reply.