cmn_sec_user_groups table incorrect when User groups are added in MUX > Admin > users

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The cmn_sec_user_groups table update is incorrect when User groups are added in MUX > Admininstration > users

STEPS TO REPRODUCE:

1. Go to Classic > Administration > Organization and Access > Resources.
2. Open any given resource and note the user ID on the URL, let say 5091199
   http://myClarityserver/niku/nu#action:nmc.openUser&id=5091199&resourceId=5059678
3. Run the following statement to the DB
   select * from cmn_sec_user_groups where user_id = 5091199
4. Look at the results. It lists all groups the user is assigned to
5. Go to the Resource's Groups tab and add a new groups
6. Run the query from step 3 again
7. A mew group has been added with the last_updated_by and last_updated_date for the record inserted All pre-existing rows have not been modified
8. In MUX > Administration > Users, filter by the same resource we used in Classic
9. Add the User Groups column into the grid
10. Add a new group to the field
11. Run the following statement to the DB
12. select * from cmn_sec_user_groups where user_id = 5091199
13. Look at the result set

Expected Results: A new row is added. with the last_updated_by and last_updated_date of the insert. Pre-existing rows do not get modified.

Actual Results: A new row is added. with the last_updated_by and last_updated_date of the insert. Pre-existing rows get modified.
In Oracle the last_updated_by and last_updated_date columns get updated as per the data on the inserted row.
In PG, the last_updated_by is set to 0 and last_updated_date is updated for all rows.

Environment

Clarity 16.4.2

Cause

This is caused by DE208879

Resolution

This is fixed in Clarity 16.4.3