The project summary task (task 0) of a project has an invalid 'Start No Earlier' constraint, which then prevents the project from opening correctly when launched from Clarity to Microsoft Project. Every time the project is launched to MSP, an error message regarding the constraint is thrown:
"This action will cause a scheduling conflict for summary task 0 <task name>.
Clicking on OK does remove the constraint, but the message reappears any of the following times the project is launched to MSP, even if the project is saved back to Clarity without a constraint.
The Project Summary Task should not have a constraint, so the expected value for the constraint is NA.
How do we get the constraint of NA to permanently remain on the project summary task?
Component: Clarity Microsoft Project New Driver
Run the below query to temporarily remove the project from the prdocument table. This will create a backup of the original file in case it's needed for any reason. (For On Demand customers, please open a case to have this resolved):
Run the below query:
set prrecordid = ?? where prrecordid=?
and prtablename= 'PRJ_PROJECTS'
select * from prdocument where prrecordid = ??
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'