000037408 - Multi-App Entitlement Data Collector (MAEDC) fails with ORA-30926 if two MAEDCs overlap in Application Name and Internal ID in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Apr 29, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037408
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0

IssueOne Multi-App Entitlement Data Collector (MAEDC) runs successfully then a new MAEDC is added and now they both fail. The following errors are logged to the aveksaServer.log:

ORA-30926: unable to get a stable set of rows in the source tables

ORA-06512: at line 1
CauseIf two Multi-App Entitlement Data Collectors share the same application name and the same last digit of their internal ID, it results in duplicates during data processing and the MAEDC collections fail.

As a example, consider two MAEDCs that collect from ApplicationAAA. Internally one has ID=5 and one has ID=415. In this case they evaluate the same:

where name like '%5-ApplicationAAA'
where name like '%415-ApplicationAAA'

If ID 415 was 414, it would be fine as they would be seen as two separate MAEDCs:    

where name like '%5-ApplicationAAA'
where name like '%414-ApplicationAAA'

ResolutionThis issue is fixed in 7.0.2 P12 and 7.1.0 P06.