Query fails with ORA-03113 ORA-07445: exception encountered: core dump [kglpin()+527] [SIGSEGV] [ADDR:0x24] (Doc ID 2221403.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

Below statement fail with error

SELECT DISTINCT msg_id
2 FROM (
3 SELECT pain.msg_id,
4 CdtTrfTxInf.PmtIdInstrId tran_id_num
5 FROM pain_001_001_03 pain
6 JOIN TABLE (collection_wrapper(pb_msg_ids)) ids ON ids.COLUMN_VALUE = pain.msg_id,
7 XMLTable (XMLNAMESPACES('urn:iso:std:iso:20022:tech:xsd:pain.001.001.03' AS "ISOPain001"),
8 'hsbcEnvelope/hsbcMessageBody/ISOPain001:CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf'
9 PASSING pain.XML_msg
10 COLUMNS
11 -- PYMT_TRAN
12 PmtIdInstrId VARCHAR2(25) PATH 'PmtId/InstrId'
13 ) CdtTrfTxInf
14 GROUP BY pain.msg_id,
15 CdtTrfTxInf.PmtIdInstrId
16 HAVING COUNT(*) > 1
17 );

SELECT DISTINCT msg_id
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 11833
Session ID: 148 Serial number: 193


trace reporting the error below


ORA-07445: exception encountered: core dump [kglpin()+527] [SIGSEGV] [ADDR:0x24] [PC:0x99148B7] [Address not mapped to object] []

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ssexhd <- sighandler <- kglpin <- qcsResolveSqnRef <- 1638
<- qcsRslvName <- qcsoAnalyzeTableExp <- r_Cbk <- qcsAnalyzeExpr <- r_Cbk
<- qcsAnalyzeExpr_Proc <- essKids <- qcsoppls <- essKids <- qcsoProcessOpt
<- qcsAnalyzeExpr_Dflt <- qcsoAnalyzeTableExp <- r_Cbk <- qcsAnalyzeExpr <- r_Cbk
<- qcsosfpo <- qcsoptf <- qcsprfro <- qcsfpaj <- qcsprfro
<- qcsprfro_tree <- qcsprfro_tree <- qcspafq <- qcspqbDescendents <- qcspqb
<- qcsevw <- qcsfpsq <- kkmfcbsq <- kkmpfcbk <- qcsprfro
<- qcsprfro_tree <- qcsprfro_tree <- qcspafq <- qcspqbDescendents <- qcspqb
<- kkmdrv <- opiSem <- opiDeferredSem <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0
<- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino

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