App Connect

 View Only
  • 1.  ACE and SFTP behavior

    Posted Thu August 15, 2024 09:39 PM

    Hi,

    One of the ACE flow is polling files from a remote SFTP server using FileInput node and process it. As soon as ACE picks the file , the file is being deleted from the remote SFTP server. Is the deletion of file from SFTP server  by ACE is an expected behavior or is there a way we can configure in ACE, not to delete the file after polling from SFTP server?



    ------------------------------
    Thanks,
    Santhosh Ramanathan
    ------------------------------


  • 2.  RE: ACE and SFTP behavior

    Posted Mon August 19, 2024 02:28 AM

    Hi Santhosh,

    Yes this is expected behaviour. The fileInput node doesn't keep track of which files already read.
    If the file remains on the server in the same location and ACE polls again the directory the file is read again.

    more info about file processing:
    https://www.ibm.com/docs/en/app-connect/12.0?topic=files-how-integration-node-processes

    If you want to keep the file on the ftp server you can put the file in a processed folder on the ftp server after processing.
    Another possibility is to use IBM MQ Filetransfer Edition and setup a FteAgent(on the remote server) and FteMonitor that keeps track of the files read and sends to the FTEInput node.
    Other options with fileExists and fileRead node is probably also possible but then you need to keep a state of which files you already read and this is probably not a good idea.



    ------------------------------
    Kim Meynendonckx
    ------------------------------



  • 3.  RE: ACE and SFTP behavior

    Posted Tue August 20, 2024 12:48 PM

    Hi Santhosh,

    Try to use the file read node with 'Delete remote file after successful transfer'  properties as No under FTP tab of the fileRead Node & trigger the flow with some external scheduler (like a cron job).

    https://www.ibm.com/docs/en/integration-bus/9.0.0?topic=nodes-fileread-node

    Thanks,

    Vishal



    ------------------------------
    VISHAL GUPTA
    ------------------------------



  • 4.  RE: ACE and SFTP behavior

    Posted Wed August 21, 2024 03:02 AM

    Hi,

    yes that works.. But then you need to update your filename pattern to read for example only the file created that day with a filename that contain the date of that day or your trigger needs to contain the exact filename that you want to read.

    mvg

    Kim



    ------------------------------
    Kim Meynendonckx
    ------------------------------