000032401 - RSA Identity Governance and Lifecycle 7.0 shows a failed Multi-Application Account Data Collector (MAADC) job with Oracle error ORA-01400: cannot insert NULL into ("AVUSER"."GTT_CE_RELATIONS"."SRCPK_ID")

Document created by RSA Customer Support Employee on Aug 31, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000032401
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Version/Condition: 7.0
 
IssueThe RSA Identity Governance and Lifecycle Multi-Application Account Data Collector (MAADC) is failing while running step 5/12: Object Processing: Update Master Objects is in progress; particularly during the execution of the 'DC_Delete_Explicit_Relations' procedure. The Event Message is 'Get affected relations for deleted account.'
The following event is logged in the respective aveksaServer.log file of the implementation.
com.aveksa.server.db.PersistenceException: java.sql.SQLException: 
ORA-01400: cannot insert NULL into ("AVUSER"."GTT_CE_RELATIONS"."SRCPK_ID")
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 1093
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 244
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 440 ORA-06512: at line 1
CauseThe problem occurs in RSA Identity Governance and Lifecycle 7.0 if you grant access to accounts in other applications and the account name is the same across those applications.

     
ResolutionThis issue has been reproduced by RSA and is fixed in RSA Identity Governance and Lifecycle 7.0 P01

Attachments

    Outcomes