CMN_SEC_USERS.external_id Set To NULL When Status Is Changed

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When the user account Status is set to either Active, Inactive, or Lock, the field CMN_SEC_USERS.external_id is set to null.

Steps To Reproduce
1. Go to Administration > Organization and Access > Resources
2. Select a resource and change the 'Status' field to any of the following values:
Active
Inactive
Lock.
3. Click Save.

Actual: CMN_SEC_USERS.external_id is set to null
while SRM_RESOURCES.external_id retains the value.

Expected: CMN_SEC_USERS.external_id should remain intact/unchanged as it mirrors SRM_RESOURCES.external_id

Cause

DE168497

Resolution

Resolved in 16.3.2

Workaround: Contact Broadcom Support to set the external_id via database update.