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"

book

Article ID: 230471

calendar_today

Updated On:

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