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

book

Article ID: 49440

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS 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: