Second Life of a Hungarian SharePoint Geek

November 6, 2014

Error when opening PWA Settings in Central Administration

Filed under: Project Server, Troubleshooting — Tags: , — Peter Holpar @ 23:11

Today I faced an error when I was to configure some of the PWA setting in the Central Administration (Central Administration / General Application Settings / PWA Settings [Manage]).

When I clicked the link PWA Settings, an error page was displayed with the text:

No Project Web App instances found. Create at least one PWA instance before accessing this page

The message was wrong, as I had already two PWA instances on the server.

In the ULS log I found these details:

11/06/2014 08:32:45.82     w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             General                           8nca    Medium      Application error when access /_layouts/15/pwa/Admin/Admin.aspx, Error=No Project Web App instances found. Create at least one PWA instance before accessing this page.   at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.Ht…    1e63c99c-45c3-507f-40b1-b67382eb125e
11/06/2014 08:32:45.82*    w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             General                           8nca    Medium      …tpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)    1e63c99c-45c3-507f-40b1-b67382eb125e
11/06/2014 08:32:45.82     w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             Runtime                           tkau    Unexpected    Microsoft.SharePoint.SPException: No Project Web App instances found. Create at least one PWA instance before accessing this page.    at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute…    1e63c99c-45c3-507f-40b1-b67382eb125e
11/06/2014 08:32:45.82*    w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             Runtime                           tkau    Unexpected    …()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)    1e63c99c-45c3-507f-40b1-b67382eb125e
11/06/2014 08:32:45.82     w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             General                           ajlz0    High        Getting Error Message for Exception Microsoft.SharePoint.SPException: No Project Web App instances found. Create at least one PWA instance before accessing this page.     at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.H…    1e63c99c-45c3-507f-40b1-b67382eb125e
11/06/2014 08:32:45.82*    w3wp.exe (0x20608)                          0x1FE3C    SharePoint Foundation             General                           ajlz0    High        …ttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)    1e63c99c-45c3-507f-40b1-b67382eb125e

If I tried to open the related page directly (/_layouts/15/pwa/Admin/Admin.aspx), and not via the link, another error message was displayed:

File Not Found

The related details in the ULS log:

11/06/2014 08:34:51.37     w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             General                           8nca    Medium      Application error when access /_layouts/15/pwa/Admin/Admin.aspx, Error=The site with the id 5584122d-2bdd-48b5-bd15-7885712b9892 could not be found.   at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken)     at Microsoft.Office.Project.PWA.PJContext.GetContextForCentralAdmin(Boolean isWebServiceCall, Guid siteID)     at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHand…    3d63c99c-d56d-507f-40b1-be1a311bf3d0
11/06/2014 08:34:51.37*    w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             General                           8nca    Medium      …lerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()    3d63c99c-d56d-507f-40b1-be1a311bf3d0
11/06/2014 08:34:51.37     w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             Runtime                           tkau    Unexpected    System.IO.FileNotFoundException: The site with the id 5584122d-2bdd-48b5-bd15-7885712b9892 could not be found.    at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken)     at Microsoft.Office.Project.PWA.PJContext.GetContextForCentralAdmin(Boolean isWebServiceCall, Guid siteID)     at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpConte…    3d63c99c-d56d-507f-40b1-be1a311bf3d0
11/06/2014 08:34:51.37*    w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             Runtime                           tkau    Unexpected    …xt context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()    3d63c99c-d56d-507f-40b1-be1a311bf3d0
11/06/2014 08:34:51.37     w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             General                           ajlz0    High        Getting Error Message for Exception System.Web.HttpException (0x80004005): Exception of type ‘System.Web.HttpException’ was thrown. —> System.IO.FileNotFoundException: The site with the id 5584122d-2bdd-48b5-bd15-7885712b9892 could not be found.     at Microsoft.SharePoint.SPSite..ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken)     at Microsoft.Office.Project.PWA.PJContext.GetContextForCentralAdmin(Boolean isWebServiceCall, Guid siteID)     at Microsoft.Office.Project.PWA.PJBasePage..ctor(String pwaUrl)     at Microsoft.Office.Project.PWA.PJWebPage..ctor(String url)     at __ASP.FastObjectFactory_app_web_admin_aspx_ad835a1b_9lzjizur.Create_ASP__layouts_15_pwa_admin_admin_aspx()     at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualP…    3d63c99c-d56d-507f-40b1-be1a311bf3d0
11/06/2014 08:34:51.37*    w3wp.exe (0x20608)                          0x1CE48    SharePoint Foundation             General                           ajlz0    High        …ath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)     at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)    3d63c99c-d56d-507f-40b1-be1a311bf3d0

As highlighted above the source of the problem was:

The site with the id 5584122d-2bdd-48b5-bd15-7885712b9892 could not be found

I searched the configuration database of the farm for the object that includes this id in its properties:

SELECT [Id]
      ,[ClassId]
      ,[ParentId]
      ,[Name]
      ,[Status]
      ,[Version]
      ,[Properties]
  FROM [ConfigDB].[dbo].[Objects]
  where Properties like ‘%5584122d-2bdd-48b5-bd15-7885712b9892%’

The resulting object was a former PWA instance (of type Microsoft.Office.Project.Server.Administration.ProjectSite) with the Id13B1DAD3-B005-46D9-B712-CDF7CC2FEAFF’, that still referenced to a SharePoint site collection, that did not exist any more. From the name of the instance (specified by the value of sFld type="String" name="_name")  I was able to identify, that it should be an instance, that was deleted already a few weeks ago, and was neither displayed on the UI of Central Administration nor available programmatically. Obviously, the removal of that instance has not been performed successfully.

To remove the inconsistency, I’ve deleted the orphaned instance using

STSADM -o deleteconfigurationobject -id 13B1DAD3-B005-46D9-B712-CDF7CC2FEAFF

Important! I suggest to create database backups (SharePoint configuration, content databases, and Project database as well) before executing this type of commands in your environment.

The deletion of the orphaned instance solved my issue, and the page PWA Settings was available again in the Central Administration.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

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

Blog at WordPress.com.

%d bloggers like this: