A database error has occured (FailDBInsert)

[schadaway]

Hi,

I've just started receiving the above error whenever I try to check a file in. Nothing has changed with regards to the setup and the log file is showing this:

----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled System.Data.SqlClient.SqlException: Warning: Fatal error 605 occurred at Oct 27 2008 4:48PM. Note the error and time, and contact your system administrator.
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveFoldersEntryDeltas(VaultSqlConn conn, String strXml) 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveFoldersEntryDeltas(VaultSqlConn conn, String strXml)
----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled Could not save folder entries: Error in the application.
----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled System.InvalidOperationException: Invalid operation. The connection is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection()
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at VaultServiceSQL.VaultSqlConn.BeginTransaction(IsolationLevel isolationlevel) at System.Data.SqlClient.SqlConnection.GetOpenConnection()
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at VaultServiceSQL.VaultSqlConn.BeginTransaction(IsolationLevel isolationlevel)
----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled Unable to begin SQL transaction for deleting pending transaction objects for TxID 253
----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled (bb4bd272-d614-40c6-b014-dc337c95d7c0) EndTx (Revision - 0) returned: FailDBInsert
----27/10/2008 16:57:50 steve--ijmason.plus.com(212.159.72.44)--SSL Disabled (bb4bd272-d614-40c6-b014-dc337c95d7c0) CheckIn: $/core/admin/sitelog.asp returned: FailDBInsert

Any ideas?

Thanks

Steve

[drmccue]

Hello Steve.

The first thing I'd like you to do is run a command to diagnose any issues that SQL Server can identify in your sgvault database:

DBCC CHECKDB('sgvault')

Please post the results of the DBCC CHECKDB command here, or, if you prefer to not publish details about your database publicly, email us at support@sourcegear.com.

Thanks,
Dan McCue
SourceGear