AX2012 R2: estimated time to complete project server integration status

This question is answered

Hi All:

Kindly let me know what is the estimated time to finish the project server integration status to "COMPLETE". i have waited for almost 2 hrs but still the status didnt change.

I have checked the project server integration log and it doesnt show up any error. Kindly provide any input in this regard.

Regards

Zubair.

Regards
Zubair
Systems ltd. 

Verified Answer
  • the service account was assigned  the system administrator role within Dynamics AX.

    Regards
    Zubair
    Systems ltd. 

All Replies
  • Just to update that AOS is on a separate box and SharePoint/ProjectServer is on separate box.

    Regards
    Zubair
    Systems ltd. 

  • This time must be no more than 5 minutes.

    Have you followed instructions from the white paper?

    technet.microsoft.com/.../hh272873.aspx

    Here you have some more tips too!

    community.dynamics.com/.../instala-231-227-o-dynamics-ax2012-r2-parte-10-integra-231-227-o-com-project-server.aspx

    Dont forget to mark this as answer!

    Francisco Silva | | http://fsilvajunior.blogspot.com.br

    This posting is provided "AS IS" with no warranties, and confers no rights.

  • Thanks for the reply but the issue still persists.

    My environment is distributed, AOS is on a separate machine and Sharepoint/Project Server is installed on another box.

    I have installed "synchronization server for MS project server" on the AOS machine and "synchronization proxy for MS project server" on the Sharepoint/ProjectServer machine.

    All of the services are using a service account for whom all the required permissions have been assigned but still the inetgration status is being shown as "Inprogress".

    Regards

    Zubair

    Regards
    Zubair
    Systems ltd. 

  • Was the "journal" option enable for the "microsoftdynamics" messaging queue"?!

    community.dynamics.com/.../104303.aspx

    Look at this too:

    http://community.dynamics.com/ax/f/33/t/109679.aspx#.UjBNkD_NmSo

    Dont forget to mark this as answer!

    Francisco Silva | | http://fsilvajunior.blogspot.com.br

    This posting is provided "AS IS" with no warranties, and confers no rights.

  • Yes the journal option was enabled.

    Regards
    Zubair
    Systems ltd. 

  • Hi All:

    the integration status has been marked as completed, but now the issue is that batch jobs:

    - Updates for Microsoft Project Server integration.

    - Process transactions for synchronization service

    are not picking the transactions for the synchronization from the sync store. I have assigned the batch group to the batch job and the batch jobs are running successfully at the desired time interval but the transactions (synchronization status) is still marked as Idle.

    Any clue as to how the transaction will be picked up by the batch job.

    Regards

    Zubair

    Regards
    Zubair
    Systems ltd. 

  • What was the solution for the "integration status"?!

    Dont forget to mark this as answer!

    Francisco Silva | | http://fsilvajunior.blogspot.com.br

    This posting is provided "AS IS" with no warranties, and confers no rights.

  • the service account was assigned  the system administrator role within Dynamics AX.

    Regards
    Zubair
    Systems ltd. 

  • Hi All:

    the integration status has been marked as completed, but now the issue is that batch jobs:

    - Updates for Microsoft Project Server integration.

    - Process transactions for synchronization service

    are not picking the transactions for the synchronization from the sync store. I have assigned the batch group to the batch job and the batch jobs are running successfully at the desired time interval but the transactions (synchronization status) is still marked as Idle.

    Any clue as to how the transaction will be picked up by the batch job.

    Regards

    Zubair

    Regards
    Zubair
    Systems ltd. 

  • Below is the error while synchronizing the worker from Dynamics AX into project server.

    ---ERROR MESSAGE---

    An error occurred while synchronizing Resource entity type of Name:"xxxx"

    ---MORE DETAILS---

    An error occurred while creating the Resource compound entity of EntityId:xxxx, Name:"xxx" in project server.

    Error: ProjectServerError(s) LastError=CustomFieldRequiredValueNotProvided Instructions: Pass this into PSClientError constructor to access all error information

    PSCLientError Output:

    CustomFieldRequiredValueNotProvided

    mdpropuid: e1dc15e2-edd3-4897-9f43-085d4c39fa23

    PSCLientError Output:

    any clue how to resolve this error.

    Regards

    Zubair

    Regards
    Zubair
    Systems ltd.