ODI Open Interface SAP Adapter Fails Deleting File From FTP Server Using ZODI_RFC_DELETE_FTP_FILE

(Doc ID 1999013.1)

Last updated on MARCH 08, 2018

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When using Open Interface Adapter with ODI the delete FTP Files step of LKM SAP ERP TO SQL Version 32 fails when trying to delete a text file from FTP Server. 

An error is returned and the file is not deleted:

java.lang.RuntimeException: Error occured in open tool execute method: {0}...Error in executing ABAP program: {0}...Syntax error in program SAPLZODI_FGR_PROD .
Cause: Syntax error in program SAPLZODI_FGR_PROD .
  at oracle.odi.sap.km._OdiSapAbapExecute.throwOdiException(_OdiSapAbapExecute.java:2730)
  at oracle.odi.sap.km._OdiSapAbapExecute.chainedSAPException(_OdiSapAbapExecute.java:763)
  at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:633)
  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:3437)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.

Cause

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 hundreds of Community platforms