Project Server 2013 On-Prim Getting Save Publish error. Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_RESOURCES
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
- Edited by Sandeep Dharmpurikar Monday, August 7, 2017 10:37 AM
