Role Collector SQLException ORA-06531 Reference to uninitialized collection in RSA Identity Governance and Lifecycle
3 years ago
Originally Published: 2016-11-22
Article Number
000051478
Applies To
RSA Product Set: Identity Management and Governance
RSA Version/Condition: 7.0.1 P01
 
Issue
A role collector fails in RSA Identity Governance and Lifecycle. The following error gets logged to the aveksaServer.log and in the admin errors for the run:
11/17/2016 10:45:38.023 ERROR (Exec Task Consumer#5) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask
[TaskID=1118 RunID=527 Source=100 Type=DataRelationshipProcessing Status=InProgress] 
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: 
java.sql.SQLException: ORA-06531: Reference to uninitialized collection
ORA-06512: at "AVUSER.RESOLUTION_PKG", line 593
ORA-06512: at "AVUSER.DATAVALIDATION", line 3337
ORA-06512: at "AVUSER.RDC_DATA_COLLECTOR", line 158
ORA-06512: at "AVUSER.RDC_DATA_COLLECTOR", line 297
ORA-06512: at line 1
...
Cause
The problem is the role collector is not collecting members and it is expecting expecting a user resolution. 
Workaround
Change your collector definition to "pretend" to collect a role member and then the collector will require a User Resolution Rule, which will get rid of this error.  Alternatively, you can request an updated Oracle package from support that will resolve the role collector issue without requiring changes to the role collector definition.