Project "Self" record in the Hierarchy table (INV_HIERARCHIES) is removed after xogging back data when complete flag is set on the hierarchy node
Document ID :
Last Modified Date :
Show Technical Document Details
CA PPM SAAS PROJECT MANAGEMENT:ODPRM
CA PPM PROJECT MANAGEMENT:PPRPRM
STEPS TO REPRODUCE:
Create Project A in Clarity with a year duration 1-Jan-2016 - 31-DEC-2016
Create two other projects with the same duration and add them as sub projects of project A created in step 1 above.
In project A the two projects created in step 2 display as child projects in the Hierarchy page.
Xog out Project A using the a sample xog file attached (project_hier_read.xml)
Xog the output file back into Clarity. Ensure that complete flag is set on the hierarchy node [complete = "true"].
Execute Select * from INV_HIERARCHIES where CHILD_ID = 'ID of master project'
CHILD_ID record is intact in the INV_HIERARCHIES
CHILD_ID record is removed the INV_HIERARCHIES table
This is caused by CLRT-80440
This is fixed within CA PPM 15.1
This does not fix already missing records, but will prevent form occurring again.
Following query will help identifying the investments where the SELF record is missing:
NOT EXISTS (SELECT 1 FROM INV_HIERARCHIES IFH WHERE IFH.PARENT_ID IS NULL AND IFH.CHILD_ID = INV.ID)
In order to fix missing records, please follow steps below:
Download the attached ADD_MISSING_SELF_ROWS.zip file
Unzip the ADD_MISSING_INV_HIERARCHIES_SELF_ROWS.xml file
Place it on a temp folder on the PPM server
Through command line, navigate to the temp folder above
Run the following command:
dbpatch -install -file ADD_MISSING_INV_HIERARCHIES_SELF_ROWS.xml -apply
Was this information helpful?