Thanks Colin, it looks fine and data imported successfully.

When I tried to run StoredProcedure [dbo].[RefreshPublishedDocuments] for sync testing purpose, getting the new error as below:

Msg 2627, Level 14, State 1, Procedure RefreshPublishedDocuments, Line 260 [Batch Start Line 33]
Violation of PRIMARY KEY constraint 'PK_AuditDocumentEvent'. Cannot insert duplicate key in object 'dbo.AuditDocumentEvent'. The duplicate key value is (2, 0x000a75c2db9ce279).
The statement has been terminated.

When I checked further: DocKey and RepositoryID is the primaryKey in the ControlPointExport "AuditDocumentEvent" table. The SP[RefreshPublishedDocuments], as part of the Step4,  trying to fetch rows from ControlPointMetaStore.ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent and insert here, but it contains duplicates and failing. 

I can see many duplicate rows in the AuditDocumentEvent table which is surprise to me. Any idea, is it expected behaviour or these duplicates remains because I ran "RemovePolicyFromRejectedDocs.sql" and the Storedprocedure not cleaning the AuditDocumentEvent table causing the issue? The one temp solution, thinking to comment section4  [ I no need AuditDocumentEvent refresh in the Export database ] and rerun the SP again? Any comments are appreciated. 

--Duplicate of id for pairs based on RepositoryId and Dockey:
select s.id, t.*
from ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent s with (nolock)
join (
select RepositoryId, Dockey, count(*) as qty
from ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent with (nolock)
group by RepositoryId, Dockey
having count(*) > 1
) t on s.RepositoryId = t.RepositoryId and s.DocKey = t.DocKey

Thanks Colin, it looks fine and data imported successfully.

When I tried to run StoredProcedure [dbo].[RefreshPublishedDocuments] for sync testing purpose, getting the new error as below:

Msg 2627, Level 14, State 1, Procedure RefreshPublishedDocuments, Line 260 [Batch Start Line 33]
Violation of PRIMARY KEY constraint 'PK_AuditDocumentEvent'. Cannot insert duplicate key in object 'dbo.AuditDocumentEvent'. The duplicate key value is (2, 0x000a75c2db9ce279).
The statement has been terminated.

When I checked further: DocKey and RepositoryID is the primaryKey in the ControlPointExport "AuditDocumentEvent" table. The SP[RefreshPublishedDocuments], as part of the Step4,  trying to fetch rows from ControlPointMetaStore.ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent and insert here, but it contains duplicates and failing. 

I can see many duplicate rows in the AuditDocumentEvent table which is surprise to me. Any idea, is it expected behaviour or these duplicates remains because I ran "RemovePolicyFromRejectedDocs.sql" and the Storedprocedure not cleaning the AuditDocumentEvent table causing the issue? The one temp solution, thinking to comment section4  [ I no need AuditDocumentEvent refresh in the Export database ] and rerun the SP again? Any comments are appreciated. 

--Duplicate of id for pairs based on RepositoryId and Dockey:
select s.id, t.*
from ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent s with (nolock)
join (
select RepositoryId, Dockey, count(*) as qty
from ControlPointMetaStore.ControlPointmetadata.AuditDocumentEvent with (nolock)
group by RepositoryId, Dockey
having count(*) > 1
) t on s.RepositoryId = t.RepositoryId and s.DocKey = t.DocKey