SharePoint (and Project Server) Shenanigans

By the way if anyone has already applied April 2014 CU, or planning to apply, then note that the fix for this issue is available as part of this April 2014 CU. But the fix will not solve any existing affected projects, and you need to follow Brian’s advise mentioned in his blog (URL available below) to fix it.

Also more details and immediate fix, in case you are not planning to apply CU, is available here at Brian Smith’s blog: Blog and Fix

Following are my findings related to the same issue:

Error on Project Page in PWA:

Queue Error:

You will find project stuck in queue with percentage completed less than 100%, and error details would be:

• Microsoft.Office.Project.Server.BusinessLayer.Queue.Message:
  • ProjectPublishFailure (23000). Details: id=’23000′ name=’ProjectPublishFailure’ uid=’187759d1-663f-e411-8b70-0050569b2beb’ projectuid=’1201772f-00b0-e311-baa9-782bcba8cb82′ messagetype=’Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.PublishProjectMessage’ messageID=’16’ stage=” blocking=’Block’

Using JOB ID mentioned, searching ULS Log will help you find below details:

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 (1201772f-00b0-e311-baa9-782bcba8cb82, f34816d9-2fb3-e311-9ecf-0050569b2beb).’    Source: ‘.Net SqlClient Data Provider’ Number: 2627 State: 1 Class: 14 Procedure: ‘MSP_PUBLISH_PROJECT_RESOURCES_INSERT’ LineNumber: 8 Server: ‘HQDXB-CPMSQLINS\CEPMSQLDB’ 4ec5b99c-37f6-c0a5-975a-cdbb44e876c8
09/18/2014 23:05:58.52 Microsoft.Office.Project.Server (0x1470) 0x1CFC Project Server                 Database                       880j High     SqlError: ‘The statement has been terminated.’    Source: ‘.Net SqlClient Data Provider’ Number: 3621 State: 0 Class: 0 Procedure: ‘MSP_PUBLISH_PROJECT_RESOURCES_INSERT’ LineNumber: 8 Server: ‘HQDXB-CPMSQLINS\CEPMSQLDB’ 4ec5b99c-37f6-c0a5-975a-cdbb44e876c8
09/18/2014 23:05:58.52 Microsoft.Office.Project.Server (0x1470) 0x1CFC Project Server                 Database                       tzku High     ConnectionString: ‘Data Source=HQDXB-CPMSQLINS\CEPMSQLDB;Initial Catalog=ProjectWebApp;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[Microsoft.Office.Project.Server.Queuing][2][ProjectWebApp]’    Partition: NULL ConnectionState: Open ConnectionTimeout: 15 4ec5b99c-37f6-c0a5-975a-cdbb44e876c8