Error: 'java.sql.SQLException: ORA-01427: single-row subquery returns more than one row' When Running the RunETL Process (Doc ID 912817.1)

Last updated on MAY 03, 2016

Applies to:

Primavera P6 Reporting Database - Version R1 to R1 [Release R1]
All Platforms
***Checked for relevance on 11-Dec-2012***

Symptoms

The following error is encountered during the RunETL or Incremental process

[ETL] WARN: The DAO for the table USEROBS was not able to complete successfully
[ETL] INFO: ERROR FOR USEROBS
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms