ORA-00600:[qctginf : Opncsfrm]/ORA-7445 [OPITCA] (Doc ID 1505853.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

On : 11.2.0.3 version, Internals Errors (ORA-600 & ORA-7445)

When attempting to run the following,
with calendar as (
  select
  1 as periodKey
  , 1 as contigKey
  , TO_CHAR(1, '00') as mpKey
  , 'Aug 2011' as periodDisplay
  , to_date('20110801', 'yyyymmdd') as periodStart
  , to_date('20110831', 'yyyymmdd') as periodEnd
  from dual
)
select
  cal.periodKey as periodKey
  , cal.periodDisplay as periodDisplay_1
  , min(cal.periodStart) as startDate_1
  , max(cal.periodEnd) as endDate_1
  , tp.id as h1ID
  , decode(grouping(tp.id), 1, 'ALL SELECTED', tp.name) as h1Name
  , grouping(tp.id) as g_h1ID
  , pg.id as h2ID
  , decode(grouping(pg.id), 1, 'ALL SELECTED', pg.groupName) as h2Name
  , grouping(pg.id) as g_h2ID
  , rn.region_id as h3ID
  , decode(grouping(rn.region_id), 1, 'ALL SELECTED', rn.region_name) as h3Name
  , grouping(rn.region_id) as g_h3ID
  , round(nvl(sum(r867.SSUnits + r867.SUUnits + r867.DSUnits), 0), 2) as tsu_1
from calendar cal
inner join tradingPartners tp
  inner join sessionreports_values
  on lookup_hash = ora_hash('sid94332ritm2')
  and value = tp.id
  and datasource_id = 1
  on 1 = 1
inner join tradingPartnerLoc tpl
  on tpl.partnerID = tp.id
inner join productMaster pm
  inner join sessionreports_values
  on lookup_hash = ora_hash('sid94332ritm7')
  and value = pm.id
  and datasource_id = 1
  on 1 = 1
inner join (
  select /*+ no_merge */
  rg.region_id
  , rgt.name || ' ' || rg.region_name as region_name
  from (
  select /*+ no_merge */ distinct
  connect_by_root rg.id as region_id
  , connect_by_root rg.regionname as region_name
  , connect_by_root rg.tierlevelid as tierlevelid
  from regionGroupsD rg
  where rg.criteria = 3
  start with id in (2265,2120)
  connect by nocycle prior rg.id = rg.parentid
  ) rg
  inner join regiongroups_tierlevels rgt
  on rg.tierlevelid = rgt.id
) rn
  on 1 = 1
left join productGroupRef pgr
  inner join sessionreports_values
  on lookup_hash = ora_hash('sid94332ritm8')
  and value = pgr.groupID
  and datasource_id = 1
  on pgr.productID = pm.id
left join productGroups pg
  on pg.id = pgr.groupID
left join (
  select /*+ no_merge */
  r.partnerID
  , r.dcRetailID
  , r.productID
  , r.clientLevelID
  , cal.periodKey
  , loc.outlet_loc_id
  , loc.region_id
  , nvl(sum(case when r.reportingDate between cal.periodStart and cal.periodEnd then r.ss else 0 end), 0) as SSUnits
  , nvl(sum(case when r.reportingDate between cal.periodStart and cal.periodEnd then r.su else 0 end), 0) as SUUnits
  , nvl(sum(case when r.reportingDate between cal.periodStart and cal.periodEnd then r.ds else 0 end), 0) as DSUnits
  from calendar cal
  inner join reportingData_867 r
  on r.reportingDate between cal.periodStart and cal.periodEnd
  inner join (
  select 1 as id, 3 as outlet_loc_id, 4 as region_id from dual
  ) loc
  on loc.id = r.raw_outlet_key_id
  inner join tradingPartners tp
  inner join sessionreports_values
  on lookup_hash = ora_hash('sid94332ritm2')
  and value = tp.id
  and datasource_id = 1
  on tp.id = r.partnerID
  inner join tradingPartnerLoc tpl
  on tpl.id = r.dcRetailID
  inner join productMaster pm
  inner join sessionreports_values
  on lookup_hash = ora_hash('sid94332ritm7')
  and value = pm.id
  and datasource_id = 1
  on pm.id = r.productID
  left join priceChangeHistory pch
  on pch.productID = r.productID
  and pch.effectiveDate = r.reportingDate
  and pch.scheduleID = coalesce(tpl.scheduleID, tp.scheduleID, 1)
  where
  r.reportingDate between to_date('20110801', 'yyyymmdd') and to_date('20110831', 'yyyymmdd')
  and tp.active = 1
  and tp.deleted = 0
  and NVL(tpl.inactive_date, SYSDATE+1) > to_date('20110601', 'yyyymmdd')
  and tpl.deleted = 0
  and NVL(pm.inactive_date, SYSDATE+1) > to_date('20110601', 'yyyymmdd')
  and pm.deleted = 0
  group by
  r.partnerID
  , r.dcRetailID
  , r.productID
  , r.clientLevelID
  , loc.outlet_loc_id
  , cal.periodKey
  , loc.region_id
) r867
  on r867.periodKey = cal.periodKey
  and r867.partnerID = tp.id
  and r867.dcRetailID = tpl.id
  and r867.productID = pm.id
  and r867.region_id = rn.region_id
where NVL(pm.inactive_date, SYSDATE+1) > to_date('20110601', 'yyyymmdd')
  and pm.deleted = 0
  and tp.active = 1
  and tp.deleted = 0
  and NVL(tpl.inactive_date, SYSDATE+1) > to_date('20110601', 'yyyymmdd')
  and tpl.deleted = 0
group by rollup (
  (cal.periodKey, cal.periodDisplay, (cal.mpKey || cal.contigKey))
  , (tp.id, tp.name)
  , (pg.id, pg.groupName)
  , (rn.region_id, rn.region_name)
)
having (
  grouping_id(
  cal.periodKey
  , tp.id
  , pg.id
  , rn.region_id
  ) = 1
)
order by grouping(tp.name) desc, upper(tp.name)
  , grouping(pg.groupName) desc, upper(pg.groupName)
  , grouping(rn.region_name) desc, upper(rn.region_name)
  , cal.periodKey desc

the following error occurs.

ERROR
-----------------------
ORA-00600: internal error code, arguments: [qctginf : opncsfrm], [1], [1], [0], [0], [1], [3], [8], [], [], [], []

Call Stack
----------------------
qctginf <- qctosop <- qctcopn <- qctcpqb <- qctcpqbl <- xtydrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor

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