Import Jobs Created Using EDLC Erroring Out: Exception encountered when submitUcmSoapRequest. The server sent HTTP status code 504: Gateway Time-out (Doc ID 2937469.1)

Last updated on MARCH 24, 2023

Applies to:

Symptoms

Using EDLC process to upload data file for Incentive Transaction.
While loading those files to the UCM server, it error out.



ERROR
Fri Jan 27 08:34:11 EST 2023 INFO: The size of input file F_Sales_Compensation_csv20230127080230.csv exceeds the file size limit of 250 MB, file splitting is required.
Fri Jan 27 08:34:11 EST 2023 INFO: dataSegmentNumberString :: 5
Fri Jan 27 08:34:11 EST 2023 INFO: splitCommand :: false
Fri Jan 27 08:34:11 EST 2023 INFO: There is no restriction on splitting files
Fri Jan 27 08:34:11 EST 2023 INFO: Input file has been split into 5 files.
Fri Jan 27 08:34:11 EST 2023 INFO: Command _split_import_data completed with status: CONTINUE
Fri Jan 27 08:34:11 EST 2023 INFO: Command _ucm_file_upload Starting...
Fri Jan 27 08:34:11 EST 2023 INFO: Command oracle.apps.crmcommon.core.fileimport.externaldataloader.util.ProgressIndicator Starting...
Fri Jan 27 08:34:11 EST 2023 INFO: Command oracle.apps.crmcommon.core.fileimport.externaldataloader.util.ProgressIndicator completed with status: CONTINUE
Fri Jan 27 08:40:40 EST 2023 INFO: Exception encountered when submitUcmSoapRequest. The server sent HTTP status code 504: Gateway Time-out
Fri Jan 27 08:40:40 EST 2023 INFO: Number of times to retry: 3. Thread ID is: 27
... etc ...
Fri Jan 27 09:01:32 EST 2023 INFO: Exception encountered when submitUcmSoapRequest. The server sent HTTP status code 504: Gateway Time-out
Fri Jan 27 09:01:32 EST 2023 INFO: Number of times to retry: 1. Thread ID is: 28
Fri Jan 27 09:02:43 EST 2023 INFO: Exception encountered when submitUcmSoapRequest. The server sent HTTP status code 504: Gateway Time-out
Fri Jan 27 09:02:43 EST 2023 SEVERE: Exception captured. Max retry count hit, throwing exception.
Fri Jan 27 09:02:43 EST 2023 SEVERE: Exception happened while uploading file: E:\XmlActivityRecords\Datalake_EDLC_OIC\osdlc_working\Incentive Transaction_submit_2023-01-27-08.33.38.892\F_Sales_Compensation_csv20230127080230_1.csv
Fri Jan 27 09:02:43 EST 2023 SEVERE: UCM Exception: The server sent HTTP status code 504: Gateway Time-out


STEPS
Follow process from Doc ID 2325249.1 External Data Loader Client (EDLC)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.