My Oracle Support Banner

ORA-7445 [kxfrSmGetSlaveByPnum] from Parallel merge into INTERVAL partitioned table (Doc ID 1332825.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Error message similar to below could be seen in the generated trace file:

ORA-07445: exception encountered: core dump [kxfrSmGetSlaveByPnum()+501] [SIGFPE] [ADDR:0x1CE9217] [PC:0x1CE9217] [Integer divide by zero] []

Failing SQL statement:


MERGE /*+ APPEND PARALLEL("FACT_ORDERS") */ INTO "MI_DWUSER". "FACT_ORDERS" "FACT_ORDERS" USING (SELECT "DUTY_VALUES". "ORDER_QUANTITY" "ORDER_QUANTITY",
...
"DUTY_VALUES". "PRODUCT_STATUS_SK_ID" "PRODUCT_STATUS_SK_ID" FROM ( SELECT "SOURCE_FACT". "RRP" "RRP", "SOURCE_FACT". "SITE_PRICE" "SITE_PRICE",
...
"SOURCE_FACT". "STATUS_DAY_SK_ID" "STATUS_DAY_SK_ID" FROM ( SELECT "STG3_ORDER_STATUS". "ORDER_PRICE" "ORDER_PRICE",
...
"FACT_ORDERS". "LOCATION_SK_ID", "FACT_ORDERS". "CURRENCY_SK_ID", "FACT_ORDERS". "CUSTOMER_SK_ID", "FACT_ORDERS". "ADDRESS_SK_ID", "FACT_ORDERS". "PRODUCT_SK_ID", "FACT_ORDERS". "PROMOTION_SK_ID", "FACT_ORDERS". "ORDER_STATUS_SK_ID", "FACT_ORDERS". "PRODUCT_STATUS_SK_ID") VALUES ( "MERGE_SUBQUERY". "ORDER_QUANTITY", "MERGE_SUBQUERY". "RRP", "MERGE_SUBQUERY". "SITE_PRICE", "MERGE_SUBQUERY". "EURO_SITE_PRICE", "MERGE_SUBQUERY". "NET_SELLING_PRICE", "MERGE_SUBQUERY". "EURO_NET_SELLING_PRICE", "MERGE_SUBQUERY". "CHARGED_PRICE", "MERGE_SUBQUERY". "EURO_CHARGED_PRICE", "MERGE_SUBQUERY". "NET_REVENUE", "MERGE_SUBQUERY". "EURO_NET_REVENUE", "MERGE_SUBQUERY". "RRP_DISCOUNT", "MERGE_SUBQUERY". "DUTY", "MERGE_SUBQUERY". "EURO_DUTY", "MERGE_SUBQUERY". "DUTY_ADJ", "MERGE_SUBQUERY". "GST", "MERGE_SUBQUERY". "DUTY_RATE", "MERGE_SUBQUERY". "GST_RATE", "MERGE_SUBQUERY". "DISC_VAL", "MERGE_SUBQUERY". "EURO_DISCOUNT_VALUE", "MERGE_SUBQUERY". "ORDER_DATETIME", "MERGE_SUBQUERY". "SALE_DATETIME", "MERGE_SUBQUERY". "PRE_ORDER_IND", "MERGE_SUBQUERY". "ORDER_ID", "MERGE_SUBQUERY". "ORDER_DAY_SK_ID", "MERGE_SUBQUERY". "STATUS_DATE", "MERGE_SUBQUERY". "LOCATION_SK_ID", "MERGE_SUBQUERY". "CURRENCY_SK_ID", "MERGE_SUBQUERY". "CUSTOMER_SK_ID", "MERGE_SUBQUERY". "ADDRESS_SK_ID", "MERGE_SUBQUERY". "PRODUCT_SK_ID", "MERGE_SUBQUERY". "PROMOTION_SK_ID", "MERGE_SUBQUERY". "ORDER_STATUS_SK_ID", "MERGE_SUBQUERY". "PRODUCT_STATUS_SK_ID")


STACK:

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd 000000325C00DE70 kxfrSmGetSlaveByPnum kxfqkeyslv kxfqenq qertqoRop qervwRowProcedure qerhjLeftNullExtend2
qerhjWalkHashBucket2 qerhjFetchPhase2 qerhjFetch qervwFetch rwsfcd qertqoFetch qerpxSlaveFetch qerpxFetch upsexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc
kpuexec OCIStmtExecute kxfxsStmtExecute kxfxsExecute kxfxsp kxfxmai kxfprdp opirip opidrv sou2o opimai_real ssthrdmain main

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

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.