ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB (Doc ID 1274653.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

The key symptoms in these cases are typically the following:

• DBMS_STATS is being executed in some form
• ORA-20011, ORA-29913 and ORA-29400 Errors are seen, ORA-29913 specifying external function "ODCIEXTTABLEOPEN" signifying that there was an error in the callout by the external function "ODCIEXTTABLEOPEN " while trying to open an external table.

Some specific examples follow:

• When attempting to run GATHER_STATS_JOB the following errors occur:
  
  
  ORA-20011: Approximate NDV failed:ORA-29913: error in executing ODCIEXTTABLEOPEN callout
  ORA-29400: data cartridge error
    
  
  usually accompanied with varying other errors such as:
  
  
  KUP-11024: This external table can only be accessed from within a Data Pump job
    
  
  and others.
  
  
• The alert log may also show following errors:
  
  
  Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5400000000] [PC:0xFFFFFFFF7CB19EFC, memcpy%sun4u-opl()+236] [flags: 0x0, count: 1]
  ERROR: Unable to normalize symbol name for the following short stack (at offset 200):
  dbgexProcessError()+176<-dbgePostErrorKGE()+1348<-dbkePostKGE_kgsf()+48<-kgeade()+
    
  

   

  NOTE: With cases where the file was not found in the directory specified raising:
  
  KUP-04040: file %s in %s not found

  See:
  
  <Document 150737.1> ORA-29913, ORA-29400, KUP-04040 While Selecting from External Table
  <Document 1290722.1> "KUP-04040: file timezdif.csv in TIMEZDIF_DIR not found " logged by GATHER_STATS_JOB in alert.log after upgrade
  <Document 1305127.1> KUP-04040: file TRCA_CONTROL.txt in TRCA$STAGE not found

   

• Alternatively you may get text in the trace file like:
  
  
  *** 2012-09-10 05:00:11.921
  DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SH"','"SALES_TRANSACTIONS_EXT"','""', ...)
  DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
  ORA-29400: data cartridge error
  error opening file ../demo/schema/log/ext_1v3.log
    

Changes

Cause