Folder export fails with FailDBReader

[ww]

I'm trying to do a folder export using client and server version 8.0.1.299. After a while the export fails with error "A database error has occurred (FailDBReader)".

The vault server log shows this error:

Violation of PRIMARY KEY constraint 'PK__#tdelta___645EE9FAB1E9CAAE'. Cannot insert duplicate key in object 'dbo.#tdelta'. The duplicate key value is (4, 0xd5d3910d6f871c7824a4298b18be1ba9, 0x2593a0f314930dd02635109b05f4ec8c, 687135).

[Beth]

Do you have shares in the area you are trying to export/import?

The duplicate key error seems odd since the export isn't putting changes into the server. Check the Vault folder export import log found in %temp% on the machine at which you are running the tool. What are the errors there?

[ww]

There is one file that is shared among many folders within the folder I am exporting, and also with many folders outside the folder I am exporting. There may be some others in there; I'm not sure. Is there an easy way to find out?

The export log shows

Code: Select all

9/10/2015 1:18:56 PM <generic>: [<No Name>:1] Folder Export:  Retrieving transaction for bill on 3/30/2009 3:52:35 PM TxID: 94802.
9/10/2015 1:19:02 PM <generic>: [<No Name>:11] [System.Web.Services.Protocols.SoapException: VaultServiceAPILib.VaultSoapException: 1104 : FailDBReader
   at VaultService.VaultAdminService.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultRepositoryDelta& rd)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at VaultClientNetLib.AdminService.VaultAdminService.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultRepositoryDelta& rd)
   at VaultClientNetLib.VaultConnection.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nSrcRevision, Int64 nDestRevision, VaultRepositoryDelta& rd)
   at VaultFolderExportImport.ExportWorkerThread.ProcessTransaction(String strProcessMsgType, Int64 nTxID, Int64 nPrevTxID)] VaultServiceAPILib.VaultSoapException: 1104 : FailDBReader
   at VaultService.VaultAdminService.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultRepositoryDelta& rd)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at VaultClientNetLib.AdminService.VaultAdminService.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultRepositoryDelta& rd)
   at VaultClientNetLib.VaultConnection.GetRepositoryDeltaForFolderExport(Int32 nRepID, Int64 nSrcRevision, Int64 nDestRevision, VaultRepositoryDelta& rd)
   at VaultFolderExportImport.ExportWorkerThread.ProcessTransaction(String strProcessMsgType, Int64 nTxID, Int64 nPrevTxID)

Stack Trace:
   at VaultClientPresentationLib.GUIClientInstance.ShowCommandException(Exception e, IWin32Window dialogOwner)
   at VaultFolderExportImport.frmExport.ProcessResults(ExportCommand ec)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()

[Beth]

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