Orphans exist when deleting an object

Document ID : KB000072553
Last Modified Date : 05/03/2018
Show Technical Document Details
Issue:
The are orphaned records after an object is deleted.

Steps to Reproduce
  1. Create a custom object (primary object)
  2. Create a boolean attribute
  3. Run this query:
    select *
    from cmn_lookup_types
    order by created_date desc
  4. You will have two records based in custom object / attribute
  5. Now delete the custom object
  6. Once deleted, execute same query described in step #3
  7. Restart CA PPM services

Expected Result: Records related should be removed.
Actual results: Records remains after object deletion.

Environment:
This issue has been identified in CA PPM 14.2.
Cause:
This issue has been reported as DE31599 and is also known as CLRT-80694.
Resolution:
This issue has been resolved in CA PPM 15.3.
Additional Information:
CA PPM 15.3 Resolved Defects