000034319 - "ORA-30926: Unable to get a stable set of rows in the source tables" error when trying to modify a role in RSA Identity Governance and Lifecycle

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

Article Content

Article Number000034319
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.1, 7.0+
 
IssueA "request could not be handled" error occurs when adding users or entitlements to a Role in RSA Identity Governance and Lifecycle.
For example, 
  1. Edit the role and try to add a member:
User-added image

 
  1. After you hit OK, the error displays:
User-added image

 
  1. The following error can be seen in the aveksaServer.log:
com.aveksa.server.db.PersistenceException:java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512:at "AVUSER.METADATA_MANAGEMENT_PKG", line 958
PRA-06512: at line 1
 

User-added image
CauseThe ORA-30926 is typically caused by a merge statement where there is a one-to-one relationship expected between two data sources, but the relationship is actually many-to-one, one-to-many, or many-to-many. 
ResolutionThis problem is fixed in V6.9.1 P20 and V7.0.1 P02.
 

Attachments

    Outcomes