"The correlation of task to has not occurred yet" error during synchronizing with Microsoft Dynamics AX 2012

  • Artikkel

This article provides a resolution for the error that occurs during the synchronization with Microsoft Dynamics AX 2012.

Applies to:   Microsoft Dynamics AX 2012
Original KB number:   2889082

Symptoms

This issue occurs in the Project Server message queue in Microsoft Dynamics AX 2012. Additionally, the following error is displayed in Application Object Server (AOS):

The value Project_UID was not found on a map.

Cause

This issue occurs because some activities have the null value in the HierarchyId, ElementNumber, and ActivityNumber fields.

Resolution

To resolve this issue, follow these steps:

  1. Identify the activities that have the null value in the HierarchyId, ElementNumber, and ActivityNumber fields by using the following query:

    DECLARE @PROJ_UID VARCHAR(36) SET @PROJ_UID = < **Project UID** >
SELECT MSP_EpmTask.ProjectUID, MSP_EpmTask.TaskUID, MSP_EpmTask.TaskName, MSP_EpmTask.TaskModifiedRevisionCounter,
DAX_Task.SyncRevisionCounter, DAX_Task.[HierarchyId], DAX_Task.ElementNumber, DAX_Task.ActivityNumber
FROM <ProjectServer_Reporting Database>.dbo.DAX_Task DAX_Task
WITH (NOLOCK)
INNER JOIN
<ProjectServer_Reporting Database>.dbo.MSP_EpmTask MSP_EpmTask
WITH (NOLOCK)
ON DAX_Task.ProjectUID = MSP_EpmTask.ProjectUID
AND DAX_Task.TaskUID = MSP_EpmTask.TaskUID
WHERE MSP_EpmTask.TaskModifiedRevisionCounter != DAX_Task.SyncRevisionCounter
AND MSP_EpmTask.ProjectUID = @PROJ_UID
order by HierarchyId

  2. Delete all identified activities.

  3. Synchronize with Microsoft Dynamics AX 2012.

  4. Re-create the same activities in Project Server.

  5. Synchronize with Microsoft Dynamics AX 2012 again.