none
Problem: Task completion sync back from Exchange 2010 to Project Server 2010 RRS feed

  • Question

  • I have new installation of PS 2010 and Exchange 2010 (one server holds all roles including CAS).

    For sync between PS and EX 2010, I following the technet article Configure Project Server 2010 to work with Exchange Server 2010 at http://technet.microsoft.com/en-us/library/ff468700%28office.14%29.aspx (yes I read the second part on Impersonation, too).

    Basically I followed the video and opted for "Impersonation for all users".

    I got tasks appear in resources outlook "Tasks" folder no problem. They appeared instantly after project is published. But when the resource update the completion in outlook, it failed to update the Project server.

    The applog on Exchange server has the following events:

    A notification for subscription [IABmaWxiZXJ0Lm1zYy5hbHR1cmFzYW5hbHl0aWNzLmNvbRAAAABpsVspLo+TSpth0iMukr+TjiFq73wS0Qg=] against endpoint [http://MyPSserver/PWA/_vti_bin/PSI/ExchangeSync.asmx] couldn't be sent. (Send attempts: 2) Details: WebException: The remote server returned an error: (500) Internal Server Error. StatusCode: InternalServerError Internal Server Error    at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at Microsoft.Exchange.Services.Core.NotificationServiceClient.HandleResponse(IAsyncResult responseAsyncResult)

    After 8 unsuccessful attempts to send a notification for subscription [IABmaWxiZXJ0Lm1zYy5hbHR1cmFzYW5hbHl0aWNzLmNvbRAAAABaEEJ+4ahFSY6IVGcSZ7/m4kLgKCES0Qg=] against endpoint [http://MyPSserver/PWA/_vti_bin/PSI/ExchangeSync.asmx], the subscription has been removed. Details: WebException: The remote server returned an error: (500) Internal Server Error. StatusCode: InternalServerError Internal Server Error    at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at Microsoft.Exchange.Services.Core.NotificationServiceClient.HandleResponse(IAsyncResult responseAsyncResult

    The W3C log on PS app server has the following related entries (401 and 500 errors. 10.0.0.76 is Exch server. 10.0.0.77 is the PS app server):

    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 0
    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 15
    2014-03-20 18:12:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 31
    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 0
    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:12:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 31
    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 0
    2014-03-20 18:12:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:12:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 31
    2014-03-20 18:12:41 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 0
    2014-03-20 18:12:41 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:12:41 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 62

    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 15
    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:28:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 46
    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 15
    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:28:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 31
    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 0
    2014-03-20 18:28:39 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:28:39 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 15
    2014-03-20 18:28:41 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 2 5 15
    2014-03-20 18:28:41 10.0.0.77 POST /PWA/_vti_bin/PSI/ExchangeSync.asmx - 80 - 10.0.0.76 - 401 1 2148074254 0
    2014-03-20 18:28:41 10.0.0.77 POST /_vti_bin/PSI/ExchangeSync.asmx - 80 MyDomain\MyExchServer$ 10.0.0.76 - 500 0 0 15

    I am new to PS 2010. Help is appreciated. Thanks.

    Thursday, March 20, 2014 8:47 PM

All replies

  • Here are the errors found in Project Queues:

    ExchangeSyncExchangeSubscriptionUpdateForUserFailed (40511). Details: id='40511' name='ExchangeSyncExchangeSubscriptionUpdateForUserFailed' uid='ef501cc2-9305-47b5-92b3-021e3b41d1b5' teamMemberUid='b8f2e0cd-9882-4677-be61-b2780b32bae5' exception='System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Office.Project.Server.ExchangeSync.ExchangeSyncUtil.UpdateExchangeSubscription(Guid resourceUid, SubscriptionContext context) at Microsoft.Office.Project.Server.ExchangeSync.ExchangeSyncUtil.UpdateExchangeSubscription(Guid resourceUid) at Microsoft.Office.Project.Server.ExchangeSync.ExchangeSubscriptionRefreshProcessor.Refresh(PlatformContext ctx)'.


    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='ef4e51a1-8cb2-4ec2-bfc4-530f1f34cd8c' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='0b88178b-2e45-41af-a85f-8c5590e9c3e7' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='0d7421f6-2579-4656-b956-d50ecc7f5f1c' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='3456b70e-fe16-4b3a-ab66-f2a5237fbaeb' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='fc78474a-bf5c-422c-a209-cb79e3201e38' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.'.
    ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='d2f4b313-0c21-4a2c-b8a7-f6bd7aef13fe' QueueMessageBody='Project UID='2668bb26-5c23-42ce-843a-fa49feadba05'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmResource", column 'ResourceUID'. The statement has been terminated.

    Thursday, March 20, 2014 11:08 PM