In case of orphan record, if you want to delete it, you might try the below mentioned script (at your own risk), would strongly recommend have a backup of all the DB’s before trying
Run the query to identify all orphan projects
—- Identifies Orphan Records———
SELECT PROJECTNAME, PROJECTUID FROM MSP_EPMPROJECT
WHERE PROJECTUID NOT IN
(SELECT PROJ_UID
FROM <ProjectServer_Published>.DBO.MSP_PROJECTS)
Execute the below mentioned SP in RDB supplying the ProjectUID of error causing project
EXEC MSP_Epm_DeleteResourcePlan <ProjectUID >
EXEC MSP_Epm_DeleteProject <ProjectUID>
Thank you very much. Script really helpful to delete orphan projects.
Can you please explain what is “SP” and how to run this line:
“Execute the below mentioned SP in RDB supplying the ProjectUID of error causing project”
Thank you!
Hi Zindar
by SP i meant Execute the SP(Stored Procedure) against ProjectS erver Reporting Database(RDB) with Supplying Project UID
So ideally you need to paste the EXEC MSP_Epm_DeleteResourcePlan just replace the Project UID
Howdy just wanted to give you a quick heads up and let
you know a few of the pictures aren’t loading correctly. I’m not sure why but I think its
a linking issue. I’ve tried it in two different browsers and both show the same results.
this post doesn’t has any pictures, not sure where you are looking at
thanks. it helped!!!!!