"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
3 years ago
Originally Published: 2016-11-02
Article Number
000042270
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.1, 7.0+
 
Issue
A "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
Cause
The 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. 
Resolution
This problem is fixed in V6.9.1 P20 and V7.0.1 P02.
 

Related Articles

Trending Articles

Don't see what you're looking for?