- mike S
- PowerServer
- Monday, 18 March 2024 05:12 PM UTC
PS 2022R2
I'm 99% sure i had a transaction timeout. I was not able to see it in the event viewer/log however. Is it logged? I would expect it to log when a database transaction is killed due to timeout regardless of the log leve.
The time out was set to 1200, which is 20 minutes. I believe the lock was being held for more than 20 minutes however. Its possible the user just keep going in and starting up more transactions locks and then killing the application via task manager or shutdown of the machine.
This is on in azure sql database pool
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.