locked
Project Server 2013 On-Prim Getting Save Publish error. Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_RESOURCES RRS feed

  • Question

  • Hello Everyone,

    Using Project server 2013 On-Prim, It's been a week, suddenly we are facing the issue while saving and publishing the projects. I found the below error in the logs.

    SqlError: 'Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_RESOURCES'. Cannot insert duplicate key in object 'pub.MSP_PROJECT_RESOURCES'. The duplicate key value is (666d811f-0645-4611-9417-0050569842e6, a0cb8b7e-2a8c-436d-0000-0000000234ff).'    Source: '.Net SqlClient Data Provider' Number: 2627 State: 1 Class: 14 Procedure: 'MSP_PUBLISH_PROJECT_RESOURCES_INSERT' LineNumber: 8 Server: 'SQL Instance'

    Please Help.


    sandeep



    Friday, August 4, 2017 7:42 AM

Answers

  • Full Publishing of Projects worked for me. Used ProjTool for bulk publishing of projects.

    sandeep

    Tuesday, August 29, 2017 7:19 AM

All replies

  • Please Help!!!!!!!!!!!!!!

    sandeep

    Monday, August 7, 2017 10:36 AM
  • Full Publishing of Projects worked for me. Used ProjTool for bulk publishing of projects.

    sandeep

    Tuesday, August 29, 2017 7:19 AM