Scheduled import from SFTP

[priyadharis]

hi All we have a situation

we have a scheduled import set for 11 pm  and the data source pulls File from SFTP server

We checked that File was present until a min before the Job starts 

When job started , the job immediately failed with the message : java.io.IOException: Remove file failed: NO_SUCH_FILE: No such file and the file from sftp was removed. 

But when the File is placed again manually and if we execute the Job Manually everything Works right

any pointers?

[Ankur Bawiskar]

@priyadharis 

how are you fetching from SFTP?

please share the scripts and configurations etc along with screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[priyadharis]

in data source we gave the Server name , user  id & pwd , Connection URL along with remove_file = true

[Ankur Bawiskar]

@priyadharis 

the message clearly says that file is not present.

Did you ensure that file was present in that SFTP when your scheduled data source ran?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[priyadharis]

yes it was !