IMPORTANT: IMPACT OF RUNNING SCRIPT:
update prdocument
set prrecordid = ?? where prrecordid=?
and prtablename= 'PRJ_PROJECTS'
Notes:
1. Replace the ? with the 5 million number of the project. For ?? change the 5 to a 9. This will create a backup of the record in the database.
2. Run the below query to ensure that there is not already a project with the ?? prrecordid:
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'