XOG Delete Resource fails with duplicate ORA-00001: unique constraint (CLARITY.PRASSIGNMENT_U1) violated

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When deleting a resource without any Actuals via XOG, a unique constraint error is thrown although there is no duplicates in the system.

 

STEPS TO REPRODUCE:

1. In Clarity, create a new basic project with a resource on the team, assigned to the effort task
2. XOG the project out
3. Now in the out file, under Resource, update by adding the below tag: delete="true" to delete a resource
4. Save and call the file by XOG to update the project

Expected Results: The project to be successfully updated and the assignment to be removed

Actual Results: The XOG fails with ORA-00001: unique constraint (CLARITY.PRASSIGNMENT_U1) violated

        <Exception><![CDATA[

Error : 1, Position : 0, Sql = insert into prassignment(prid,prFinish,TEAM_ID,prIsUnplanned,ROLE_ID,prWDM,prStatus,prPendFinish,actcost_sum,prPendStart,ETCCOST_SUM,prActSum,prExtension,actcost_curve,prEstMax,prUID,
is_open_te,prEstPattern,ETCCOST_CURVE,prEstSum,prTaskID,prStart,prResourceID,prPendEstSum,prActThru,created_date,created_by,last_updated_date,last_updated_by,odf_ss_actcost_curve,
odf_ss_etccost_curve) values(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ,:30 ,:31 ), OriginalSql = insert into
prassignment(prid,prFinish,TEAM_ID,prIsUnplanned,ROLE_ID,prWDM,prStatus,prPendFinish,actcost_sum,prPendStart,ETCCOST_SUM,prActSum,prExtension,actcost_curve,prEstMax,prUID,
is_open_te,prEstPattern,ETCCOST_CURVE,prEstSum,prTaskID,prStart,prResourceID,prPendEstSum,prActThru,created_date,created_by,last_updated_date,last_updated_by,odf_ss_actcost_curve,
odf_ss_etccost_curve) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), Error Msg = ORA-00001: unique constraint (CLARITY.PRASSIGNMENT_U1) violated

Environment

Clarity 16.2.3, 16.3.0, 16.3.1

Cause

DE165151

Resolution

• Fixed in Clarity 16.3.2

Workaround: Remove the Assignment entry from the XOG input file before updating the project