EPM Project Workspace Missing? Unable to re-create SharePoint Workspace?

You may experience this issue if;

• The initial project workspace creation failed

OR

• You copied just the Project Server DBs from production to development environment, without the corresponding SharePoint Content Database and relinking.

As a result, you are not able to create a new workspace when you re-publish the project via Project Pro. The system thinks project workspace exists, but in reality it does not.

(click picture to enlarge)

To resolve the issue, run the appropriate script below against the Published database. This clears the workspace URL part for the project, allowing you to recreate the workspace during the subsequent publish operation from Project Pro.

Note: Take appropriate DB backups and test the script thoroughly prior to applying on your production system.

---To set the SharePoint workspace value of selected project to Null
Update dbo.MSP_PROJECTS
Set WPROJ_STS_SUBWEB_NAME = Null
where WPROJ_STS_SUBWEB_NAME LIKE ‘%xxx%'

----end

----To set all values of WPROJ_STS_SUBWEB_NAME to NULL i.e. update/clean-up the entire Project Server published DB after restoring to Development
Update dbo.MSP_PROJECTS
Set WPROJ_STS_SUBWEB_NAME = Null

----end

Hope this helps.