In relation to a famous Lost Resources issue in Project Server 2013, I would like to share few more symptoms that can help you to identify this issue and apply the relative fix. Also the purpose is to feed search engines with more relevant data to help us lead to right direction.
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:
The general error statement on PWA page is not so helpful 🙂
You will find project stuck in queue with percentage completed less than 100%, and error details would be:
- 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][ProjectWebApp]’ Partition: NULL ConnectionState: Open ConnectionTimeout: 15 4ec5b99c-37f6-c0a5-975a-cdbb44e876c8
I hope you find this article helpful!