FailDBReader from VS2010/Vault 6

[DaveG]

Hi,
I've just upgraded from Vault Standard v5.1.2.19281 to v6.0.1.598 (64-bit). Vault Client shows all my projects just fine.
Now when I start Visual Studio 2010 (10.0.40219.1 SP1Rel) and attempt to Go Online to Vault, I get a FailDBReader error as shown below.
I use SQL Server 2008 R2 64-bit on Windows 7 Ultimate 64-bit.

I'm stuck. Can you throw any light?


# SourceGear Vault Server
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled Login
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
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, Boolean bOKToSendAsFile, 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 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, Boolean bOKToSendAsFile, 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)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
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, Boolean bOKToSendAsFile, 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 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, Boolean bOKToSendAsFile, 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)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled VaultLib.VaultBuildTreeException: Error in the application.
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled System.InvalidOperationException: Invalid attempt to read when no data is present.
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetBoolean(Int32 i)
at VaultServiceSQL.VaultAdminSQL.ListRepositoryOptions(VaultSqlConn conn, VaultRepositoryOptions vOptions) at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.GetBoolean(Int32 i)
at VaultServiceSQL.VaultAdminSQL.ListRepositoryOptions(VaultSqlConn conn, VaultRepositoryOptions vOptions)
----19/09/2012 20:02:04 admin--Flash.lan(192.168.1.78)--SSL Disabled FailDBReader

[lbauer]

There may be some cached information that is out of sync with the database.

Here's what I recommend:

Close any open clients.

Go to the path %USERPROFILE%\Local Settings\Application Data\SourceGear\Vault_1 or Users\Appdata\local\SourceGear\Vault_1 and delete or rename the entire Vault_1 folder. Restart IIS to clear the Vault Server cache before you log in again. Use the iisreset command from a command prompt.

You will need to reset working folders and perform a Get Latest with Do Not Overwrite/MergeLater to re-establish baselines, rebuild the cache files and reset file status.

If you have a lot of modified files in the working directories, back those up first, then replace them in the working folders after you've done the Get Latest.

A quicker, but possibly not as effective solution would be to just restart IIS and see if that clears up the application error.

[DaveG]

Hi Linda,
I followed your instructions to the letter but it was unsuccessful I'm afraid. The error in the log was identical.
Today I will uninstall/reinstall and try again.
Thanks for trying.

[lbauer]

Before you uninstall/reinstall the server:

Do you get the same errors when using the Vault GUI Client?

"Error in the application" can also be a database issue.

Could provide the result of this sql query:

select * from sgvault.dbo.tblschemaversions