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()