"KUP-04040: file timezdif.csv in TIMEZDIF_DIR not found " Logged by GATHER_STATS_JOB in Alert.log After Upgrade (Doc ID 1290722.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Dec-2015***
This is mainly seen after upgrading to 11gR2 or 12cR1
While less common, this might also be seen after upgrading to other versions like 10.2.0.5 or 11.1.0.7.
The solution remains the same.


Goal


After upgrading to 11.2.0.1 (or higher) the alert log shows this error every midnight:

DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /opt/vendor/oracle/diag/rdbms/n_ckqa/N_CKQA/trace/N_CKQA_j004_28916.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file timezdif.csv in TIMEZDIF_DIR not found


Other possible errors seen in the alert.log are:

BMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file D:\ORACLE\diag\rdbms\dev06\dev06\trace\dev06_j000_5048.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file D:\oracle\ora102\oracore\zoneinfo\tzuvext000_2664_5048.log


( of course the name on the last line will be different, but will contain  "\oracore\zoneinfo\" )
As an example, in the last case, the trace file contains:

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file D:\oracle\ora102\oracore\zoneinfo\tzuvext000_2664_5048.log

DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"SYS_TZUV2_AFFECTED_REGIONS"','""', ...)
DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file D:\oracle\ora102\oracore\zoneinfo\tzuvext000_2664_5048.log



Solution

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