000033498 - After upgrading from Aveksa 6.5.1 to RSA Identity Governance and Lifecycle 7.0, all collectors fail with ORA-1400:  Cannot insert NULL

Document created by RSA Customer Support Employee on Jul 20, 2016Last modified by RSA Customer Support Employee on Jun 2, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033498
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0 and up
 
IssueAfter upgrading Aveksa 6.5.1 to RSA Identity Governance and Lifecycle 7.0 and all of the collectors, including the Aveksa ones, fail with this error in the aveksaServer.log:
 
05/24/2016 14:25:55.860 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=17529 RunID=15274 Source=1 Type=DataObjectProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLIntegrityConstraintViolationException:
ORA-01400: cannot insert NULL into ("AVUSER"."GTT_DADC_CHILD_EDC_MAP"."CHILD_EDC_ID")
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 1307
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 244
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 450
ORA-06512: at line 1

The ORA-1400:  cannot insert NULL error is received while inserting values into column GTT_DADC_CHILD_EDC_MAP.CHILD_EDC_ID.
CauseThere was an internal change to a table definition that does not allow the column CHILD_EDC_ID to be NULL anymore; whereas in previous versions, this column could be empty.
To verify that you have this specific issue, please run the following queries in SQL*Developer or another tool of your choice and provide the result to RSA Via L&G Support in .csv format when opening a case:
 
SELECT * FROM t_maedc_process_history WHERE child_edc_id is NULL;
SELECT * FROM t_dadc_process_history WHERE child_edc_id is NULL;
SELECT * FROM t_av_data_access_edc_data WHERE child_edc_id is NULL;
SELECT * FROM t_av_parent_dadc_edc_data WHERE child_edc_id is NULL;
SELECT * FROM t_av_multi_app_edc_data WHERE child_edc_id is NULL;

ResolutionOnce RSA Identity Governance and Lifecycle Support has verified the issue, they will be able assist with data cleanup.
NotesThis issue may affect upgrades from versions other than 6.5.1.

Attachments

    Outcomes