Can't move folder; transaction error

[lienjohs]

Hi,

I am re-organising my directory structure in a Vault repository. I have done some succesfull folder moves, but the last on (of cause) fails; hello Merphy!
I have attached a screenshot showing the way to the error and our current Vault version; the newest 4.1.4. Error message:

[05-07-2009 09:08:18] Move $/ALK_ARC
[05-07-2009 09:08:18] Ending the transaction
[05-07-2009 09:08:19] An error occurred while trying to end a transaction.
[05-07-2009 09:08:19] Transaction failed
[05-07-2009 09:08:19] Item $/ALK_ARC caused the transaction to fail: A database error has occured (FailDBReader)
[05-07-2009 09:08:19] Transaction failed

I am Vault administrator and have done some checks through this; there seems not to be any files pending in the ALK_ARC folder.

Seaching your site did not resolve my problem; seems I need to send a e-mail to somebody....
Great product anyway; looking forward to support.

Regards
Johannes, DK

[Beth]

If you already sent an email to support, just let me know.

Was there ever a folder by the same name of ALK_ARC under Modules?

Can you look inside your Vault Server Log to see if any errors were logged at the same time you tried that move? If there are, could you copy those here or just attach your entire server log? You will have the ability to remove the log after this troubleshooting is complete. If you prefer, you can always email it. (support at sourcegear.com, attn: Beth, link to this forum thread)

[lienjohs]

I have now send you (Beth) the complete server log file on 'support-webmaster@sourcegear.com'.

I will list the error in the log which I think is from this move folder failure (to help other SourceGear Vault users):

Code: Select all

[i][i]----7/5/2009 9:08:19 AM      [b]USERNAME--SERVERNAME (IP ADDRESS)[/b]--SSL Enabled	System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__@tblfsobjectshar__6557137B'. Cannot insert duplicate key in object '#6462EF42'.
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.GetItemsForPathChange(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nOwnerFolderObjID, String strXml, String strXmlShares, VaultCloakedFolder[]& vcf, VaultFolderRightsItem[]& vfri, VaultShareHint[]& vsh)    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.GetItemsForPathChange(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nOwnerFolderObjID, String strXml, String strXmlShares, VaultCloakedFolder[]& vcf, VaultFolderRightsItem[]& vfri, VaultShareHint[]& vsh)[/i][/i]

[Beth]

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread? We'll need to take this offline.

[lienjohs]

I tried sending you on support-webmaster@sourcegear.com the day before you posted on this issue. Now I have tried sending on support@sourcegear.com. Hope you receive it! /Johannes

[Beth]

I have receive both and replied offline. If you didn't receive my reply, let me know.

HS: 216612