Error when Branching

[hwapdc]

Vault version etc:
---17-02-2014 15:46:53 sgvaultsystem--()--
System Started
Version 7.1.0.2028
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = E:\SourceGear\sgVault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 10080
SGVault Working Directory = E:\SourceGear
SGVault Server URL = vault.pdc.xx
Identity = PDC\sa sgvault

Currently we can not branch a (newer) label on a folder.
Web Server and SQL server is working fine. No high CPU or other performance issues.
Please advice.

User log:

[17-02-2014 16:06:00] Ending the transaction
[17-02-2014 16:12:00] An error occurred while trying to end a transaction.
[17-02-2014 16:12:00] An exception was encountered during the transaction. Exception: 1 : Failure at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at VaultClientNetLib.ClientService.VaultService.EndTx(String strTxID, Int32 nTxAction, VaultDateTime& dtTxBegin, Int64& nNewRevision, VaultResponseItem[]& responses)
at VaultClientNetLib.VaultConnection.EndTx(String strTxID, Int64& nNewRevision, VaultResponseItem[]& responses, Int32 nAction, VaultDateTime& txBeginDate)
at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, String strChangeSetComment, Boolean keepCheckedOut, Boolean removeLocalCopy, CommitType committype, VaultDateTime dateImport, Int32 nUserIDImport, Int64& nRevID, Int32[]& retBegEndTx)
[17-02-2014 16:12:00] Transaction failed
[17-02-2014 16:12:50] Transaction failed


Vault log

----17-02-2014 16:11:59 Lars_Juul--lj-1399.pdc.xx(10.117.68.144)--SSL Disabled Critical Error! Object reference not set to an instance of an object.
at VaultServiceBase.VaultLogManager.LogException(Exception e)
at VaultServiceSQL.VaultSqlSCC.CheckSessionBranchSandboxForObliteration(VaultSqlConn conn, String strSessionID)
at VaultServiceAPILib.VaultServiceAPI.EndTx(Int32 nTxUserID, String strTxID, Int32 nTxAction, VaultIntTx vit, VaultDateTime& dtTxBegin, Int64& nNewRevision, VaultResponseItem[]& responses, VaultRepository& repNew)
at VaultService.VaultService.EndTx(String strTxID, Int32 nTxAction, VaultDateTime& dtTxBegin, Int64& nNewRevision, VaultResponseItem[]& responses)
----17-02-2014 16:11:59 Lars_Juul--lj-1399.pdc.xx(10.117.68.144)--SSL Disabled *** Flushing tree cache for RepID 25 ***
----17-02-2014 16:11:59 Lars_Juul--lj-1399.pdc.xx(10.117.68.144)--SSL Disabled (9fa403e4-a27b-4cf1-a11f-21572d18e423) EndTx (Revision - 0) returned: Failure
----17-02-2014 16:11:59 Lars_Juul--lj-1399.pdc.xx(10.117.68.144)--SSL Disabled

[Beth]

Most critical errors can be resolved by clearing out the server-side cache. Just to make sure your client-side cache didn't pick up any of that data, I'm going to have you clear out the client-side cache at the same time.

1) Use the instructions posted here, http://support.sourcegear.com/viewtopic ... 13&t=11513, to clear your client-side cache. It's ok if you either just rename it or go into the cache members and keep the cachemember_workingfolderassisgnments. Don't open Vault after clearing the cache. You'll open that later.

2) Perform an iisreset on your Vault server by going to Start - Run and typing iisreset. If there are other critical websites present that can't be recycled, then let me know and I'll give you alternative instructions.

3) Open your Vault GUI client and try to branch again.

What are your results?

[hwapdc]

Hi
The issue seems to be solved now. SqlCommandTimeout in vault.config has been set to 3600 (ten times longer than default). Secondly some performance issue at SQL server was resolved.

[Beth]

Thank you for the update. I'm happy to hear you're working again.