Home > Khurram Jamshed > Project Server 2013 More Symptoms to Lost Resource Issue #PS2013 #LostResources #ProjectServer

Project Server 2013 More Symptoms to Lost Resource Issue #PS2013 #LostResources #ProjectServer

In relation to famous Lost Resources issue, i would like to share few more symptoms that can help you to identify an exact 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:

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

via All about Enterprise Project Management (EPM) http://bit.ly/1mIB3bc

Khurram Jamshed
The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.

This article has been cross posted from khurramjamshed.blogspot.com/ (original article)

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: