none
2010: ReportingWssTransferLinksFailed PK_MSP_WssListItemAssociation Cannot insert duplicate key in object (CU10/14) RRS feed

  • Question

  • Hi,

    we experience with Project Server 2010 SP2 CU10/14 an issue with the WSSSync. Neither GUID1, GUID2 and GUID3 are in the table WssListItemAssociation. We tried to delete the published version of the project, relink and resync the project site, but had no success. Any suggestions very much appreciated.

    Thanks

    John

    General
    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 (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID4' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID5' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID6' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID7' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID8' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    ReportingWssTransferLinksFailed (24019) - Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.. Details: id='24019' name='ReportingWssTransferLinksFailed' uid='GUID9' Error='Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (GUID1, GUID2, GUID3, 4). The statement has been terminated.'.
    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='GUID10' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID11' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID12' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID13' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID14' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID15' QueueMessageBody='ProjectUID='GUID1'. ForceFullSync='False'. SynchronizationType='Issues'' 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='GUID16' JobUID='GUID17' ComputerName='SERVER' GroupType='ReportingWSSSync' MessageType='WSSSyncMessageEx' MessageId='1' Stage=''. For more details, check the ULS logs on machine SERVER for entries with JobUID GUID17.


    John

    Friday, November 14, 2014 3:37 PM

Answers

  • Hi John,

    Is this happening for all Projects or only one project.

    Try this action plan and check

    1. Open PWA -> Server Settings -> Project Sites

    2. Select the site which is having issue

    3. Click on the option "Edit Site Address" , Select "Remove the URL for the SharePoint Site"

    4. Click on ok

    5. Click on Create site and provide a new site name

    7. Synchronize the project and workspace , make sure the sync jobs are successful

    8. click on Delete site and remove the newly created site

    9. click on Edit Site Address and Specify the old Project site URL

    10. Sync the workspace

    Thanks,
    Phani

    • Marked as answer by John Doe Cal Saturday, November 15, 2014 8:57 PM
    Friday, November 14, 2014 5:21 PM