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

Document ID : KB000049440
Last Modified Date : 14/02/2018
Show Technical Document Details

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.