My Oracle Support Banner

ANSI Join Query Fails with ORA-07445 [kokmrwo_agg()+114] When Used With Rollup Clause (Doc ID 1960865.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

Running an ANSI join query with rollup fails with:


ORA-07445: exception encountered: core dump [kokmrwo_agg()+114] [SIGSEGV] [ADDR:0x0] [PC:0x14270E2] [Address not mapped to object] []

An example of a failing query is:

 

select *
from (select TECH_BK_PROD_CNTR,
count(1) REP_NUMNOTYETDUE, count(1) REF_NUMNOTYETDUE, sum(1) REP_USDNOTYETDUE,
sum(1) REF_USDNOTYETDUE, count(1) REP_NUMONTIME, count(1) REF_NUMONTIME,
sum(1) REP_USDONTIME, sum(1) REF_USDONTIME, count(1) REP_NUMLT,
count(1) REF_NUMLT, sum(1) REP_USDLT, sum(1) REF_USDLT,
count(1) REP_NUMTOT,count(1) REF_NUMTOT, sum(1) REP_USDTOT,
sum(1) REF_USDTOT
from (select PYMNT.TECH_BK_PROD_CNTR, PYMNT.YR, PYMNT.MNTH
from T_TAU_KPIPYMNT PYMNT
) INNER_QRY
inner join T_TAU_KPIPRD PRD
on (INNER_QRY.YR = PRD.YR and INNER_QRY.MNTH = PRD.MNTH)
group by rollup(TECH_BK_PROD_CNTR)) UNPIVOT INCLUDE nulls((ref, REP) for MEASURE in((REF_NUMNOTYETDUE, REP_NUMNOTYETDUE) as 'Not Yet Due, #',
(REF_USDNOTYETDUE, REP_USDNOTYETDUE) as 'Not Yet Due, AUDm',
(REF_NUMTOT, REP_NUMTOT) as 'Total, #',
(REF_USDTOT, REP_USDTOT) as 'Total, AUDm')) PIVOT(max(REP) "!", max(ref) "*" for TECH_BK_PROD_CNTR in('Total' as "Total",
'Americas' as "Americas",
'Asia' as "Asia",
'EMEA' as "EMEA",
'Global' as "Global"));

 

The call stack in the incident trace file written by the error contains all or some of the following functions:

kokmrwo_agg <- kokmrwo <- qkagby <- qkaqkn <- qkadrv

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.