Records in ODF_LOOKUP_PARAMETERS table for an attribute are not deleted

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When an attribute type 'lookup' using a parameterized lookup is deleted, the record of the mapping in ODF_LOOKUP_PARAMETERS table for that attribute is not deleted.

The following errors may be seen in the app-ca.logs:

ERROR 2019-01-28 11:32:10,729 [http-nio-14001-exec-8] union.persistence (clarity:admin:21815978__....:mainnav.work) Undefined statement set: odf-pmd.project.select-parameterized-captions.prj_test_mgr.map.1
ERROR 2019-01-28 11:32:10,729 [http-nio-14001-exec-8] dal.DataProviderClient (clarity:admin:21815978__....:mainnav.work) Could not run statement set for parameterized lookups
ERROR 2019-01-28 11:32:10,730 [http-nio-14001-exec-8] dal.DataProviderClient (clarity:admin:21815978__....:mainnav.work) Could not process statement set for parameterized lookups, lookupAttributeCode:prj_test_mgr object code: project

Steps to Reproduce:

1. Go to Admin side - Objects - Open Investment Object
2. Create a new attribute:
   • name=mylookup
   • id=mylookup
   • type=lookup
3. Select a dynamic lookup (parameterized lookup)
4. Save the attribute
5. Set the mapping [--object id --]
6. Save the attribute
7. Run query: 
   select * from ODF_LOOKUP_PARAMETERS where lookup_attribute_name in ('mylookup') 
result: 1 row
8. Delete the attribute you just created
9. Run the query again: 
   select * from ODF_LOOKUP_PARAMETERS where lookup_attribute_name in ('mylookup')

Expected Result: No result. The record for the attribute in the ODF_LOOKUP_PARAMETERS is deleted. 

Actual Result: 1 row. The record for the attribute in the ODF_LOOKUP_PARAMETERS is not deleted. 

Cause

Caused by DE48500

Resolution

This is fixed in 15.6.1