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 :)
Queue Error:
You will find project stuck in queue with percentage completed less than 100%, and error details would be:
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
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 :)
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
1 comments:
Grateful to check out your website, I seem to be ahead to more excellent sites and I wish that you wrote more informative post for us. Well done work.
Post a Comment
Spammers, don't waste your time as the comments will only appear after moderation.