kxfrSmGetSlaveByPnum

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

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

This is due to unpublished Bug9217342

Solution

The versions confirmed by this Bug9217342 are 11.2.0.1 and 11.1.0.7 and the bug is fixed on 12.1 (Future Release)11.2.0.2 (Server Patch Set).Apply patch for Bug9217342 to resolve the issue.
Check availability of the patch for your Database/OS version.If not avaialble,create a service request with Oracle Support.