search cancel

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. 

Environment

Release : 15.8.1, 15.9.1, 15.9.2, 15.9.3 

Component : CA PPM SAAS STUDIO

Cause

DE57972

Workaround: None. No functional impact to the system due to the orphaned records remaining in the table. 

Resolution

Fixed in Release 16.0.0