Scheduled Imports with an SFTP connection - timeout error

mfestger
Kilo Contributor

‎05-25-2018 07:46 AM

I am attempting to schedule an import, and the data source is an xlsx file in a folder I have placed into an SFTP using the FileZilla server client.

The error I am receiving is: ava.io.IOException: SSH authentication failed, Timed out while waiting for TCP to connect: ( scheduled import job: userdata.xlsx (Uploaded))

Below is a screenshot of how the Data Source is set up. For the Server field, I have input the IP address my local machine is connected to. As for the username, that is also something I set up within the FileZilla server.

find_real_file.png

Does anybody have any tips or leads I can refer to solve this issue? 

Thank you!

Preview file
17 KB
0 Helpfuls
  • 1,126 Views
6 REPLIES 6

Syvo
Mega Guru

‎05-25-2018 08:21 AM

Hi,

Are you using a MID server?
Did it pickup the import command in the ECC Queue?
Are you sure your MID can reach your local machine?

0 Helpfuls

mfestger
Kilo Contributor
In response to Syvo

‎05-25-2018 08:42 AM

I am using FileZilla with the intention of using it as a midserver.

Yes, I believe the ECC Queue is picking it up.

As for your third question, I am not sure. Do you know of a way I can verify this?

Thank you so much!!

0 Helpfuls

Syvo
Mega Guru
In response to mfestger

‎05-25-2018 08:54 AM

I'm sorry, what do you mean by using FileZilla "as a mid server"?

If you want to upload your data to your instance (hosted on service-now.com?), chances are you don't expose your sftp server directly on the Internet, so the instance itself cannot reach it. You need to install a MID server in your private network, and have it connect to the instance.

Sorry if you know that already.

mfestger
Kilo Contributor
In response to Syvo

‎05-25-2018 08:57 AM

No, this more than likely explains my issue. I've never worked with setting up MID servers before so I appreciate your help!

0 Helpfuls