How to change MSP Default Version
Posted by Prakash Sanka on 25 May 2017 09:46 AM
Here is the query that you can run to basically dissociate a project from a specific MSP version. I ran this query for Campbell's MSP 2016 (CA PPM 15.1).
set prrecordid = ?? where prrecordid=?
and prtablename= 'PRJ_PROJECTS'
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.
set prrecordid = 9000001 where prrecordid=5000001 and prtablename= 'PRJ_PROJECTS'
2. Run the below query to ensure that there is not already a project with the ?? prrecordid:
select * from prdocument where prrecordid = ??
select * from prdocument where prrecordid = 9000001
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'