Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI sftp fails to retrieve files from EBS (Linux). Issue started after applying Jan CPU 2024

Rinosh DantisApr 15 2024 — edited Apr 15 2024

Hello,

After applying JAN CPU 2024, ODI started to exhibit the following behavior,

ODI-1226: Step Sftp Conc Output File fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: org.apache.commons.vfs2.FileSystemException: Unknown message with code "ODI-30089: Source file "o****.txt" does not exist".

The sftp command which was working fine for the past few years have started failing in our UAT instance where we have installed the JAN CPU 2024 patch. Once we rolled back the patches, sfpt started working again.

We have verified the file and file location. We were able to establish a connection to the EBS machine thru Win SCP and copy over the file with the same user used by ODI.

We have tried clearing the cache in ODI agent and studio.

We use standalone agent, current version of ODI: Build ODI_12.2.1.4.0OCIADWBP_GENERIC_231215.2000

Wondering if anyone have similar experience or error. Please let us know if there any possible solutions.

Thank you,

Rinosh

Comments
Post Details
Added on Apr 15 2024
1 comment
246 views