I am trying to create a branch. It gets to the end where it is attempting to commit the transaction, then throws this error:
[10/28/2010 10:34:26 AM] Preparing data to begin transaction
[10/28/2010 10:34:26 AM] Beginning transaction
[10/28/2010 10:34:31 AM] Branch $/webs/schools.connectionsAcademy.com/main
[10/28/2010 10:34:31 AM] Ending the transaction
10/28/2010 10:42:44 AM] Transaction failed
[10/28/2010 10:42:44 AM] An error occurred while trying to end a transaction.
[10/28/2010 10:42:44 AM] Transaction failed
[10/28/2010 10:42:44 AM] Item $/webs/schools.connectionsAcademy.com/main caused the transaction to fail: A database error has occured (FailDBReader)
Please advise.
Error when creating branch
Moderator: SourceGear
Error when creating branch
Connections Academy Software Development Team
Re: Error when creating branch
Can you look in your Vault Server Log found at %windir%\temp\sgvault\sgvault.log for a more detailed error and post it? I suspect a timeout, but the error should confirm that.
To change the SQL timeout, find the vault.config file on the server. It's typically under C:\inetpub\wwwroot\vaultservice. In there is a SQL timeout set for 360. Add another 0 to the end of that number and save the file. To get the file read again, you will need to recycle the Vault app pool. This will disconnect all your users for a minute, so it's best to have your users not uploading or downloading at that time. Open you IIS Manager, expand the Application Pools, right-click Vault AppPool and select Recycle.
To change the SQL timeout, find the vault.config file on the server. It's typically under C:\inetpub\wwwroot\vaultservice. In there is a SQL timeout set for 360. Add another 0 to the end of that number and save the file. To get the file read again, you will need to recycle the Vault app pool. This will disconnect all your users for a minute, so it's best to have your users not uploading or downloading at that time. Open you IIS Manager, expand the Application Pools, right-click Vault AppPool and select Recycle.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support
Re: Error when creating branch
Changing the timeout in the config did it. Thanks Beth!
Connections Academy Software Development Team