Endeca: Full Data Load Failed For Sandbox ONT (Doc ID 2031846.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.1.3.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.1 version, Endeca Intregration

When attempting to do a full load for ont, the following error occurs:

ERROR
2015-04-30 10:11:01,074 WARN 226439 [POPULATE_FD_RECORDS_INTO_TEMP_TABLE_226439] Clover input fields defined in both "sqlQuery" and "cloverFields" attributes --> getting value from "sqlQuery" attribute (INSERT INTO oe_endeca_temp
(LINE_ID, EID_ENDECA_ID, EID_RECORD_TYPE, EID_LOAD_TYPE, LINE_NUMBER, LINE_ATTACHMENT,
 LINE_FLEX, SALES_REP_NAME, CONVERTED_AMOUNT, DISPLAY_CURRENCY, ORIG_LINE_NUMBER,
 ORIG_SALES_REP_NAME, LAST_UPDATE_DATE,HOLD_NAME,ACTION_TYPE,INVENTORY_ITEM_ID,SHIP_FROM_ORG_ID,FROM_QUANTITY,
 FROM_UOM,PRIMARY_UOM,PRIMARY_QUANTITY, RESERVED_QUANTITY, RESERVED_STATUS )
VALUES ($LINE_ID, $EID_ENDECA_ID, 'FD', 'FULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL,NULL,$INVENTORY_ITEM_ID,$SHIP_FROM_ORG_ID,$TRANSACTION_QUANTITY,
 $PRIMARY_UOM,$ORG_PRIMARY_UOM,NULL, NULL,NULL)).
2015-04-30 10:11:01,074 WARN 226439 [POPULATE_RT_RECORDS_INTO_TEMP_TABLE_226439] Clover input fields defined in both "sqlQuery" and "cloverFields" attributes --> getting value from "sqlQuery" attribute (INSERT INTO oe_endeca_temp
(LINE_ID, EID_ENDECA_ID, EID_RECORD_TYPE, EID_LOAD_TYPE, LINE_NUMBER, LINE_ATTACHMENT,
 LINE_FLEX, SALES_REP_NAME, CONVERTED_AMOUNT, DISPLAY_CURRENCY, ORIG_LINE_NUMBER,
 ORIG_SALES_REP_NAME, LAST_UPDATE_DATE,HOLD_NAME,ACTION_TYPE,INVENTORY_ITEM_ID,SHIP_FROM_ORG_ID,FROM_QUANTITY,
 FROM_UOM,PRIMARY_UOM,PRIMARY_QUANTITY)
VALUES ($RETURN_LINE_ID, $EID_ENDECA_ID, 'RT', 'FULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL,NULL,
  $RETURN_ITEM_ID,$RETURN_SHIP_FROM_ORG_ID,$RETURN_TRANSACTION_QUANTITY,$RETURN_UOM,$RETURN_ITEM_PRIMARY_UOM,NULL)).
2015-04-30 10:13:23,181 WARN 226439 [LOAD_DFF_DATA_226439] Graph sandbox://Common/graph/DFF_GetFlexFieldData.grf finished with error.
2015-04-30 10:13:23,181 ERROR 226439 [WatchDog] Graph execution finished with error
2015-04-30 10:13:23,183 ERROR 226439 [WatchDog] Node LOAD_DFF_DATA finished with status: ERROR caused by: Graph 'sandbox://Common/graph/DFF_GetFlexFieldData.grf' failed!
2015-04-30 10:13:23,183 ERROR 226439 [WatchDog] Node LOAD_DFF_DATA error details:
org.jetel.exception.JetelException: Graph 'sandbox://Common/graph/DFF_GetFlexFieldData.grf' failed!


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