Question Status

Verified
Zubair Mir asked a question on 10 Sep 2013 4:36 AM

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. 

Reply
Verified Answer
Zubair Mir responded on 11 Sep 2013 10:09 PM

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

Regards
Zubair
Systems ltd. 

Reply
Suggested Answer
Francisco Silva responded on 10 Sep 2013 8:07 AM

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.

Reply
Suggested Answer
Francisco Silva responded on 11 Sep 2013 4:08 AM

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.

Reply
Zubair Mir responded on 10 Sep 2013 5:59 AM

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

Regards
Zubair
Systems ltd. 

Reply
Suggested Answer
Francisco Silva responded on 10 Sep 2013 8:07 AM

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.

Reply
Zubair Mir responded on 11 Sep 2013 1:29 AM

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. 

Reply
Suggested Answer
Francisco Silva responded on 11 Sep 2013 4:08 AM

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.

Reply
Zubair Mir responded on 11 Sep 2013 7:18 AM

Yes the journal option was enabled.

Regards
Zubair
Systems ltd. 

Reply
Zubair Mir responded on 11 Sep 2013 7:19 AM

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. 

Reply
Francisco Silva responded on 11 Sep 2013 7:22 AM

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.

Reply
Verified Answer
Zubair Mir responded on 11 Sep 2013 10:09 PM

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

Regards
Zubair
Systems ltd. 

Reply
Zubair Mir responded on 11 Sep 2013 10:10 PM

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. 

Reply
Zubair Mir responded on 12 Sep 2013 4:06 AM

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. 

Reply