Why do I see the error "Snapshot isolation transaction failed accessing database" in my FrontendServer log file when I attempt to copy a project?

0 Likes

Problem:

Why do I see the error "Snapshot isolation transaction failed accessing database" in my FrontendServer log file when I attempt to copy a project?

Resolution:

This error occurs because snapshot isolation has not been enabled on the database being used by SilkCentral Test Manager. The full error message which is displayed in the FrontendServer.log file should be similar to:


"export/import of project 2 failed java.util.concurrent.ExecutionException: java.sql.SQLException: Snapshot isolation transaction failed accessing database "SCTM" because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation."


Note the statement "Snapshot isolation transaction failed accessing database "SCTM" because snapshot isolation is not allowed in this database" and "Use ALTER DATABASE to allow snapshot isolation". This last statement describes how to resolve this issue, snapshot isolation must be enabled for the database. In order to enable snapshot isolation there are instructions at the following Microsoft article: xhttp://msdn.microsoft.com/en-us/library/tcbchxcb.asp


Note: Make sure to create a back-up copy of your database before making any changes.

Old KB# 30674
Comment List
Anonymous
Related Discussions
Recommended