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

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