Exception exporting Vault DB

paul-shed · Post by **paul-shed** » Mon Oct 15, 2007 8:26 am

Hello,

I'm getting the following exception when I try and export one of my databases.

I'm using Vault 3.5.1 (4786) and the vault export/import tool. The export/import tool is running on a different server to the vault service.

The service is running on Windows server 2000 and the export/import tool on Windows server 2003.

I could not find any useful log on the server when the exception occured.

15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: ProcessResults_ProcessTransaction OBLITERATION WARNING for $/Neptune/source/tools/common/source/geestring/bin - RequestType Move (within): TxID: 11348 ModDate = 14/05/2007 16:24:12, TxItem = 1, Source Item = $/Neptune/source/tools/common/source/geestring/bin/byacc.exe Dest Folder = $/Neptune/binary/win32/tools
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: ProcessResults_ProcessTransaction OBLITERATION WARNING for $/Neptune/source/tools/common/source/geestring/bin - RequestType Move (within): TxID: 11348 ModDate = 14/05/2007 16:24:12, TxItem = 2, Source Item = $/Neptune/source/tools/common/source/geestring/bin/flex.exe Dest Folder = $/Neptune/binary/win32/tools
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: Retrieving transaction for paul on 14/05/2007 19:46:55 TxID: 11347.
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: Retrieving transaction for julian on 14/05/2007 17:18:35 TxID: 11346.
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: Retrieving transaction for julian on 14/05/2007 17:14:10 TxID: 11345.
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: Retrieving transaction for paul on 14/05/2007 16:24:12 TxID: 11344.
15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: An exception occurred in ProcessResults_ProcessTransaction_BuildChangesetForTransaction(). Tx: 11344 Transaction before exception: 11344 on 14/05/2007 16:24:12
Change Set Items. Object reference not set to an instance of an object. at VaultFolderExportImport.frmExport.PickDeltaSummaryItem(ArrayList alSummaryItems, String strItemPath, Int32 nChange, PinStatus ps, Int64 nObjVerID, String strPrefObjPath, String strPrefObjPathWithSlash)
at VaultFolderExportImport.frmExport.BuildChangesetForTransaction(String strCalleePrefix, String strDeltaObjPath, String strDeltaObjPathWithSlash, HybridDictionary hdObjectIDsToExport, VaultFolderExportTxInfo tx, VaultTxDetail txDetail, VaultRepositoryDeltaSummary summary) [System.NullReferenceException: Object reference not set to an instance of an object.
at VaultFolderExportImport.frmExport.PickDeltaSummaryItem(ArrayList alSummaryItems, String strItemPath, Int32 nChange, PinStatus ps, Int64 nObjVerID, String strPrefObjPath, String strPrefObjPathWithSlash)
at VaultFolderExportImport.frmExport.BuildChangesetForTransaction(String strCalleePrefix, String strDeltaObjPath, String strDeltaObjPathWithSlash, HybridDictionary hdObjectIDsToExport, VaultFolderExportTxInfo tx, VaultTxDetail txDetail, VaultRepositoryDeltaSummary summary)]Object reference not set to an instance of an object.

15/10/2007 11:23:09 <generic>: [<No Name>:3708] Folder Export: An exception occurred in ProcessResults_ProcessTransaction() Object reference not set to an instance of an object. at VaultFolderExportImport.frmExport.PickDeltaSummaryItem(ArrayList alSummaryItems, String strItemPath, Int32 nChange, PinStatus ps, Int64 nObjVerID, String strPrefObjPath, String strPrefObjPathWithSlash)
at VaultFolderExportImport.frmExport.BuildChangesetForTransaction(String strCalleePrefix, String strDeltaObjPath, String strDeltaObjPathWithSlash, HybridDictionary hdObjectIDsToExport, VaultFolderExportTxInfo tx, VaultTxDetail txDetail, VaultRepositoryDeltaSummary summary)
at VaultFolderExportImport.frmExport.ProcessResults_ProcessTransaction(ExportCommand ec) [System.NullReferenceException: Object reference not set to an instance of an object.
at VaultFolderExportImport.frmExport.PickDeltaSummaryItem(ArrayList alSummaryItems, String strItemPath, Int32 nChange, PinStatus ps, Int64 nObjVerID, String strPrefObjPath, String strPrefObjPathWithSlash)
at VaultFolderExportImport.frmExport.BuildChangesetForTransaction(String strCalleePrefix, String strDeltaObjPath, String strDeltaObjPathWithSlash, HybridDictionary hdObjectIDsToExport, VaultFolderExportTxInfo tx, VaultTxDetail txDetail, VaultRepositoryDeltaSummary summary)
at VaultFolderExportImport.frmExport.ProcessResults_ProcessTransaction(ExportCommand ec)]Object reference not set to an instance of an object.

15/10/2007 11:53:52 <generic>: [<No Name>:3708] Folder Export: Closing the Export Dialog with Dialog Result: Cancel
15/10/2007 11:53:52 <generic>: [<No Name>:3708] Folder Export: ## FOLDER EXPORT END ##
15/10/2007 11:53:54 <generic>: [<No Name>:2672] SimpleLogger finalized

Regards,

paul-shed

lbauer · Post by **lbauer** » Mon Oct 15, 2007 10:53 am

Looks like there were items obliterated in the tree. The Export\Import tool can't export items that no longer exist in the repository. You may need to work around this by exporting just folders that do not contain obliterated items.

Vault 3.5.3 did fix some cases with move operations, so you could try upgrading client and server to 3.5.3 and see if that gets you further.

If you need help identifying items that have been obliterated, let us know; we can provide some SQL queries that can help isolate where those items are within the current repository.

paul-shed · Post by **paul-shed** » Wed Oct 17, 2007 6:57 am

Yes, can I have a look at these queries please?

Also on another matter whilst migrating a DB from VSS to Vault we mapped a user incorrectly. So we now have a heap of changes in Vault attributed to the wrong developer. Is it possible to reassign changes in vault to a different user. e.g. All changes made by Bill should now be assigned to Dave?

Or do we have to reimport again?

Regards,

paul-shed

paul-shed · Post by **paul-shed** » Fri Oct 19, 2007 1:05 pm

Hello, support, can you reply please!

Regards,

paul-shed

lbauer · Post by **lbauer** » Fri Oct 19, 2007 3:33 pm

I have contacted one of our developers about getting the scripts.

Would you email support at sourcegear.com ATTN linda, and I'll send them to you.

Regarding the user mapping issue -- you can't map after the fact, though you could change the user name. For instance change Dave's name to Fred and then change Bill's name to Dave. Now all of Bill's history will be Dave's. Then you can rename Fred to Dave. You might want to plan this out ahead of time, because things can get confused.