Unhandled exception 1101 FailDBConn

willsllc · Post by **willsllc** » Thu Mar 08, 2007 1:48 pm

After 2.5 years, our 10-person Vault server suddenly stopped working.

We have 8 repositories, all of them are working fine except one. That repository crashes the Vault Admin Tool and the Vault GUI Client whenever we try to connect to it.

1101: FailDBConn
System.Web.Services.Protocols.SoapException: 1101 : FailDBConn
at VaultAdmin.AdminManager.HandleException(Exception e, Boolean bHandle, Boolean isSoap)
at VaultAdmin.AdminManager.LoadRepositoryProperties(Int32 repID)
at VaultAdmin.FormMain.CommandShowProperties()
at VaultAdmin.FormMain.buttonProperties_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

The Vault log file is _huge_ (normally it's 30KB/day, today it is 1.85MB). Some of the errors from the log file look like:

System.Data.SqlClient.SqlException: Arithmetic overflow error for data type smallint, value = -1593352759.

and others are like:

VaultLib.VaultBuildTreeException: Error in the application.

Any ideas what went wrong? Again, our other repositories are working fine. I can provide more information if needed.

willsllc · Post by **willsllc** » Thu Mar 08, 2007 1:49 pm

Here is the stack trace from one of the arithmetic overflows...

----3/8/2007 2:21:18 PM portman--10.147.1.107(10.147.1.107)--SSL Disabled System.Data.SqlClient.SqlException: Arithmetic overflow error for data type smallint, value = -1593352759.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
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 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
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)

Beth · Post by **Beth** » Thu Mar 08, 2007 3:00 pm

This is being handled off line. I'll post back when I know a little more.

Did you receive the response from SourceGear support through email? If no, just let me know. Sometimes our responses land in people's junk folders.