285 total views, 0 views today

Primavera P6 Validation Report – Missing Objects – Constraints

 

The Primavera P6 Validation reports throw the following missing objects. All missing objects are DB constraints

 

112817_0505_PrimaveraP61 Primavera P6 Validation Report - Missing Objects - Constraints

 

 

  • I found out the P6 DB constraints are available in the following SQL script

<P6_SOFTWARE>\database\scripts\install\PM_16_02_00\orpm_admuser.sql

 

  • Also, I found out Oracle database will not allow adding a constraint if Orphan records exist in the corresponding table. We need to delete or correct the orphan records before adding a constraint. I chose Delete which is easier for me
  • I need to add 6 constraints. The total is six. The below are the series of SQL’s did the magic

 

–Delete Orphan Records from TASKACTV and Adding the constraint fk_taskactv

 

 

 

–Delete Orphan Records from TASKMEMO and Adding the constraint fk_taskmemo_task

 

 

 

 

–Delete Orphan Records from TASKPRED and Adding the constraint fk_taskpred_task

 

 

 

–Delete Orphan Records from TASKUSER and Adding the constraint fk_taskuser_task

 

 

 

govindan Primavera P6 Validation Report - Missing Objects - Constraints
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan Primavera P6 Validation Report - Missing Objects - Constraints
Connect me
By | 2017-11-28T00:12:59+00:00 November 28th, 2017|Categories: P6|Tags: , |Comments Off on Primavera P6 Validation Report – Missing Objects – Constraints
Like us on Facebook.
Connect!