Options
  • State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 1441 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Snapshot isolation error

konst

Hello,

We just started getting the following intermittent error from an event handler script:

Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.SCRIPTVARIABLES' directly or indirectly in database 'RWJBarnabas' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement. (ERROR: 3960, SQLSTATE: 42000)

After a re-try the transaction works but I still want to fix it.  Is anybody familiar with this error, I assume it could be related to settings on SQL server but I need more details before I check with the database team.

Any help would be appreciated!

Thanks!

  • 0

    This is would be something you want to engage our Support Team (support@m-files.com) on.

    This is likely caused by the script (or scripts) trying to edit something that has already been edited but before the first transaction has been completed.

  • 0 in reply to Wesley Weir

    Thank you for your response, I was just wondering, what is stored in dbo.SCRIPTVARIABLES table, is it related to values accessed by VaultSharedVariables in scripts?

  • 0

    Hello konst ,I am having the same error now

    Error:

    Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.DOCUMENTFILEVERSION' directly or indirectly in database 'XYZ_XYZ to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement.(ERROR: 3960, SQLSTATE: 42000) 

    We are analyzing the SQL engine configurations specifically using "read commited" at the "Isolation Level"




              

© M-Files Corporation 2024 | Privacy Policy