I have a requirement where I have to retrieve 6 files based on set of names from a FTP destination.
These six files represent data for one plant and I am looping plant wise to get all files and updating in custom tables.
problem is connectivity gets disrupted after random GET file attempt in FTP_SERVER_TO_R3 and it keeps
processing and nothing else gets updated.
I have checked with network issues and didn't find any.
I have also tried reconnecting FTP_CONNECT after every loop iteration and still problem persist.
program gets stuck only at FTP_SERVER_TO_R3 and doesn't go forward.