search cancel

XOG write fails if MVL attribute is present on RISK object

book

Article ID: 214883

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Cannot update RISK via XOG if MVL attribute is present.

STEPS TO REPRODUCE:

1. Create dynamic lookup

SELECT @SELECT:prt.prid:[email protected]
,      @SELECT:ii.code || '/' || ii.name || '/' ||prt.prexternalid ||'/'||prt.prname:[email protected]
,      @SELECT:prt.prexternalid:[email protected]
,      @SELECT:TO_CHAR(prt.prstart, 'YYYY/MM/DD'):[email protected]
,      @SELECT:TO_CHAR(prt.prfinish, 'YYYY/MM/DD'):[email protected]
FROM   RIM_RISKS_AND_ISSUES chg
JOIN   inv_investments ii ON 1 = 1
JOIN   prtask prt ON prt.prprojectid = ii.id
WHERE  @[email protected]
AND    prt.pristask != 0
AND    prt.prexternalid != 'TIMESHEETACCRUAL'
AND    (
         chg.ID = @WHERE:PARAM:USER_DEF:INTEGER:[email protected]
       )
AND    prt.prprojectid IN (SELECT ifh.child_id FROM inv_flat_hierarchies ifh where ifh.parent_id = chg.pk_id)

2. Create MVL attribute on lookup from step 1

ID: db_rsk_assoc_tsk
Multi Valued Lookup - Number
lookup: dependent lookup  where OBJECT ATTRIBUTE ID is mapped to [--Object ID--]

3. Create a risk instance and populate values on the MVL attribute. 

4. XOG OUT risk instance using default risk_read.xml

5. XOG IN Risk instance  

 

Expected results: XOG IN to be successful.

Actual results: XOG IN fails with XOG-6010: Failed to import risk/issue/change request

Workaround: None (The argument to ignore custom attribute values not appearing to be good for Risk object) e.g,    <args name="include_custom" value="false"/>

The issue cannot be replicated on the project object. 

Cause

This is caused by Defect DE60917

Environment

Clarity release : 15.9.2 

 

Resolution

Defect is currently being reviewed by engineering.