PRCONTRAINT.PRUID is null

Products

• Clarity PPM On Premise

Issue/Introduction

In 16.1.3 when copying a project where there are constraints on the tasks, the new project carries the constraints, however the PRUID field on the related PRCONSTRAINT table is null.

This causes issues when trying to open the project in Open Workbench or MSP.

STR:  (16.1.3)

1. Create constraints on a task
2. In MUX copy the project

When trying to open the new project in OWB this error is encountered:  Unable to open project. Missing UID: prUID is empty. table name = PRConstraint 

Resolution

This appears to only happen in 16.1.3

To resolve the issue remove the constraints from the newly created project, then re-create them manually if needed.

Use this query to find the tasks which have an issue 

 

SELECT c.PRUID,
  t.PRNAME as Task,
  t.PREXTERNALID as taskID,
  i.NAME as Inv_Name,
  i.CODE as Inv_code
FROM prconstraint c
INNER JOIN PRTASK t
ON c.PRTASKID = t.PRID
INNER JOIN INV_INVESTMENTS i
ON t.PRPROJECTID     = i.ID
WHERE c.PRUID IS NULL

 

Navigate to those task constraints and remove them.