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

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:

• Load DWH job Incremental fails with error "ORA-30926..." when there are duplicates in the lookup tables
• Data Warehouse (DWH) known issues