ORA-07445: [ldxsnf] with KUP-03018: invalid date mask "" specified for column

(Doc ID 1482732.1)

Last updated on APRIL 03, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms


ORA-07445: exception encountered: core dump [ldxsnf()+4356] [SIGSEGV] [ADDR:0x8] [PC:0x1073ED464] [Address not mapped to object] []
KUP-03018: invalid date mask "" specified for column

In other cases the error reported can  be

  ORA-07445: exception encountered: core dump [ldxsnfcom()+433] [SIGSEGV]
  [ADDR:0x8] [PC:0x9ED7CCD] [Address not mapped to object] []
  KUP-03018: invalid date mask "" specified for column
  
  OR
  
  ORA-07445: exception encountered: core dump [_pRawDllMain()+1619763703]
  [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x608CF5A7] [UNABLE_TO_READ] []
  KUP-03018: invalid date mask "" specified for column

Stack Trace:

============

ldxsnf ldxsto kudmgdt kudmgdt kudmgfl kudmgfl kudmgfl kudmgfl kudmiparms kudmxo

Plan Table
============
---------------------------------------------------------------+-----------------------------------+-------------------------+
| Id  | Operation                         | Name               | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib |
---------------------------------------------------------------+-----------------------------------+-------------------------+
| 7   |        EXTERNAL TABLE ACCESS FULL | T_PREAPRVL_EXT_TEST|  8168 |  207K |     2 |  00:00:01 |:Q1000| PCWP |           |
---------------------------------------------------------------+----------------


In this case the error occurred when executing the statement below:


/* SQL Analyze(1) */ select /*+  full(t)    parallel(t,default) parallel_index(t,default) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad  */to_char(count("PAYER_ID")),to_char(substrb(dump(min("PAYER_ID"),16,0,32),1,120)),to_char(substrb(dump(max("PAYER_ID"),16,0,32),1,120)),to_char(count("CREATE_DATE")),to_char(substrb(dump(min("CREATE_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("CREATE_DATE"),16,0,32),1,120)) from "BMLOP"."T_PREAPRVL_EXT_TEST" t  /* NDV,NIL,NIL,NDV,NIL,NIL*/

 

 

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