Removing Project Server 2010 Applications in SharePoint 2010

A common mistake is to remove a PWA Site Collection without doing this by the application manager. This error usually whoever incurs has several problems then the PWA won’t open anymore and sometimes cannot create new PWAs.

Cause

To delete the Site Collection was removed the pointer directly in the Web Application, but for the Service Project Server data is still a PWA with the database intact.

Symptom

When you try to delete now correctly by “Manage Service Applications” error occurs:

“Service application cannot be deleted due to existing project sites”

Solution

Enter SharePoint 2010 Management Shell and run the following sequence of commands:

Get-SPServiceApplication
$ID_App = Get-SPServiceApplication | ? {$_.Displayname -like “App Name”}
$Colecoes = $ID_App.SiteCollection
$Colecoes
$ID_App.SiteCollection.Remove(“22ffa7a9-17f1-4801-b648-cc7e1dbe2183”)

The first command lists all applications have been found and among them the PWA. You can create a filter for like, similar to the second command. Or if you already know the name of the applications put directly in the second row.

The second command captures the application ID and the third uses this ID to bring the list of Site Collections linked to PWA.

The fourth command lists the result of the variable $Colecoes so that you can read the ID of the Site Collection that is inserted into the ultimate dos commands.

After this, run the commands again 3 and 4 until that do not return any Site Collection, although the PWA is usually a single SC.

Below is the complete prints of each stage:

And don’t forget that you will not be deleted databases in SQL Server, what should be done manually before creating a new application for the PWA server.