I am running initial load in Production environment and receiving the following error:
8380 15224 DBS-070300 11/19/2013 1:54:55 PM
|Data flow DF_InventoryValuatnCumulative_SAP|Reader InnerJoinQuery
SQL submitted to Oracle Server <*****> resulted in error <ORA-00600: internal error code, arguments: [kcblasm_1], [103],
[], [], [], [], [], []
This is a generic Oracle error. My DBA says that the problem is caused by indexes on fields that have default values (’?’) as well as a min(nvarchar2) (minimum function on a varchar field).
This worked properly in a less powerful testing/QA environment. The SQL is a table INVENTORY_VALUATN_STAGE joined to itself.
Any ideas?
Generated SQL:
INSERT /*+ APPEND */ INTO "SAPRM"."INVENTORY_VALUATN_CUME" ( "INVENT_VALUATN_CONCAT_CODE" , "POST_DATE" , "MATERIAL_ID" , "PLANT_ID" , "VALUATN_AREA_ID" , "VALUATN_TYPE_ID" , "CLIENT_ID" , "CURR_ID" , "MTRL_GRP_ID" , "MTRL_TYPE_ID" , "CMPNY_CODE_ID" , "PROD_HIER_ID" , "AMT_UNRESTRCT_LABST" , "AMT_QA_INSME" , "AMT_UNRESTRCT_CONSIGN_KLABS" , "AMT_QA_CONSIGN_KINSM" , "AMT_RETURN_RETME" , "AMT_TRNFR_UMLME" , "AMT_TRNFR_PLANT_UMLMC" , "AMT_TRNST_PLANT_TRAME" , "AMT_RESTRICT_EINME" , "AMT_BLOCK_SPEME" , "AMT_RESTRICT_CONSIGN_KEINM" , "AMT_BLOCK_CONSIGN_KSPEM" , "AMT_TTL" , "AMT_VALUED_TTL" , "AMT_OTHER" , "AMT_UNKNOWN" , "AMT_UNRESTRCT_LABST_STD" , "AMT_QA_INSME_STD" , "AMT_UNRESTRCT_CONSIGNKLABS_STD" , "AMT_QA_CONSIGN_KINSM_STD" , "AMT_RETURN_RETME_STD" , "AMT_TRNFR_UMLME_STD" , "AMT_TRNFR_PLANT_UMLMC_STD" , "AMT_TRNST_PLANT_TRAME_STD" , "AMT_RESTRICT_EINME_STD" , "AMT_BLOCK_SPEME_STD" , "AMT_RESTRICT_CONSIGN_KEINM_STD" , "AMT_BLOCK_CONSIGN_KSPEM_STD" , "AMT_TTL_STD" , "AMT_VALUED_TTL_STD" , "AMT_OTHER_STD" , "AMT_UNKNOWN_STD" , "QTY_UNRESTRCT_LABST" , "QTY_QA_INSME" , "QTY_UNRESTRCT_CONSIGN_KLABS" , "QTY_QA_CONSIGN_KINSM" , "QTY_RETURN_RETME" , "QTY_TRNFR_UMLME" , "QTY_TRNFR_PLANT_UMLMC" , "QTY_TRNST_PLANT_TRAME" , "QTY_RESTRICT_EINME" , "QTY_BLOCK_SPEME" , "QTY_RESTRICT_CONSIGN_KEINM" , "QTY_BLOCK_CONSIGN_KSPEM" , "QTY_TTL" , "QTY_VALUED_TTL" , "QTY_OTHER" , "QTY_UNKNOWN" , "MATERIAL_KEY" , "POST_DATE_KEY" , "LOAD_DATE" , "LOAD_TIME" )
SELECT "INVENTORY_VALUATN_STAGE"."INVENT_VALUATN_CONCAT_CODE" INVENT_VALUATN_CONCAT_CODE , "INVENTORY_VALUATN_STAGE"."POST_DATE" POST_DATE , "INVENTORY_VALUATN_STAGE"."MATERIAL_ID" MATERIAL_ID , "INVENTORY_VALUATN_STAGE"."PLANT_ID" PLANT_ID , "INVENTORY_VALUATN_STAGE"."VALUATN_AREA_ID" VALUATN_AREA_ID , "INVENTORY_VALUATN_STAGE"."VALUATN_TYPE_ID" VALUATN_TYPE_ID , $G_CLIENT_ID CLIENT_ID , min( "INVENTORY_VALUATN_STAGE"."CURR_ID" ) CURR_ID , min( "INVENTORY_VALUATN_STAGE"."MTRL_GRP_ID" ) MTRL_GRP_ID , min( "INVENTORY_VALUATN_STAGE"."MTRL_TYPE_ID" ) MTRL_TYPE_ID , min( "INVENTORY_VALUATN_STAGE"."CMPNY_CODE_ID" ) CMPNY_CODE_ID , min( "INVENTORY_VALUATN_STAGE"."PROD_HIER_ID" ) PROD_HIER_ID , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNRESTRCT_LABST" ) AMT_UNRESTRCT_LABST , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_QA_INSME" ) AMT_QA_INSME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNRESTRCT_CONSIGN_KLABS" ) AMT_UNRESTRCT_CONSIGN_KLABS , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_QA_CONSIGN_KINSM" ) AMT_QA_CONSIGN_KINSM , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RETURN_RETME" ) AMT_RETURN_RETME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNFR_UMLME" ) AMT_TRNFR_UMLME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNFR_PLANT_UMLMC" ) AMT_TRNFR_PLANT_UMLMC , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNST_PLANT_TRAME" ) AMT_TRNST_PLANT_TRAME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RESTRICT_EINME" ) AMT_RESTRICT_EINME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_BLOCK_SPEME" ) AMT_BLOCK_SPEME , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RESTRICT_CONSIGN_KEINM" ) AMT_RESTRICT_CONSIGN_KEINM , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_BLOCK_CONSIGN_KSPEM" ) AMT_BLOCK_CONSIGN_KSPEM , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TTL" ) AMT_TTL , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_VALUED_TTL" ) AMT_VALUED_TTL , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_OTHER" ) AMT_OTHER , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNKNOWN" ) AMT_UNKNOWN , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNRESTRCT_LABST_STD" ) AMT_UNRESTRCT_LABST_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_QA_INSME_STD" ) AMT_QA_INSME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNRESTRCT_CONSIGNKLABS_STD" ) AMT_UNRESTRCT_CONSIGNKLABS_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_QA_CONSIGN_KINSM_STD" ) AMT_QA_CONSIGN_KINSM_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RETURN_RETME_STD" ) AMT_RETURN_RETME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNFR_UMLME_STD" ) AMT_TRNFR_UMLME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNFR_PLANT_UMLMC_STD" ) AMT_TRNFR_PLANT_UMLMC_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TRNST_PLANT_TRAME_STD" ) AMT_TRNST_PLANT_TRAME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RESTRICT_EINME_STD" ) AMT_RESTRICT_EINME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_BLOCK_SPEME_STD" ) AMT_BLOCK_SPEME_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_RESTRICT_CONSIGN_KEINM_STD" ) AMT_RESTRICT_CONSIGN_KEINM_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_BLOCK_CONSIGN_KSPEM_STD" ) AMT_BLOCK_CONSIGN_KSPEM_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_TTL_STD" ) AMT_TTL_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_VALUED_TTL_STD" ) AMT_VALUED_TTL_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_OTHER_STD" ) AMT_OTHER_STD , sum( "INVENTORY_VALUATN_STAGE_1"."AMT_UNKNOWN_STD" ) AMT_UNKNOWN_STD , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_UNRESTRCT_LABST" ) QTY_UNRESTRCT_LABST , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_QA_INSME" ) QTY_QA_INSME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_UNRESTRCT_CONSIGN_KLABS" ) QTY_UNRESTRCT_CONSIGN_KLABS , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_QA_CONSIGN_KINSM" ) QTY_QA_CONSIGN_KINSM , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_RETURN_RETME" ) QTY_RETURN_RETME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_TRNFR_UMLME" ) QTY_TRNFR_UMLME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_TRNFR_PLANT_UMLMC" ) QTY_TRNFR_PLANT_UMLMC , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_TRNST_PLANT_TRAME" ) QTY_TRNST_PLANT_TRAME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_RESTRICT_EINME" ) QTY_RESTRICT_EINME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_BLOCK_SPEME" ) QTY_BLOCK_SPEME , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_RESTRICT_CONSIGN_KEINM" ) QTY_RESTRICT_CONSIGN_KEINM , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_BLOCK_CONSIGN_KSPEM" ) QTY_BLOCK_CONSIGN_KSPEM , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_TTL" ) QTY_TTL , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_VALUED_TTL" ) QTY_VALUED_TTL , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_OTHER" ) QTY_OTHER , sum( "INVENTORY_VALUATN_STAGE_1"."QTY_UNKNOWN" ) QTY_UNKNOWN , min( "INVENTORY_VALUATN_STAGE"."MATERIAL_KEY" ) MATERIAL_KEY , min( "INVENTORY_VALUATN_STAGE"."POST_DATE_KEY" ) POST_DATE_KEY , $G_LOAD_DATE LOAD_DATE , $G_LOAD_TIME LOAD_TIME
FROM "SAPRM"."INVENTORY_VALUATN_STAGE" "INVENTORY_VALUATN_STAGE_1" INNER JOIN "SAPRM"."INVENTORY_VALUATN_STAGE" "INVENTORY_VALUATN_STAGE" ON ( "INVENTORY_VALUATN_STAGE"."INVENT_VALUATN_CONCAT_CODE" = "INVENTORY_VALUATN_STAGE_1"."INVENT_VALUATN_CONCAT_CODE" ) AND
( "INVENTORY_VALUATN_STAGE"."POST_DATE" >= "INVENTORY_VALUATN_STAGE_1"."POST_DATE" )
WHERE ( "INVENTORY_VALUATN_STAGE"."CLIENT_ID" = $G_CLIENT_ID )
GROUP BY "INVENTORY_VALUATN_STAGE"."INVENT_VALUATN_CONCAT_CODE" , "INVENTORY_VALUATN_STAGE"."POST_DATE" , "INVENTORY_VALUATN_STAGE"."MATERIAL_ID" , "INVENTORY_VALUATN_STAGE"."PLANT_ID" , "INVENTORY_VALUATN_STAGE"."VALUATN_AREA_ID" , "INVENTORY_VALUATN_STAGE"."VALUATN_TYPE_ID"
abooth (BOB member since 2011-07-08)