Friday, April 30, 2010

Delete an orphaned Project server database entry from the config db in sharepoint

The following query allows us to get rid of an orphaned object id for a project server database when we see errors during provisioning of PWA sites.

Run this against the config DB

SELECT OD.ID AS DepID,OD.Name AS DepName, O.ID AS ObID,O.Name AS ObName
FROM Objects AS O
INNER JOIN Dependencies AS D ON O.ID = D.ObjectID
INNER JOIN Objects AS OD ON D.DependantID = OD.ID
WHERE O.Name like '[INSERT-DB-NAME-HERE]'

Copy the DEPID that is returned and execute the following command

STSADM -o deleteconfigurationobject -ID <>

1 comment:

  1. I wish you could have mentioned, this will delete the already provisioned PWA. It got deleted and I am suffering big time now.

    ReplyDelete