Question Status

Suggested Answer
Praveen asked a question on 14 Dec 2011 3:26 AM

Hi,

Has anyone done or attempted the Dynamics AX 2012 and Project Server 2010 integration? 

My installation and configuration of Project server 2010 with Dynamics AX 2012 went without a glitch as per the whitepaper for the same. All AX and Project server synchronization services are running fine without any issues too.

The Enable integration status for the Project server synchronization setup also comes to completed status.

Now, after I publish the Project mpp file to the project server, after a few minutes the Project is picked by the Ax synchronization service. The Integration log form inside AX shows as status "Idle", and the sync data line shows the status as "Waiting". Tried to invoke the batch processing, still the status does not change. The whitepaper and internet also does not have any details regarding this issue. It seems the service freezes and there are not any major event logs details in event viewer.

Tried to cancel and re-synchronize the integration service, still no response. Checked the release notes in CU2, it has no mention of this issue, as I am currently using AX 2012 with CU1.

I checked the back end and the AX sync tables in MS Project database has got populated, but the service has not brought it inside AX 2012. 

So anybody aware of this issue and how we are able to force the integration to pick up the data from the Project database. Please do share your ideas and thanks for any help.

 

Praveen

Reply
Suggested Answer
Francisco Silva responded on 10 Sep 2013 6:58 AM

Hello Zubair!

This time can not be more than 5 minutes...

if it didnt changed there is something wrong.

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
Raju Ilango responded on 13 Apr 2012 11:24 AM

Hi Praveen,

We are facing the similar issue (although between AX 2009 and Server 2007). Were you able to get the sync running? How did you go about debugging/resolving this issue. Please do advise. Thanks much!

Reply
M. Ahsan responded on 10 Dec 2012 5:14 AM

Project Server Integration status is not changing the status from In Progress to Completed. any knows reason ?

Muhammad Ahsan

Reply
Flavio Duarte responded on 5 May 2013 7:12 AM

Hi Pravven,

I have the same problem. I soved with make a backup and restore of user defined fields in Project Server.

Flavio

Reply
Zubair Mir responded on 10 Sep 2013 6:05 AM

Hi All:

Kindly let mek now what is the estimated to complete the integration of Project server with Ax2012 R2. The integration status field is showing the status as Inprogress with almost 2 hrs passed. I havent seen any error in the Project server integration log.

any clue is highly appreciated.

Regards

Zubair

Regards
Zubair
Systems ltd. 

Reply
Suggested Answer
Francisco Silva responded on 10 Sep 2013 6:58 AM

Hello Zubair!

This time can not be more than 5 minutes...

if it didnt changed there is something wrong.

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 7:14 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 9:49 AM

Which was the solution for the integration problem?

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 10:13 PM

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

Regards
Zubair
Systems ltd. 

Reply
Zubair Mir responded on 11 Sep 2013 10:13 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 3:37 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