Unable to checkin file - FailDBInsert

Vista_SG · Post by **Vista_SG** » Thu Sep 14, 2006 3:33 am

Vault client is version 3.5.0.4741
Your Vault server is version 3.5.0.4741

We're trying to update a file in a repository but are getting a 'FailDBInsert' error on any operation we try e.g. rename/delete/checkin etc...

We have tried restarting IIS and have deleted the local cache files (as these solved previous issues), but this has had no effect.

The problem seems to effect all files in a particular folder.

Heres the relevant output from the log file after trying a rename operation:
**********************************
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.tblfsobjectversions' with unique index 'idxfsobjectversionversions'.
The statement has been terminated.
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.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles) 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.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled Could not create bubble folders: Error in the application. at VaultServiceSQL.VaultSqlSCC.CreateBubbleFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, String strXml, HybridDictionary& hdBubbles)
at VaultServiceAPILib.VaultServiceAPI.SaveRepository(VaultTransactionContainer txContainer, VaultRepository repOld, VaultRepository repNew)
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled EndTx(): Failed commit changes for TxID 185501
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled SQL transaction 1348700 successfully rolled back.
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled Beginning SQL transaction 11989863
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled SQL transaction 11989863 successfully committed.
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled TreeManager Signal - Tx End - TxID:185501 CacheLockId:12138304 RepID:47
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled (59a60aa8-9a33-470e-a4c6-fabf3e055ad3) EndTx (Revision - 0) returned: FailDBInsert
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled (59a60aa8-9a33-470e-a4c6-fabf3e055ad3) Rename: $/CN0418_Vista/Resources/b_16Devices/NO/mini220/Driver/Mh-2.htm to daveMh-2.htm returned: FailDBInsert
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled Getting repository Structure-> Rep ID: 47 Base: 185500 Target: -1
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 185500
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:8 RepID:47 Base:185500 Target:185500 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled GetRepositoryStructure returned: Success
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled Getting list of checkout changes.
----14/09/2006 09:59:13 <USERNAME AND ADDRESS>--SSL Disabled GetCheckOutListChanges returned: Success
******************

Anyone have any ideas?

lbauer · Post by **lbauer** » Thu Sep 14, 2006 8:31 am

Is this a shared folder? Do you have many shares in the database?

Vista_SG · Post by **Vista_SG** » Thu Sep 14, 2006 8:41 am

The folder itself is not shared but many files within it are and yes there is an awful lot of sharing of files within the repository.

lbauer · Post by **lbauer** » Thu Sep 14, 2006 9:30 am

Is a parent folder of this folder shared?

We're trying to determine whether we need to see a copy of your database or whether there may be some scripts we can send you to fix the problem.

Vista_SG · Post by **Vista_SG** » Thu Sep 14, 2006 9:44 am

Hi Linda,

We don't have any folder sharing at all. It's purely files that are shared so I guess that'd be a 'no' to your question.

The way it's structured is like this:
We have a project in which multiple devices use the same resource file. Each resource file has been added once to a resources area/folder and is then shared to multiple devices in a release area/folder. Some files are shared with upto 19 devices and others are only shared into 1 device.

Thanks for any help you give us in this.

Vista_SG · Post by **Vista_SG** » Mon Sep 18, 2006 10:42 am

Hi Linda,

Have you come up with any ideas that might help us with this issue?

Thanks

lbauer · Post by **lbauer** » Mon Sep 18, 2006 3:17 pm

We'll need get a copy of your database. Email Linda at sourcegear.com and we'll send instructions.

lbauer · Post by **lbauer** » Fri Sep 22, 2006 10:33 am

Have you emailed me about this issue? We'll need to see your database. If you did email, I may not have known what forum issue it related to.