|Applies To||RSA Product Set: Identity Management and Governance|
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 got messed up during attribute creation:
05/15/2017 16:47:24.467 ERROR (Exec Task Consumer#9) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=12008
|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).|
SELECT * FROM T_AV_CUSTOM_ATTRIBUTES ORDER BY OBJECT_TYPE, DISPLAY_NAME;
SELECT * FROM T_EXTENSIBLE_SCHEMA_COLUMNS ORDER BY TABLE_NAME, DISPLAY_NAME;
SELECT table_name FROM USER_TAB_COLUMNS WEHERE column_name='<invalid identifier column name>';
<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,
SELECT table_name FROM USER_TAB_COLUMNS WHERE column_name='CUS_ATTR_USER_CAS_41';
If the query returns any output, please contact RSA Support for resolution and mention this article.