Clarity: The Delete Investment job leaves orphaned records in the CMN_SEC_GROUPS table

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

Description:

The Delete Investment job does not delete the project group records from the CMN_SEC_GROUPS table.

The CMN_SEC_GROUPS table now has orphaned records.

Steps to Reproduce:

1. Login to Clarity with admin rights
   
   
2. Select a project that has participants/groups
   
   
3. Uncheck Active
   
   
4. Mark it for deletion
   
   
5. Run the Delete Projects job
   
   
6. Exam the CMN_SEC_GROUPS for this project

Expected Results: Purge project data and all related data.

Actual Results: Orphan records in CMN_SEC_GROUPS table

Solution:

Workaround:

** First test in a NON-PRODUCTION Environment **

Run the following UPDATE Statement:

DELETE FROM CMN_SEC_GROUPS
WHERE PRINCIPAL_TYPE = 'CLB_PROJECTS'
AND PRINCIPAL_ID NOT IN (SELECT ID FROM INV_INVESTMENTS)

Status/Resolution:

This has been documented as CLRT-16099 and it is currently being reviewed by development.

Keywords: CLARITKB, CLRT-16099, 100278, clarity12open, clarity13open.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: