"The correlation of task to has not occurred yet" error during synchronizing with Microsoft Dynamics AX 2012
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:
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
Delete all identified activities.
Synchronize with Microsoft Dynamics AX 2012.
Re-create the same activities in Project Server.
Synchronize with Microsoft Dynamics AX 2012 again.