Load Data Warehouse (DWH) Full Load or Incremental Load fails consistently with the following error:
Oracle? - An error occurred executing this job entry : Couldn't execute SQL: BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE'; DWH_CFG_PRE_CONFIG_SP( P_DBLINK => 'PPMDBLINK', P_FULL_RELOAD => 'Y'); END; [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [16515], [D], [40], [71999148], [4], [5], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 1704 ORA-06512: at "SYS.DBMS_STATS", line 14485 ORA-06512: at "SYS.DBMS_STATS", line 14615 ORA-06512: at "SYS.DBMS_STATS", line 35378 ORA-06512: at "SYS.DBMS_STATS", line 36230 ORA-06512: at "SYS.DBMS_STATS", line 36716 ORA-06512: at "PPM_DWH.CMN_GATHER_TABLE_STATS_SP", line 16 ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 13 ORA-06512: at line 3
Internal Error code 16515 refers to corrupted histogram statistics which is causing the error. You need to identify the table which has the corrupted statistics and remove them.
Release : All Supported
Component : CLARITY DATA WAREHOUSE
select owner, object_name, object_type
from sys.dba_objects
where object_id = 71999148; (Note this object_ID is the 4th argument in the ORA-00600 error. In the above example it's arguments: [16515], [D], [40], [71999148]).
exec dbms_stats.delete_table_stats(ownname=> '<Table Owner>', tabname=> '<Table Name>');
Re-Run the DWH Full load and validate.