ORA-07445 [evaopn3()+135] from an XQuery with GROUP BY clause (Doc ID 1377061.1)

Last updated on OCTOBER 01, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
*** Checked for relevance on 02-Oct-2014 ***

Symptoms

An XQuery with GROUP BY clause such as below:

with STATS AS
(
  SELECT ITM_ACSN_ID, XML.PValue, XML.PtBisValue, XML.BValueRasch
  FROM RPT_LIST,
   XMLTABLE('/STAT_CONTEXTS'
   passing find_print_statisitcs(ITM_ACSN_ID, RPT_RQST_ID, ITM_CNTNT_VRSN_SEQ)
   columns
    PValue number path 'STAT_CONTEXT/STATISTIC[@STAT_ID="950408399"]/@STAT_VAL',
    PtBisValue number path 'STAT_CONTEXT/STATISTIC[@STAT_ID="162149141"]/@STAT_VAL',
    BValueRasch number path 'STAT_CONTEXT/STATISTIC[@STAT_ID="162149337"]/@STAT_VAL'
) AS XML
WHERE RPT_RQST_ID=22907
),
AGGS AS
(
SELECT TST_CDE, RptCatNo, ROUND(AVG(PValue), 4) AS APValue,
 ROUND(AVG(PtBisValue), 4) AS APtBisValue, ROUND(AVG(BValueRasch), 4) AS ABValueRasch,
 ROUND(MIN(BValueRasch), 4) AS NBValueRasch, ROUND(MAX(BValueRasch), 4) AS XBValueRasch
FROM TEST inner JOIN STATS USING (ITM_ACSN_ID)
GROUP BY TST_CDE, RptCatNo
),
TRANSPORT AS
(
SELECT TST_CDE, RptCatNo
FROM AGGS
)
SELECT TST_CDE
FROM TRANSPORT
GROUP BY TST_CDE;


Fails with error

Errors in file /bugmnt16/am/celclnx17/SR3.2169629601/app/oracle/diag/rdbms/tarsm1/TARSM1/trace/TARSM1_ora_10116.trc (incident=90179):
ORA-07445: exception encountered: core dump [evaopn3()+135] [SIGSEGV] [ADDR:0x4] [PC:0x8F323E3] [Address not mapped to object] []


Incident trace file show the  following call stack:

evaopn3 kkxmsiag evapls evaopn2 evaopn2 evaopn2 qmxtkXSeqStart_h qmxtkXML

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