Full Load And Incremental Graphs Are Failing With Node ENDECA_BULK_ADD_OR_REPLACE_RECORDS1 Finished With Status: ERROR (Doc ID 2279897.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle iProcurement with Endeca, the full load graph ends with error.

The error seems to be occurring because the "Populate Endeca Metadata for iProcurement" concurrent program is not updating all MetaData.
If you look at the code of Metadata program, each time FND_EID_DDR_MGD_ATT_VALS table is purged and data is reloaded. But we are seeing, the WHO cloumns have last date on 06-Apr and that we executed program multiple times, but date is not changed.
So it seems program is not loading data or failing. But Program is completing Success, with no message in log file.


ERROR (from full load graph)
-----------------------
2017-04-11 14:57:29,172 ERROR 1308758 [SocketReader] Received error message from server: Attempt to add/replace record with unknown dimension value "107327" within dimension "SHOPPING_CATEGORY"
2017-04-11 14:57:29,185 ERROR 1308758 [WatchDog] Graph execution finished with error
2017-04-11 14:57:29,185 ERROR 1308758 [WatchDog] Node ENDECA_BULK_ADD_OR_REPLACE_RECORDS1 finished with status: ERROR
2017-04-11 14:57:29,185 ERROR 1308758 [WatchDog] Node ENDECA_BULK_ADD_OR_REPLACE_RECORDS1 error details:
2017-04-11 14:57:29,186 ERROR 1308758 [WatchDog] !!! Phase finished with error - stopping graph run !!!
 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the concurrent program "Populate Endeca Metadata for iProcurement". Allow it to complete.
2. Run the full load graph. The error occurs at this point.

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