FailDBInsert

[Scootin159]

We have one repository which suddenly seemed to loose various files a few weeks ago. We've managed to restore all of the files from local copies on developer workstations, but we're still running into errors with the repository. Specifically we're getting the "FailDBInsert" error whenever we try to add a label. All other repositories are working 100% correctly (as far as we've been able to tell).

Here is the error from "sgvault.log":

Code: Select all

----3/18/2010 3:05:33 PM     Scott--scottpc.edc-aim.com.30.168.192.in-addr.arpa(192.168.30.11)--SSL Enabled	System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'unique_tblfsobjectlabelviews_names'. Cannot insert duplicate key in object 'dbo.tblfsobjectlabelviews'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.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.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath)    at System.Data.SqlClient.SqlConnection.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.AddLabel(VaultSqlConn conn, Int32 nRepID, Int32 nUserID, VaultLabelItem vLabel, Int64& nLabelID, Int64& nObjID, String& strExistingRootPath)

I tried the workaround mentioned here: http://support.sourcegear.com/viewtopic ... iews_names , but it seemed to have no effect.

We've also tried the "deleting the client cache while restarting IIS" - or even restarting the whole server, yet it also seems to have no effect.

I've also searched the database field tblfsobjectlabelviews.names for anything with a name similar to that I'm trying to enter, but I don't see any similar entries (which would explain the unique constraint error).

Any guidance on how to correct this would be appreciated,

[lbauer]

We have one repository which suddenly seemed to loose various files a few weeks ago

Could you explain what you mean by this? Were files not showing up in the file list?

What version of Vault are you using?

We may need to take a look at your database.

[Scootin159]

Yes, various files in the repository suddenly were missing from the repository. They weren't in the "deleted items", it's just like they were never there.

We're on version 4.1.2.18185

[lbauer]

We would like to take a look at your database. Could you contact me and we will make the arrangements. Email support at sourcegear.com, Attn: Linda. Please include a link to this forum post.