Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved transaction timeout - is this logged?

  1. How-to
0
Votes
Undo
  1. mike S
    mike S
  2. PowerServer
  3. Monday, 18 March 2024 17: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

 

web api on linux
A new version of cloud app launcher is available
Accepted Answer
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 19 March 2024 02:47 AM UTC
  2. PowerServer
  3. # Permalink

Hi Mike,

In PS 2022R2 and earlier releases, you need to configure the Logging.json in the C# solution manually to enable this transaction timeout log:

// Sets whether to output logs related with transaction status changes
"EnableTransactionLog": true

In PS 2022R3 and later, the logging feature has been optimized: it will output a transaction time out warning to log by default. You can write a small case to verify it.

Regards, Logan

 

Comment
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 18 March 2024 19:56 PM UTC
  2. PowerServer
  3. # 1

Hi Mike;

  If that was a DB Timeout, then you should see that in the Power Server's log.

  If the timeout was HTTP related, then you should see that in the Web Server's log.

Regards.... Chris 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.