Best practices when extending objects in the avuser schema in RSA Identity Governance & Lifecycle
Originally Published: 2020-02-28
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Issue
The following excerpt is taken from the RSA Identity Governance & Lifecycle 7.2 online help on custom attributes:
RSA Identity Governance and Lifecycle lets you create attributes for collected, created, and managed objects. Pre-defined attributes may provide only some of the attributes you need for your objects. Creating attributes lets you collect more comprehensive and important data. They also let you more accurately represent business sources for which you are managing compliance.
This RSA Knowledge Base Article advises on what precautions to take when extending objects in the avdb schema.
Resolution
This is especially true when extending user attributes. When adding a user attribute, there is actually a change to the internal database table structure. When making this change, Oracle will invalidate packages that depend on that table forcing a recompilation of these package(s) upon the next execution of the package. If the session has previously executed the package(s), Oracle can throw one of the following exceptions which will cause a processing failure.
- ORA-04061: Existing state of string has been invalidated
- ORA-04068: existing state of packages has been discarded
It is also recommended to restart the RSA Identity Governance & Lifecycle application once the attributes or attributes have been added. This is particularly true if the attribute or attributes added were user attributes.
Related Articles
RSA Governance & Lifecycle Recipes: Extending Objects in the AVUSER Schema with Custom Attributes Number of Views Deadlock Detected While Extending Schema for Role in RSA Identity Governance & Lifecycle Number of Views When extending the Root General Template for Databases, all Database Connectors using that root template stop working in R… Number of Views ORA-01652: Unable to extend temp segment by 128 in tablespace TEMP in RSA Identity Governance & Lifecycle Number of Views Extend an Evaluation License Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
