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

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

book

Article ID: 230470

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

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

Resolution

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: