My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.