Fusion EXTERNAL_STORAGE_INTEGRATION_DOWNLOAD Step FILE_DOWNLOAD_STEP Fails with FILE_DOWNLOAD_ERROR
(Doc ID 2631476.1)
Last updated on JANUARY 22, 2020
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
BIApps (OBIA) - 188.8.131.52.1 and higher.
Source System Fusion HCM
Module Configured HCM HR
Java Update to above version. TLS 1.2 also was updated.
After doing above upgrades it started failing twice in a week, now its failing every day. The workaround is to restart then it will go to success.
Fusion Load Plan failure in session: SESS_<Session ID>_EXTERNAL_STORAGE_INTEGRATION_DOWNLOAD
When issue happens it is after about 5 min after establishing connection. Whatever number of files downloaded during those 5 minutes worked, then the error (see below).
The workaround is to restart the Load, and it works the second time.
This is while doing Full Loads, which are necessary to deal with source deleted records.
ODI Agent log shows:
[2019-12-13T01:05:20.456-06:00] [odi_server1] [WARNING] [ODI-1134]  [tid: <TID>] [userId: ] [ecid: 0000Mvy4UEH3JBPMueI7UH1TwWrv0000dh,1:23078] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-17517: Error during task interpretation.[[
java.lang.Exception: The application script threw an exception: java.lang.Exception: Error occured when downloading Files, Error Code returned by the Driver is :: FILE_DOWNLOAD_ERROR BSF info: Download from UCM at line: 0 column: columnNo
Caused by: org.apache.bsf.BSFException: The application script threw an exception: java.lang.Exception: Error occured when downloading Files, Error Code returned by the Driver is :: FILE_DOWNLOAD_ERROR BSF info: Download from UCM at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
... 11 more
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document