Incremental ETL is failing with ORA-00600 error when gathering statistics on APR_MART schema

(Doc ID 1507615.1)

Last updated on JANUARY 07, 2015

Applies to:

Oracle Argus Insight - Version 7.0.1 and later
Information in this document applies to any platform.
***Reviewed for currency: 07-Jan-2015***

Symptoms

ETL Incremental Failure:

Error in modMain::Execute :Error Id ->0 :Error Desc -> - SQL: DECLARE x number; BEGIN dbms_job.change(91, 'begin pkg_dbms_job.p_call_air_incremental(1); end;', to_date(:sNextDate,'mm/dd/yyyy hh24:mi:ss'), :sIntervalExp); commit; END; Enterprise: DEFAULT REMOTE_ADDR: 10.31.16.177

Found the following error in the mart_data_insert_log file:

37166,p_analyze_table,Going to gather APR_MART schema Statistics(stale objects),,11/21/2012 11:22:40 AM
37167,compute statistics,Error Computing Mart User Statistics ,ORA-00600: internal error code, arguments: [15851], [3], [2], [1], [1], [], [], [], [], [], [], []
ORA-06512: at "APR_STAGE.PKG_AI_COMMON_UTIL", line 286
ORA-06512: at "APR_MART.PKG_AIR_STOM", line 10732
,11/21/2012 11:22:55 AM
37168,p_manage_triggers,ENABLE trigger on table dm_cfg_users_sites started,,11/21/2012 11:22:55 AM
37169,p_manage_triggers,ENABLE trigger on table dm_cfg_users_sites completed,,11/21/2012 11:22:55 AM
37170,p_call_air_incremental,Error during Incremental ETL execution,ORA-20010: ORA-00600: internal error code, arguments: [15851], [3], [2], [1], [1], [], [], [], [], [], [], []
ORA-06512: at "APR_STAGE.PKG_AI_COMMON_UTIL", line 286
ORA-06512: at "APR_MART.PKG_AIR_STOM", line 10732

-- ERROR while processing compute statistics at 21-nov-2012 11:22:55
ORA-06512: at "APR_MART.PKG_DBMS_JOB", line 1349
ORA-06512: at "APR_MART.PKG_DBMS_JOB", line 1540
,11/21/2012 11:22:55 AM


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