How do you remove a project 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
This may be requested by Broadcom support based on the symptoms reported for one or more MSP Projects and can include:
(SaaS customers, please contact Broadcom support for assistance)
Run the below query:
set prrecordid = ?? where prrecordid=?
and prtablename= 'PRJ_PROJECTS'
select * from prdocument where prrecordid = ??
select id from inv_investments where name='<project name>' and object_type = 'PROJECT'