How do you temporarily remove a project's MPP File from the prdocument table for Microsoft Project (MSP) Interface issues and what is the impact?
Note: Prior to running this query, it's recommended to check with Broadcom support first unless a KB is found with a match for the symptoms are you are facing.
Release: All Supported Releases
Component: MSP
This may be requested by Broadcom support based on the symptoms reported for one or more MSP Projects and can include:
MSP Legacy Driver: All custom views for the project will be deleted
Any custom field data not mapped to Clarity will be deleted from the project. This only impacts data entered in a MSP Field (such as a text field) and that data isn't stored in Clarity. This impacts both the MSP New Driver and MSP Legacy Driver.
MSP New Driver: All Fixed Work tasks will currently change to Fixed Units. The user will need to manually change all applicable tasks back to Fixed Work the next time the project is opened in MSP.
(SaaS customers, please contact Broadcom support for assistance)
Run the below query:
update prdocument
set prrecordid = ?? where prrecordid=?
and prtablename= 'PRJ_PROJECTS'
Notes:
select * from prdocument where prrecordid = ??
3. To find the 5 million number for the project, you can run the below query (or it can be found in the PPM URL when clicking on the link to the project from the project list)
select id from inv_investments where name='<project name>' and object_type = 'PROJECT'