Unable to Get Label at Root of Branch

wesuser · Post by **wesuser** » Wed Mar 01, 2006 1:33 pm

I had labelled the entire branch (Root folder) under a version number. Since then changes have been made to the branch.

I'm trying to get the labelled version back to my working folder, so I went to Show Labels and right clicked on the Folder which I labelled and selected Get...I see the hourglass go and the window which usually comes up to confirm the path never came up...eventually the hourglass goes away after like 5 or so minutes and nothing happened?

Currently using Version 3.1.2 (3511)

lbauer · Post by **lbauer** » Wed Mar 01, 2006 1:38 pm

Are Vault Server and Client both 3.1.2?

Can a different user get the label?

Anything in the Vault Server log file (%\windir\temp\sgvault) that corresponds to the failure? Anything in the GUI Client messages pane?

wesuser · Post by **wesuser** » Wed Mar 01, 2006 1:57 pm

The Server & Client are both on 3.1.2

Nothing came up on the GUI client message pane.

This is a section of what came up on the Vault Server Log:

----3/1/2006 2:14:51 PM ThomasYeh--wsin044.pointclickcare.local(192.168.1.215)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at VaultServiceSQL.VaultSqlSCC.GetRepositoryTreeDelta(VaultSqlConn conn, Int32 nRepID, Hashtable htSharedItems, Int64 nBaseRevID, Int64 nTargetRevID, VaultRepositoryDelta& rep) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at VaultServiceSQL.VaultSqlSCC.GetRepositoryTreeDelta(VaultSqlConn conn, Int32 nRepID, Hashtable htSharedItems, Int64 nBaseRevID, Int64 nTargetRevID, VaultRepositoryDelta& rep)

----3/1/2006 2:14:51 PM ThomasYeh--wsin044.pointclickcare.local(192.168.1.215)--SSL Disabled GetRepositoryStructure returned: FailInvalidRevision

----3/1/2006 2:15:38 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled Login

----3/1/2006 2:15:39 PM MeganMerchant--wsin090.pointclickcare.local(192.168.1.118)--SSL Disabled Logout

----3/1/2006 2:16:17 PM JaimesBlunt--wsin050.pointclickcare.local(192.168.1.142)--SSL Disabled Logout

----3/1/2006 2:16:28 PM AndrewJaimes--wsin064.pointclickcare.local(192.168.1.217)--SSL Disabled Logout

----3/1/2006 2:17:29 PM JoannePolsky--localhost.pointclickcare.local(192.168.1.229)--SSL Disabled Logout

----3/1/2006 2:17:37 PM AndrewJaimes--wsin064.pointclickcare.local(192.168.1.217)--SSL Disabled Login

----3/1/2006 2:18:07 PM ThomasYeh--wsin044.pointclickcare.local(192.168.1.215)--SSL Disabled Logout

----3/1/2006 2:21:54 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at VaultServiceSQL.VaultSqlSCC.LockRepository(VaultSqlConn conn, Int32 nRepID) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at VaultServiceSQL.VaultSqlSCC.LockRepository(VaultSqlConn conn, Int32 nRepID)

----3/1/2006 2:21:54 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled Failed to acquire repository lock: Error in the application.

----3/1/2006 2:21:54 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled (6fbf57b2-f99b-4744-af3c-f702d56f6ed0) EndTx (Revision - 0) returned: FailRepLockAttempt

----3/1/2006 2:21:54 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled (6fbf57b2-f99b-4744-af3c-f702d56f6ed0) CheckIn: $/PCC/PCCWeb/admin/reports/clientbillsetup.jsp returned: FailRepLockAttempt

----3/1/2006 2:22:03 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled Logout

----3/1/2006 2:22:16 PM PouriaTehrani--wsin040.pointclickcare.local(192.168.1.177)--SSL Disabled Login

----3/1/2006 2:22:22 PM ReidMain--wsin016.pointclickcare.local(192.168.1.131)--SSL Disabled Logout

----3/1/2006 2:24:21 PM AndrewJaimes--wsin064.pointclickcare.local(192.168.1.217)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at VaultServiceSQL.VaultSqlSCC.BeginLabelQuery(VaultSqlConn conn, String strSessionID, Int32 nRepID, Int32 nUserID, String strLCItemPath, Int64 nObjID, UInt16 nObjType, Boolean bGetRecursive, Boolean bGetInherited, UInt16 nObjTypeFlags, Int32 nRowLimit, Int32& nRowsRetrieved, Int32& nRowsRetrievedRecursive, String& strQryToken) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at VaultServiceSQL.VaultSqlSCC.BeginLabelQuery(VaultSqlConn conn, String strSessionID, Int32 nRepID, Int32 nUserID, String strLCItemPath, Int64 nObjID, UInt16 nObjType, Boolean bGetRecursive, Boolean bGetInherited, UInt16 nObjTypeFlags, Int32 nRowLimit, Int32& nRowsRetrieved, Int32& nRowsRetrievedRecursive, String& strQryToken)

----3/1/2006 2:24:21 PM AndrewJaimes--wsin064.pointclickcare.local(192.168.1.217)--SSL Disabled BeginLabelQuery returned: FailDBInsert

----3/1/2006 2:30:59 PM JohnButt--wsin100.pointclickcare.local(192.168.1.245)--SSL Disabled Logout

----3/1/2006 2:33:53 PM ThomasYeh--wsisvr_qabuild.pointclickcare.local(192.168.1.174)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at VaultServiceSQL.VaultSqlSCC.GetLabelStructure(VaultSqlConn conn, Int32 nUserID, Int32 nRepID, Int64& nLabelID, String& strLabel, String strItemPath, Int64 nObjID, UInt16 nObjType, String strLabelSubPath, Int64& nRootObjID, DateTime& dtLastChg, StringCollection& scLabelPaths, VaultFolder& vfLabel, VaultFile& vfFile) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at VaultServiceSQL.VaultSqlSCC.GetLabelStructure(VaultSqlConn conn, Int32 nUserID, Int32 nRepID, Int64& nLabelID, String& strLabel, String strItemPath, Int64 nObjID, UInt16 nObjType, String strLabelSubPath, Int64& nRootObjID, DateTime& dtLastChg, StringCollection& scLabelPaths, VaultFolder& vfLabel, VaultFile& vfFile)

----3/1/2006 2:33:53 PM ThomasYeh--wsisvr_qabuild.pointclickcare.local(192.168.1.174)--SSL Disabled GetLabelStructure returned: FailDBReader

lbauer · Post by **lbauer** » Thu Mar 02, 2006 10:08 am

It looks like the connection to SQL Server is timing out before the operation can complete.

Try increasing the SQL timeout value in the Vault.config file:

<SqlCommandTimeout>360</SqlCommandTimeout>

The default is 360 (seconds). Increase it to 720 and see if that helps.