My Oracle Support Banner

ODI Loading Error "Unable to connect FTP Server" or "User has no access" when Using FTP/FTPJDBC Data Server and SAP KM (Doc ID 2334202.1)

Last updated on OCTOBER 03, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

When a user executes an Oracle Data Integator (ODI) 11g interface or 12c mapping using SAP ERP or BW knowledge modules with a FTP/FTPJDBC context, the execution fails at step "Extract Data" with one of the following error messages:

or

oracle.odi.km.exception.OdiKMException: Error occurred in open tool execute method: {0}...Error: Check the ABAP Program: {0}:
LOG_DISP User <USER> has no access authorization for
MESSAGE:User <USER> has no access authorization for computer <IP_ADDRESS>
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at oracle.odi.sap.km._OdiSapAbapExecute.throwOdiException(_OdiSapAbapExecute.java:3202)
  at oracle.odi.sap.km._OdiSapAbapExecute.chainedSAPException(_OdiSapAbapExecute.java:1089)
  at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:954)
  at com.sunopsis.dwg.function.SnpsOpenToolFunction.actionExecute(SnpsOpenToolFunction.java:47)
  ...

The knowledge modules that show the above errors are:

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.