Build Forge: problem with SQL_Server AutoCommit mode setting
![]()
Hi,
I see errors like the following in the Catalina log: Jul 25, 2013 10:47:57 AM com.buildforge.services.server.db.DBConnection rollback WARNING: Rollback failed, so assuming connection is dead. Jul 25, 2013 10:47:57 AM com.buildforge.services.server.db.DBConnection errorRollback SEVERE: SQL 1564564801 rollback failed: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true". Jul 25, 2013 10:47:57 AM com.buildforge.services.server.api.ServerContext rollbackNoEx WARNING: Rollback failed: com.buildforge.services.common.db.DBException: CRRBF0562I: A failure occurred while trying to [rollback] a database transaction. Is this caused by something we didn't set up right with the database? Just wanted to check here before submitting a PMR. Thanks, Jozef |
2 answers
![]()
Hello,
One thing to check is the this "SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name='build'" The value should return a 1 if set correctly. I am not sure if this is part of it, but it is something easy to check.
For this type of troubleshooting and due to lack of additional information. I would suggest opening a PMR so that the support team can gather additional information to make a better decision.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.