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.
ETL has been failing since last Friday. Below is the email notification we are receiving:
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)
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!