ORA-7445 [LdiInterToTN] On SQL Analyze (Doc ID 1497493.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms



the following error occurs.

ERROR
-----------------------
ORA-7445: exception encountered: core dump [LdiInterToTN()+006c] [SIGSEGV] [ADDR:0x200000014] [PC:0x100CBC68C] [Address not mapped to object] []

The Call Stack Trace looks like:
msqbin k2copnws msqopnws msqskp k2copnws msqopnws msqskp k2copnws msqopnws msqfun k2copnws msqopnws xplUnparseOpn xplProjToText qknDoExplain_2 qknDoExplain qkngbExplain xpluls qknDoExplain_2 qknDoExplain qknflExplain xpluls xplGenXpl xplCommonDriver xplInMemoryXplanq ksanCapturePlanQknCbk kestsCaptureSimplePlanCbk kestsCaptureExecPlanCbk/

the failing statement reported in the trace file is:
/* SQL Analyze(679,1) */ SELECT I.IVT_ID, I.CREATED_TS, I.PARTITION_KEY, I.TXN_TS, TRUNC ( TXN_TS AT TIME ZONE (:B1 ),'HH24' ) + (1/24) TZ_HOUR_TS, I.PLAYER_ID, I.PROMOTION_BALANCE_SBCR, I.PROMOCASH_BALANCE_SBCR, I.CASH_BALANCE_SBCR, I.PROMOTION_STAKE_BALANCE_SBCR, I.PROMOCASH_STAKE_BALANCE_SBCR, I.CASH_STAKE_BALANCE_SBCR FROM IVT_HOURLY_BALANCE_DET I, ( SELECT IVT_ID, MAX(CREATED_TS) CREATED_TS FROM IVT_HOURLY_BALANCE_DET GROUP BY IVT_ID, TRUNC( TXN_TS AT TIME ZONE (:B1 ), 'HH24' ) ) M WHERE I.IVT_ID = M.IVT_ID AND I.CREATED_TS = M.CREATED_TS AND I.PARTITION_KEY = :B2 ORDER BY I.IVT_ID, I.CREATED_TS, PARTITION_KEY

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