Load DWH job fails with error "ORA-01427: single-row subquery returns more than one row"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DWH) job fails with an error "ORA-01427: single-row subquery returns more than one row"

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

Additional Information

See also: Load DWH Full - When to run to prevent failures