search cancel

Records in ODF_LOOKUP_PARAMETERS table for an attribute are not deleted

book

Article ID: 130544

calendar_today

Updated On:

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