Orphaned instance rights after deleting a portlet page

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Deleting a portlet page that a group has Instance Rights leaves orphaned records in the database.

Steps to Reproduce:

1. Create a new group.
2. Create a new portlet page (an empty page is fine).
3. Assign Instance Rights to this page to the group (Portlet Page object, Page - View right).
4. Go to Administration > Organization and Access > Groups > [group] > Group's Access Rights > Instance > Page - View, and check the URL:
   <server>/niku/nu#action:nmc.groupInstanceRightsAssociations&id=5004264&rightId=50183&rightType=CMN_PAGES&isClassRight=false
5. Run the following DB query with the id from the previous URL:

   select * from cmn_sec_assgnd_obj_perm
   
   where upper(principal_type) = 'GROUP'
   
   and principal_id = 5004264

6. Delete the portlet page from Step 2
7. Check the Portlet Page / Page - View rights for the group - "There are no items to display" (expected).
8. Run the query from Step 5 again.

Expected Results: The query does not return any results.

Actual Results: The query still returns the Page - View instance right.

Environment

Release : 16.0.2

Resolution

DE77440, fixed in 16.2.0