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 AUGUST 20, 2020
Applies to:
Oracle Data Integrator - Version 11.1.1.6.0 and laterInformation 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:
java.lang.RuntimeException: Error occured in open tool execute method: {0}...Error: Check the ABAP Program: {0}:
LOG_DISP Not connected to FTP Server
LOG_DISP Unable to connect FTP Server
MESSAGE:Not connected to FTP Server
MESSAGE:Unable to connect FTP Server Background Process Ended at
at oracle.odi.sap.km._OdiSapAbapExecute.throwOdiException(_OdiSapAbapExecute.java:3040)
at oracle.odi.sap.km._OdiSapAbapExecute.chainedSAPException(_OdiSapAbapExecute.java:987)
at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:852)
at com.sunopsis.dwg.function.SnpsOpenToolFunction.actionExecute(SnpsOpenToolFunction.java:47)
at com.sunopsis.dwg.function.SnpsOpenToolFunction.execute(SnpsOpenToolFunction.java:148)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3449)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1510)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
...
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:
- LKM SAP ERP to Oracle (SQLLDR)
- LKM SAP ERP to SQL
- LKM SAP BW to Oracle (SQLLDR)
- LKM SAP BW to SQL
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |