Issue
From time to time it has been observed that export will complete for a container in an EV to EV migration, but import will appear to hang. This is sometimes due to the archive containing multiple container mappings, perhaps as a result of manual archiving, and these are not mapped in the administration console.
Solution
The following SQL commands can be run on the Item Database to check the mapping:
declare @containermappingiD int select@containermappingID =513 if OBJECT_ID('tempdb.dbo.#temp_results','U') is not null drop table #temp_results Create table #temp_results (ItemID uniqueidentifier,RCatCategoryID int,SourceRetentionCategoryID varchar(112),TargetRetentionCategoryID varchar(112)) -- Get all the items into a temporary table insert into #temp_results(ItemID,RCatCategoryID) select ie.ItemId,ie.SourceRetentionCategoryId from ItemEnterpriseVault ie,ItemRouting IR where IR.ContainerMappingId =@containermappingID and IR.ItemId =ie.ItemId -- Convert the Ret Cat for the source to an EV ID update #temp_results set SourceRetentionCategoryID = (select EVRetentionCategory.RetentionCategoryEVId from EVRetentionCategory where EVRetentionCategory.RetentionCategoryId =#temp_results.RCatCategoryID) -- Convert the Ret Cat for the target ret cat mapping to an EV ID update #temp_results set TargetRetentionCategoryID = (select TargetEVRetentionCategoryID from ArchiveShuttleDirectory.dbo.EVRetentionCategoryMapping where ArchiveShuttleDirectory.dbo.EVRetentionCategoryMapping.SourceEVRetentionCategoryId =#temp_results.SourceRetentionCategoryID) -- Do some output --- Summary select SourceRetentionCategoryID,COUNT(*) as 'Num Items' from #temp_results group by SourceRetentionCategoryID --- Non-Mapped summary select COUNT(*) as 'Non Mapped' from #temp_results where TargetRetentionCategoryID is null --- All results select * from #temp_results -- Clean up temporary table drop table #temp_results
The output of that will look similar to this: