Web part error on Project Detail Pages after a 5 database Project Server instance restore from a different environment

 You may encounter web part issues on various Project Detail Pages after a 5 database restore from another environment on Project Server 2010. If you look at the ULS logs you may find the below entries:

Web Part Exception Unique ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.GatherAndLoadCFList(Boolean bForceRefresh)     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.RebindGrid(Boolean forceRefresh)     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.PWA_OnLoad(EventArgs e)     at Microsoft.Office.Project.PWA.WebParts.PWAResiliencyPart.OnLoad(EventArgs e)

In various cases it means that during the provisioning of the databases the Project Server Service Application failed to update the value of the PWAURL. Below you can find the steps to check and update the value:

$Web = get-SPWeb http://<servername>/<PWAInstance>

$Web.AllProperties | Format-Table

Check the PWAURL variable. If the returned value is too long and the result is trimmed run the below command:

$Props = $Web.AllProperties

$Props.PWAURL

Check the results. If the result is not the URL of the new instance you can change it using:
 
$Web.AllProperties[“PWAURL”]=”NEW PWAInstance URL

$Web.Update()

About the author

Hi! I'm Marcell Mikolcsó, SharePoint and Enterprise Administrator, System Architect.

Month List

Page List