Fortress Server "Flaky"

[chris.bradley]

In the last few days of doing some offsite development we've found our Fortress Server had become a little "flaky". I'll admit it could totally just be a bad network connection back to the fortress server, but it seems like it's getting worse. On a whim, I decided to check the fortress server log. Can anyone advise if any of these errors could be causing my issues?

We've also been getting a ton of errors about the number of web users exceeding the number licensed. We have 4 licensed web users and 4 active, but this error message keeps coming up and will clear itself after waiting 5-10 minutes.

Thanks in advance - Chris

----3/17/2009 8:37:11 PM Build--pbs-23t54007f06.pbssystems.com(10.0.0.114)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----3/17/2009 8:37:11 PM Build--pbs-23t54007f06.pbssystems.com(10.0.0.114)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
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 System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
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)
---3/17/2009 7:23:10 PM Les--pbslgdev4ab204.pbssystems.com(10.0.0.135)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)

[lbauer]

The errors indicate some sort of SQL Server connectivity issue. Restarting IIS may clear these up temporarily. We'd like to see a copy of the Vault Server log to see if it has additional information. Send the logs zipped up to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.