ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Orphan Records are left in table cmn_captions_nls table

book

Article ID: 200264

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Orphan Records are left in table cmn_captions_nls table 

STEPS TO REPRODUCE: 

1. Create a custom object example Test Object 
2. Run the below query 
             select * from cmn_captions_nls 
             where language_code = 'en'
             and name like '%TEST CUSTOM OBJECT';
3. You will get 9 records 


    ODF_OBJECTS 5072780 en TEST CUSTOM OBJECT 
    CMN_SEC_OBJECTS 5051375 en TEST CUSTOM OBJECT TEST CUSTOM OBJECT
    CMN_SEC_OBJECTS 5051376 en TEST CUSTOM OBJECT TEST CUSTOM OBJECT
    CMN_SEC_OBJECTS 5051377 en TEST CUSTOM OBJECT TEST CUSTOM OBJECT
    CMN_LOOKUPS 5046599 en TEST CUSTOM OBJECT TEST CUSTOM OBJECT
    ODF_ACTIONS 5021044 en New TEST CUSTOM OBJECT Create new TEST CUSTOM OBJECT
    CMN_PAGES 5086374 en Create TEST CUSTOM OBJECT Create TEST CUSTOM OBJECT
    CMN_ACTIONS 5097192 en TEST CUSTOM OBJECT Create TEST CUSTOM OBJECT Create TEST CUSTOM OBJECT
    CMN_PAGE_PORTLETS 5086324 en Create TEST CUSTOM OBJECT Create TEST CUSTOM OBJECT
 
4. Delete the object 'TEST CUSTOM OBJECT' and run the same query and you will see the records existed in the table cmn_captions_nls
 

   select * from cmn_captions_nls 
   where language_code = 'en'
   and name like '%TEST CUSTOM OBJECT';


Expected Results: Upon deletion of an object all corresponding records in table cmn_captions_nls should get deleted

Actual Results: Orphan records are left in table cmn_captions_nls

Cause

This is a defect DE57972 and currently under investigation 

Environment

Release : 15.8.1

Component : CA PPM SAAS STUDIO

Resolution

No resolution till the defect is fixed, however there is no functional impact to the system due to this defect