Serious Errors

[BradleyUffner]

We are currently using vault 4.0.4. Everything was working perfectly today, until I tried to check in a file at the end of the day. I received an error that the connection to the server was lost. I closed visual studio and reopened it. At this point vault threw up about 30 error dialogs before visual studio stopped responding and needed to be closed. The error was a standard "could not connect to the server" type error. I restarted my computer and tried again with the exact same results. I tried then tried the stand alone client. After picking the default repository I was presented with "You do not have rights in the selected repository" error. Which is wrong, my account has full admin access within vault, and repository security is not enabled.

I then tried to open the vault admin web page, which seemed to be working OK, until I tried to browse the default repository from the web interface. When I do that I receive a plain error message of "Error in the application. " with no details. I can open other repositories just fine through the web interface.

This is a copy of vaults log file trying to view the default repository from the web client.:

# SourceGear Vault Server
----10/16/2007 9:42:32 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultServiceSQL.VaultDbTreeException: An error was encountered looking up the owner of a folder or file for the source code tree. The tree was not built. Base TreeRevision: 0 Target TreeRevision: 6115 TreeLevel: 6 ParentObjVerID: 58704 ObjID: 16986 ObjVersion: 2 Name: frmMain.resx PinFrom: 0 ParentPathHash: 0x328E3B225C98DA401E92A65F6CA6AC12 PathHash: 0x00000000000000000000000000000000
at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep) at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
----10/16/2007 9:42:32 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(Int32 nRepID, VaultRepository& repOut)
at VaultService.VaultWeb.ShowFolderGrid.DisplayGrid()
at VaultService.VaultWeb.ShowFolderGrid.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(Int32 nRepID, VaultRepository& repOut)
at VaultService.VaultWeb.ShowFolderGrid.DisplayGrid()
at VaultService.VaultWeb.ShowFolderGrid.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

this is a server log of trying to access the repository from the stand alone client:

# SourceGear Vault Server
----10/16/2007 9:46:04 PM sgvaultsystem--()--
System Started
Version 4.0.3.15836
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL =
Identity = NT AUTHORITY\NETWORK SERVICE
----10/16/2007 9:46:11 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled Login
----10/16/2007 9:46:17 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultServiceSQL.VaultDbTreeException: An error was encountered looking up the owner of a folder or file for the source code tree. The tree was not built. Base TreeRevision: 0 Target TreeRevision: 6115 TreeLevel: 6 ParentObjVerID: 58704 ObjID: 16986 ObjVersion: 2 Name: frmMain.resx PinFrom: 0 ParentPathHash: 0x328E3B225C98DA401E92A65F6CA6AC12 PathHash: 0x00000000000000000000000000000000
at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep) at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
----10/16/2007 9:46:17 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss) at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss)
----10/16/2007 9:46:18 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultServiceSQL.VaultDbTreeException: An error was encountered looking up the owner of a folder or file for the source code tree. The tree was not built. Base TreeRevision: 0 Target TreeRevision: 6115 TreeLevel: 6 ParentObjVerID: 58704 ObjID: 16986 ObjVersion: 2 Name: frmMain.resx PinFrom: 0 ParentPathHash: 0x328E3B225C98DA401E92A65F6CA6AC12 PathHash: 0x00000000000000000000000000000000
at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep) at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
----10/16/2007 9:46:18 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss) at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss)
----10/16/2007 9:46:20 PM buffner--10.1.10.10(10.1.10.10)--SSL Disabled VaultServiceSQL.VaultDbTreeException: An error was encountered looking up the owner of a folder or file for the source code tree. The tree was not built. Base TreeRevision: 0 Target TreeRevision: 6115 TreeLevel: 6 ParentObjVerID: 58704 ObjID: 16986 ObjVersion: 2 Name: frmMain.resx PinFrom: 0 ParentPathHash: 0x328E3B225C98DA401E92A65F6CA6AC12 PathHash: 0x00000000000000000000000000000000
at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep) at VaultServiceSQL.VaultRepUtil.BuildTree(SqlDataReader dr, Int64 nBaseRevID, Int64 nTargetRevID, Hashtable htSharedHints, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int32 nTxAction, Boolean bTxDirectModified, Int64 nRootPinFromObjVerID, VaultFolder& vfRoot)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryTree(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Boolean bNeedCurrentHashes, VaultRepository& rep)

We are currently totally unable to access this repository. I have tried restarting the server, restarting IIS, and clearing temp and cache files, but nothing seems to fix the problem.

[lbauer]

Something is preventing the tree from being built. Email support at sourcegear.com ATTN Linda and we'll do further troubleshooting offline.

HS: 169002

[itperson]

could you help me?
I need the solution about this issue.
Please share the solution for it.
thank you very much.

[Beth]

This user restored a backup of his database. I see your other post here, http://support.sourcegear.com/viewtopic.php?f=5&t=21853, and will be responding there.