Configuration wizard failed: ERR Login Failed for ProjectServer_Published. Failed Upgrade

Issue:

Psconfig failed at step 3 of 4 with the following error in upgrade log:

03/10/2012 2:51:06 8 ERR Login Failed for ProjectServer_Published. Failed Upgrade.

03/10/2012 2:51:08 8 ERR Login Failed for ProjectServer_Draft. Failed Upgrade.

03/10/2012 2:51:09 8 ERR Login Failed for ProjectServer_Archive. Failed Upgrade.

03/10/2012 2:51:11 8 ERR Login Failed for ProjectServer2010_Published . Failed Upgrade.

03/10/2012 2:51:14 8 ERR Login Failed for ProjectServer_Reporting . Failed Upgrade.

03/10/2012 2:51:18 8 ERR Login Failed for ProjectServer2010_Draft. Failed Upgrade.

Cause:

Checked the Database server and didn’t find the above listed DB's. After analysing the logs found that there are 2 project service application were created and the one "Project web service application" was not provisioned successfully. When I looked at the database status it was showing as not responding.

Fix:

Checked and ensure that the application is not being used and needs to be deleted. Executed the following PowerShell cmdlets and removed the Orphaned PWA and was able to complete the wizard successfully.

$psi = get-spserviceapplication | ? {$_.Typename -like "*Project*}
$psi
Outcome : This will return the various Project service applications
$sa = get-spserviceapplication | ? {$_.Id -eq "GUID of the Service App from above"}
$sa
Outcome : Assign the individual service app object to $sa and verify it has been set.
$sc = $sa.SiteCollection
$sc
Outcome : Will assign the SiteCollection details to $sc and display the contents.
Note Id value.
$sa.SiteCollection.Remove("Site Collection ID from above");
$sc

Cheers!

Bala