topic Error- This sqlTransaction has completed; it is no longer usable in Product Forum

Error- This sqlTransaction has completed; it is no longer usable

ritansh.jatwani — Wed, 27 Jan 2021 08:10:13 GMT

Hi Team,

"This sqlTransaction has completed; it is no longer usable". I am getting this error and the bot is getting terminated due to this error. Can anyone let me know the reason for this error?

Re: Error- This sqlTransaction has completed; it is no longer usable

PvD_SE — Fri, 29 Jan 2021 11:21:44 GMT

Hi R,

Please describe what you are trying to do and what action appears to causing your problem? What does the Log say?

Re: Error- This sqlTransaction has completed; it is no longer usable

SandeepNalla — Wed, 10 Feb 2021 18:54:08 GMT

We got the same issue today in prod while running the "untag item" action on the queue item. This never came up till now, the process was running fine since almost a month.

Can someone help?

Re: Error- This sqlTransaction has completed; it is no longer usable

zdenek.kabatek — Mon, 15 Feb 2021 07:56:34 GMT

Hi,

if we are to help you we would definitely need to know more information, i.e. what BP version you are running, under which circumstances it has happened (Sandeep wrote during untaging), however, we don't know the BP version.

Regards,

Zdenek

Re: Error- This sqlTransaction has completed; it is no longer usable

AndreyKudinov — Wed, 19 May 2021 09:50:02 GMT

I had this error in my process once. Another process getting this rather frequently. Support is suggesting we might be untagging outside of the process owning lock, but it is not the case.
Typical scenario: Get Item, Do some work, Update data, Tag, Untag, Unlock/Mark - everything works fine, except Untag failing with that error. Worked fine in 6.5.1, happens on 6.10.1 - likely related to some changes, we didnt check on 7.0 yet (one changelog entry seems promising).

I could reproduce this with a simple test case on 2 concurrent running bots - one crashes within first minute. We'll add this to a ticket. I'll try to update if we get some news.