ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 230471


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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


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