search cancel

Load DWH fails with error "ORA-30926: unable to get a stable set of rows in the source tables"


Article ID: 230470


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Your Load Data Warehouse (DWH) job fails with the below error referenced:

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


Uncheck/check the attribute:

  1. In Clarity go to Administration -> Objects
  2. Open the affected object
  3. Go to Attributes
  4. Find the attribute affected
  5. If it's unchecked, enable it for Data Warehouse
  6. If it's checked, then uncheck it from being enabled in Data Warehouse
  7. Run the Load Data Warehouse job - Full Load

Tip: To find out which attribute a lookup is associated with see: Load DWH failing on custom lookup - finding the attribute to disable

How to prevent this issue from happening?
Before you delete an attribute make sure it is not included in the data warehouse and the Load DWH job has run to ensure it has come out.

Additional Information

See also: