none
Project Server 2013 Queue Job Failed Errors RRS feed

  • Question

  • I have been diagnosing our Project Server errors, and I have been unable to pinpoint the direct issues. Also searching the internet has failed to explain the issue.

    It seems that most of the queue jobs contain errors. Some are failed but not blocking and other are being blocked. Below are three of the most common errors I receive. Any help would be appreciated. I have experience with SharePoint but not Project Server.

    Project Server 2013 (on prem)

    Error 1 (Reporting Project Sync)

    General

    • Reporting Wss list sync failed:
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='9b5af7db-36c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='030db9f5-36c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='32c3af09-37c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='5f84b91d-37c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='a249ae38-37c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
      • ReportingWssSyncListFailed (24018) - 101. Details: id='24018' name='ReportingWssSyncListFailed' uid='79887c4c-37c2-e611-9455-005056aa1fc8' SPListType='43f3350e-7bdf-e311-bcff-3c970e18b1c8' Error='101'.
    • Reporting transfer WSS links failed.:
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='3df30ee9-36c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='5cd98eef-36c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='7120c702-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='af20c702-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='e7466713-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='1d84b91d-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='f13f8e2c-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='b2768632-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='45477146-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='57477146-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='a7ec3c5c-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, a306a487-301a-40e5-822b-dc883c824a67, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, 24).'.
      • ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='afec3c5c-37c2-e611-9455-005056aa1fc8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (43f3350e-7bdf-e311-bcff-3c970e18b1c8, 1efbf876-a8e6-4d03-8866-7395bfe1ff2d, a306a487-301a-40e5-822b-dc883c824a67, 19).'.
    • Reporting message processor failed:
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='000db9f5-36c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='2fc3af09-37c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='3984b91d-37c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='a049ae38-37c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='76887c4c-37c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='d1d48a62-37c2-e611-9455-005056aa1fc8' QueueMessageBody='ProjectUID='43f3350e-7bdf-e311-bcff-3c970e18b1c8'. ForceFullSync='True'. SynchronizationType='All'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
    • Queue:
      • GeneralQueueJobFailed (26000) - ReportingWSSSync.WSSSyncMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='d2d48a62-37c2-e611-9455-005056aa1fc8' JobUID='10910065-36c2-e611-9455-005056aa1fc8' ComputerName='a7dc7259-364b-456e-9845-97cd4fac774b' GroupType='ReportingWSSSync' MessageType='WSSSyncMessageEx' MessageId='1' Stage='' CorrelationUID='6b10c19d-a555-e0c6-efd9-37bf3165ee40'. For more details, check the ULS logs on machine a7dc7259-364b-456e-9845-97cd4fac774bfor entries with JobUID 10910065-36c2-e611-9455-005056aa1fc8.

    Error 2 (Synchronize Project Web App Permissions to Project Site)

    General

    • Queue:
      • GeneralQueueJobFailed (26000) - PSPermissionSynchronizeProjectSite.PSPermissionSynchronizeProjectSiteMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='50477146-37c2-e611-9455-005056aa1fc8' JobUID='0dcb2876-36c2-e611-944f-005056aa4325' ComputerName='a7dc7259-364b-456e-9845-97cd4fac774b' GroupType='PSPermissionSynchronizeProjectSite' MessageType='PSPermissionSynchronizeProjectSiteMessage' MessageId='1' Stage='' CorrelationUID='6b10c19d-a555-e0c6-efd9-37bf3165ee40'. For more details, check the ULS logs on machine a7dc7259-364b-456e-9845-97cd4fac774b for entries with JobUID 0dcb2876-36c2-e611-944f-005056aa4325.

    Error 3 (Project Workflow Check-in)

    General
    • Queue:
      • GeneralQueueJobFailed (26000) - WorkflowCheckinNotify.ProjectCheckinNotifyWorkflowMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='18509a33-75c1-e611-944f-005056aa4325' JobUID='15509a33-75c1-e611-944f-005056aa4325' ComputerName='e9944bcb-d185-4efa-84c1-cf2dbc055303' GroupType='WorkflowCheckinNotify' MessageType='ProjectCheckinNotifyWorkflowMessage' MessageId='1' Stage='' CorrelationUID='c7c1c09d-6543-e0c6-5530-3d8e8e392690'. For more details, check the ULS logs on machine e9944bcb-d185-4efa-84c1-cf2dbc055303 for entries with JobUID 15509a33-75c1-e611-944f-005056aa4325.

    Wednesday, December 14, 2016 8:11 PM

All replies

  • Challenging to say directly on the first one but my first guess or test would be to have you create projects using the default Project Site template from Microsoft with no modifications.  while not 100% certain, it does appear that the Project Site template is corrupted some how.  Typically this is due to modifying or removing either the Issues, Risks or other default lists in the site template.  if you get no errors using the out of box template, then that's "fer sure" the problem.

    #2 could be related to #1, maybe.  you can use the correlation ID to check in the ULS logs as suggested to see if you can track down any more information.

    #3 is typically seen when the SharePoint Designer has not been run on this PWA instance to create and publish a Project Server 2013 workflow.  Any WF will do - even an empty one.  it just has to be published to the PWA instance.  if you have not setup WF Manager for this farm, then you can ignore this error.

    Hope that helps,


    Thanks, Eric S. Pcubed

    Thursday, January 12, 2017 6:33 AM
  • This error is because somebody has deleted columns in either the Risk, Issues or Deliverable web part for the project site related to the project.  What is happening during the publishing, Risk, Issues and Deliverables are updating databases and it cannot find those columns deleted in web parts.

    The fix is to put those columns back into the web parts.  Refer to another project site and get the names and guids associated with columns. 


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Friday, January 13, 2017 3:00 AM
    Moderator