ACM-100162 || PV_USER_ALL_ACCESS view does not include custom attributes post 7.1.1 installation
2 years ago
Originally Published: 2019-08-07
Article Number
000041153
Applies To
RSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.1.1
Platform: null
Platform (Other): null
O/S Version: null
Product Name: RSA-0018000
Product Description: Access Certification Manager
Issue
We notice that the view PV_USER_ALL_ACCESS does not include any of the custom attributes fields. These fields are included only after editing and re-saving any of the custom attributes field.
Cause
Public view gets the custom attributes from the object lists of AveksaServer instance. During an upgrade, server instances will be down and object list will be empty. 

In P02, we have applied code changes in order to move the recreation of view logic as part of server startup, once the instance are up and making sure view gets recreated after every upgrade from P02 on-wards. Hence this issue is not observed in P02.

We have observed below two views are impacted by this issue:
- PV_USER_DIRECT_ACCESS
- PV_USER_ALL_ACCESS

There is no additional impact as the data is not lost as verified from back-end tables -
T_AV_CUSTOM_ATTRIBUTES and T_EXTENSIBLE_SCHEMA_COLUMNS
Resolution
Issue is fixed in IG&L 7.1.1 P02.


 
Workaround
Edit any custom attribute and save it.  OR create a new custom attribute and save it.  This will display the custom attributes again.