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 How to change the registration code validity period for RSA Authenticator app registration? Number of Views ORA-01652: Unable to extend temp segment by 128 in tablespace TEMP in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
