SFTP Data Source error

[Russ T]

Hi all

I need to import a CSV file via SFTP. I have created and tested the transform maps etc using a file upload and all works fine.

I've now set up an SFTP account as I need this job to run on a schedule. However I am getting the following error (some data redacted):

12-04-2017 09:39
Error com.glide.db.impex.datasource.DataSourceException: java.io.IOException: Error reading from remote file. Exited with following status: SFTP started import_processor_worker
Select record for action Preview
12-04-2017 09:39
Information Using tempFile: /glide/nodes/XXXXXX003_16032/bin/../tmp/ids036c1a0edb427600602d36fffe9619a4.csv DataSource
Select record for action Preview
12-04-2017 09:39
Information Loading CSV file using SFTP DataSource
Select record for action Preview
12-04-2017 09:39
Information getAsFile: sftp://***:***@XXXXXXX:22/Primary_Users.csv DataSource
Select record for action Preview
12-04-2017 09:39
Information Using sftp handler

I can connect fine using an SFTP client and see the file. I've tried specifying the file name with a ./ and / prefix also with the same error. This is on Geneva.

I get a different error on my personal instance (Istanbul):

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: Problem opening a handle to remote file: ./Primary_Users.csv

I'm a bit stuck, Google and community search haven't turned up anything. Anyone got any ideas or pointers?

Thanks

Russ

[Alikutty A]

Hi Russ,

Is SFTP server accessible on the internet? Your instance may not have access on the SFTP server. Please create a HI ticket to allow the IP address to be accessible and then it should work.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[Ravi Gupta1]

Hi Russ T,

I am also getting the same (below) error. How did you resolve it?

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: Problem opening a handle to remote file:

Could you please assist.

Thanks

Ravi

[mohitgupta14003]

Facing Same Issue any lead?