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 <>
Subscribe to:
Post Comments (Atom)
I wish you could have mentioned, this will delete the already provisioned PWA. It got deleted and I am suffering big time now.
ReplyDelete