ODF_MULTI_VALUED_LOOKUPS holds orphan records related to the assignment object

book

Article ID: 202307

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Some multi-lookup values are not being deleted after deleting an investment. 

STEPS TO REPRODUCE: 

  1. Go to the Assignment object and create a Multi Value Lookup type attribute
  2. Create a project, Add a team member, Create a task and Assign the team member to the same
  3. On the assignment list view, pull the MVL field
  4. Populate the field with some values
  5. Run the following query:
    • SELECT * FROM ODF_MULTI_VALUED_LOOKUPS WHERE pk_id = xxxxxx (assignment id) AND OBJECT = 'assignment'
  6. You can see the MVL values populated
  7. Delete the assignment
  8. Re-run the query:
    • SELECT * FROM ODF_MULTI_VALUED_LOOKUPS WHERE pk_id = xxxxxx (assignment id) AND OBJECT = 'assignment'

Expected Results: The MVL table to be cleaned out as the assignment is deleted
Actual Results: The ODF_MULTI_VALUED_LOOKUPS table still holds records

Cause

This is caused by DE58523

Environment

Any Clarity release

Resolution

This is fixed in 15.9.2

Additional Information

If you do the same at team or task objects, the ODF_MULTI_VALUED_LOOKUPS table is also cleaned.
The orphan records at the ODF_MULTI_VALUED_LOOKUPS table seem to be limited to the assignment table.