Hi
I urgently need to solve the following problem:
When I update code, using Outsystems 10 for a mobile device, and publish it, and then try to open my Mobile App using Outsystems Now, I get the following error on my App screen:
'There was an error processing your request'
"RELOAD"
On Outsystem in Monitoring/Errors, the following errors are shown:
unable to begin transaction: sqlite3_step failure: cannot start a transaction within a transaction
Failed to execute canary query (probably due to zombie transaction)
Can anybody please advise me how to prevent these errors from occurring?
And this will keep on happening, unless I leave the device off for an hour or so, and then I can actually use the device again.
BUT: it does not always happen.
Best Regards
Anneliese
Hi Anneliese,
Can you send a screenshot of your code?
Thanks,
FV
Fábio Vaz wrote:
Hi Fabio
It is unfortunately not possible - it is a big application and I can not send you all the code. I have no idea where in my code this happens and why. We also have integrations to other systems.
I was hoping that someone else has encountered a similar problem previously and could point me in the correct direction. The problem is also that it would not happen for weeks, and then suddenly it happens again.
I know it will be part of the login process.
So I just needed a pointer as to what the probable issue could be.
The question is also:
How do I ensure I do not have zombie transactions when I login?
Regards
Hi,
You already try do a debug when you begin your app? Is a mobile APP right?
And you can also try see if you have some transations with
SELECT * FROM sys.sysprocesses WHERE open_tran = 1
In Sql Management
Anneliese Scheurkogel wrote:
Same here, we're having the same issue whenever we publish new version to production. User tried to update the app as a usual procedure but when it goes back it's the same error message as
Anneliese encountered. See attached screenshot.
I have the same issue.
Seems like it happens when local storage tables changed but the device does not update accordingly.
https://www.outsystems.com/forums/discussion/22911/cant-use-version-control/ (Read right at the bottom of this post)
I will also try the above and let you know.