Resolving issues with the integration of Microsoft Project Server 2010 and Microsoft Dynamics AX 2012 can be sometimes very difficult, especially if you do not know where to start looking for the issues. That is why I’ve created this document, to help basically myself the next time I need to fix and Integration.
Before you start debugging the issue, confirm the following:
Check Event Log for any errors
Restart Service on Project / AOS Server
- Do a restart of the AOS server and the Project Server
- Run a full Compile on the AOT
- Run a full Compile on the CIL
- Restart IIS on the project server
- Restart Services on project server
- “Project integration service”
- “Project proxy Service”
“Microsoft Dynamics AX 2012 Synchronization Service”
Check Event Log for any errors
Within the “Microsoft Dynamics AX Configuration Utility”
Refresh the WCF
You might want to check the Configuration by logging into the system for the user that is logged in for the “Microsoft Dynamics AX 2012 Synchronization Service”
Make sure the 2 batch jobs are running:
“Updates for Microsoft Project Server Integration”
“Process transactions for synchronisation service”
Make sure the Batch server is setup and running
You Must Manually Run PSCONFIG after Installing SharePoint 2010 Patches
Open an Administrative command prompt.
Change directory to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
Run PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
Error: ”Microsoft Project Server integration settings” form, Integration status stuck in “in progress”
Error: “Integration log”, Transactions status stuck in Waiting
i. Check the Default Business Connector setting for the Business Connector user. You might have to log into the system with the user that is running the Service to make sure the business connector setting is correct
ii. The Batch Job History for:
1. Updates for Microsoft Project Server Integration
2. Process transactions for synchronisation service
3. History of the Batch Job: “Process transactions for synchronisation service” is “Cancelled”
a. Remove the Batch Job: “Process transactions for synchronisation service”
b. Reinstall the Batch job, by running the Class:
c. To Manually run / debug the class: SyncTransProcess, create a new job, with the following code:
SyncTransProcess s = new SyncTransProcess();
4. When running Project Server Provisioning you get error: failed
i. Failed to provision site PWA with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Post provision setup failed. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Microsoft.SharePoint.Upgrade.SPUpgradeCompatibilityException: There is a compatibility range mismatch between the Web server and database “ProjectServer_Published”, and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range.
i. Sharepoint Central Administration > Manage Service Applications > Project Server > Create Project Web App Site
i. Run the PSConfig command from above to upgrade all websites
5. Error within Browse:
a. Error Message: “An unexpected error has occurred.
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: a0ffa929-3fb6-4cbf-87f1-a34dfa89f112
Date and Time: 11/8/2013 2:43:56 PM“
Within the Browser, when accessing the Projects Website.
i. Download: http://archive.msdn.microsoft.com/ULSViewer
ii. Open ULSViewer
iii. Filter according to CorrelationId
iv. View Error message
6. Integration Log Errors
a. Error 1:
i. “—ERROR MESSAGE—
An error occurred while synchronizing Project entity type of Name:”EXCHANGE SERVER”
An error occurred while creating the Project compound entity of EntityId:0cfcb10d-4053-4281-a42f-d0bcde7a13e3, Name:”EXCHANGE SERVER” in project server.
Error: ProjectServerError(s) LastError=CICOAlreadyCheckedOutToYou Instructions: Pass this into PSClientError constructor to access all error information
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters)”
1. Check in all Objects on the Project Server.
2. Within Integration log, Click Action, Resynchronize.
b. Error 2:
i. —ERROR MESSAGE—
An error occurred while synchronizing Project entity type of Name:”HR”
An error occurred while creating the Project compound entity of EntityId:d48e03fe-15f4-48a5-88a9-1859b8ca0e3a, Name:”HR” in project server.
The underlying connection was closed: An unexpected error occurred on a receive.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters) at Microsoft.Dynamics.SyncServices.Library.PSIProxy.Project.ReadProjectList() at Microsoft.Dynamics.SyncServices.Library.ProjServerQuery.ReadProjectUIDByName(String projName) at Microsoft.Dynamics.SyncServices.Adapter.PSEntityAdapter.CreateProject(IDataContainer ProjectContainer) at Microsoft.Dynamics.SyncServices.Adapter.PSEntityAdapter.CreateCompoundEntity(IDataContainer CompoundContainer)
at Microsoft.Dynamics.SyncServices.Adapter.PSEntityAdapter.CreateCompoundEntity(IDataContainer CompoundContainer) at Microsoft.Dynamics.SyncServices.EntityManager.SynchronizeEntityTrans(String companyId, Guid syncTransId, SerializableContainer _sEntityTrans)
1. Within Integration log, Click Action, Resynchronize.