search cancel

Associated Risks Showing on Wrong Projects

book

Article ID: 227129

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Using the XOG interface to create new RISK, there is the possibility of the newly created RISK being associated with the wrong TASK.

This seemingly happens since the information in the <associatedTasks> part of the Risk XOG only specifies the "Task Code" attribute. Thus where tasks exist in the system across different projects, with the same prexternalid (Task code), then the XOG picks up any of these tasks instead of the task associated with the relevant project.

STEPS TO REPRODUCE: 
1. Create a new project "Project A"
2. Create a new TASK for that project (Taskone_projectA - ID=taskone)
3. Create a new project "Project B"
4. Create a new TASK for that project (Taskone_projectB - ID=taskone)
5. Check the ids on the database (results will show your two new projects):
select prprojectid , prid , PRNAME , PREXTERNALID
 from prtask where prexternalid = 'taskone'
6. Create a risk on PROJECT B and associate it with the existing TASKONE on Project B
7. Check the database for the ids (results will show 1 result):
select *
from
itl_object_associations ioa
where ioa.object_type = 'RISK'
AND ioa.table_name = 'PRTASK'
and ioa.object_id = 5005003 --(this id will vary based on the system you are testing, but essentially it is Risk id)
8. Now XOG Out the RISK and note the section;

            <associatedTasks>
                <task code="taskone"/>
            </associatedTasks>
9. In the application GUI, remove the association between the Risk and taskone
10. Then XOG back in the same RISK, using the same XML that we got from the XOG out above and refresh the "Associated Tasks" screen in the UI post XOG
11. However, examine the database again;

select *
from
itl_object_associations ioa
where ioa.object_type = 'RISK'
AND ioa.table_name = 'PRTASK'
and ioa.object_id = "insert object id here"

**Note that the PK_ID column is now the PRID of the PRTASK related to PROJECT A rather than the PRID of the PRTASK related to PROJECT B. Also, note that the GUI does not show the RISK associated with the TASK under Project A either, even though the association is present on the database.

Expected Results: It should associate to the correct task from the project mentioned in the XOG file

Actual Results: It is associating to the wrong Task id.

Environment

Release : 15.9

Component : CLARITY PROJECT MANAGEMENT

Resolution

DE63052, Fixed in 16.0.1.