Incremental ETL is failing with the error "ORA-01422: exact fetch returns more than requested number of rows" (Doc ID 1562721.1)

Last updated on OCTOBER 22, 2013

Applies to:

Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.

Symptoms

ETL has been failing since last Friday. Below is the email notification we are receiving:

-----Original Message-----
From: Insight ETL Mail Service [mailto:SafetyAdmins@oracle.com]
Sent: Friday, June 14, 2013 2:52 PM
To: Safety Admins
Subject: Argus Insight ETL => FAILURE!! (Database = AS00I01)

Oracle Corporation
Argus Insight Application => Automatic Email Generation

Incremental ETL FAILED to complete on database AS00I01

Total ETL Time => 3 Hours 59 Mins 55 Seconds

ETL Start Time => 14-JUN-2013 10:48:48 AM
ETL End Time => 14-JUN-2013 02:48:43 PM

Error Message = ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APR_STAGE.PKG_PWR_STAGE_UTIL", line 650
ORA-06512: at "APR_STAGE.PKG_AIR_ATOS_INCR", line 3011
ORA-06512: at "APR_MART.PKG_DBMS_JOB", line 1498


To review further details, please check following LOG tables:
1) ETL_JOBS
2) STAGING_DATA_INSERT_LOG
3) MART_DATA_INSERT_LOG

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