|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Version/Condition: All
|Issue||The Identity Data Collection has been failing after applying attribute changes due to the following exception:|
ORA-00904: CUS_ATTR_USER_CAS_XX invalid identifier
This error has been occurring during Identity Data Collection runs, specifically while Staging Tables are being created (Step 1/4 Create Staging Tables). The Identity Data Collection's Admin error is failing at Identity_Data_Collector.Save_Run_Data while copying table data from STX_USR_XX_XXXX into T_DC_SOURCEDATA_USER.
This issue was brought about by the following scenario where it appears something is corrupted during attribute creation:
See the full error stacktrace from aveksaServer.log:
|Cause||The database tables became out of sync with the extensible schema columns.|
|Resolution||Run the following queries as AVUSER on your SQL Developer tool to determine if the database tables is out of sync with the extensible schema columns. Also, provide screenshot(s) of the Edit screen for the User attributes (Admin > Attributes > User tab).|
<invalid identifier column name> is the invalid identifier column name (e. g., CUS_ATTR_USER_CAS_41) from the ORA-00904 invalid identifier exception. For example,
If the query returns any output, please contact RSA Support for the resolution and mention this article.