Incremental ETL is failing with ORA-00600 error when gathering statistics on APR_MART schema (Doc ID 1507615.1)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.