Skip to Content
author's profile photo Former Member
Former Member

No Active Transaction in Progress

Hi,

We are working on SAP2005 patch27. We developed an application with earlier patches of SAP2005.

In a Method we are calling like this

Pcompany.StartTransaction

try

Some Codes inside

If Pcompany.InTransaction

pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Commit)

End if

Catch

If Pcompany.InTransaction

pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Rollback)

End if

The above code worked in earlier patches. In this Patch it is not working.

When We check the transaction is still active by this statement "Pcompany.InTransaction" it says it is true. But when we try to execute the next line " pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Commit)

" We are getting an error "No Active Transaction in Progress".

If we use "pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Rollback)"

No Errors are coming up.

Please help me on this.

Thanks in Advance

Madhu

End try

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2007 at 06:44 AM

    > Hi,

    > We are working on SAP2005 patch27. We developed an

    > application with earlier patches of SAP2005.We are using SQL2000 Database

    > n a Method we are calling like this

    >

    > Pcompany.StartTransaction

    > try

    > Some Codes inside

    > If Pcompany.InTransaction

    >

    > Company.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Comm

    > it)

    > End if

    > atch

    > If Pcompany.InTransaction

    > pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Rol

    > lback)

    > End if

    >

    > The above code worked in earlier patches. In this

    > Patch it is not working.

    >

    > When We check the transaction is still active by

    > this statement "Pcompany.InTransaction" it says it

    > is true. But when we try to execute the next line "

    > pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Com

    > mit)

    > " We are getting an error "No Active Transaction in

    > Progress".

    >

    > If we use

    > "pCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Ro

    > llback)"

    > No Errors are coming up.

    >

    > Please help me on this.

    > Thanks in Advance

    >

    >

    > Madhu

    >

    >

    > End try

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      I've got the feedback from SAP. The problem was with the SBO_SP_TransactionNotification procedure.

      I don't know how (I didn't make any changes on it) but it was altered from the original one.

      select @error, @error_message was missing.

      i just get the one from the default database, and now it works.

      I guess Rasmus post explain the differences.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2007 at 07:42 AM

    I have the same problem (with PL29 and 31) but not with PL27

    I opened a note on the marketplace, and I'm still waiting for an update

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.