I have been losing my connection to our server all morning (SFTP connection). It worked for a few minutes and then quit. then an hour later it worked again. Now it doesn't. I have not changed any credentials and I have no problem making an SQL connection to the server. I am trying to build new tasks but cannot maintain a connection to the SFTP folder on our server.
Cannot connect to serve
- Last Post 21 June 2017
- Topic Is Solved
Could you please describe the issue more clearly. If we understood you correctly, you are encountering issue while connecting to your SFTP server in Skyvia UI (Test Connection button), however, your tasks with this connection run without any error?
Please specify the exact error you are getting and tell us the Authentication type you are using.
Looking forward to your reply.
Currently, I am getting the error 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host failed to respond'. However, the task runs but where it was taking 12-14 seconds to upsert, it is now taking 31 seconds to process the same 17 records.
and I just tested again and I get a good connection and the upsert took 13 seconds.
We continue to encounter this issue on a daily basis. Is there any way that either a) an email can be generated by this failure type or b) we can set the package to auto-run until a connection is made?
We are attempting to use a particular replication for time sensitive dashboard. When the connection goes down our team lives in the dark on important information.