No Active Transaction in Progress

[Former Member]

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

[Former Member]

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

[Former Member]

> 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

[Former Member]

Hi Madhu,

I faced this issue from PL 25 itself. In my analysis, the InTransaction is not working. I raised a note and they said it was fixed in PL 27.

One possible way to solve (Suits New Development):

Do not use Company.InTransaction and use your own global boolean variable. In already existing applications we can try find replace but it require careful testing. This directly affect support budget.

I AM REALLY SURPRISED HOW COME SAP IS SO LIGHT HEADED?

If this happening in new development, we can change the logic and we can do something. If already working add-ons are failing by upgrading how do we face the customer. These bugs are stopping their business and sap know the value of business. Is anyone from SAP can give the candid reply why this is happening and when it can be solved? We also involved in development and bugs are common in development. But we will be little serious about issues.

Ravi Shankar B

[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.