SFTP initialization error

More
5 years 3 months ago #20904 by JohnIngles
I'm getting this error in my scheduled package. Following FTP Error happened Cannot perform initialization on an active SFTP client. This comes after uploading several other files to the same sftp folder with the same object. We've tried adding pauses between the previous upload and this one (up to 10 minutes), changing the ftp object to a different one pointing at the same place, and putting the ftp object in a sub-package within the package.

Getting this file to post is very important because it needs to be loaded from the ftp to trigger their database to refresh.

They also want all the individual files to have success and error emails so all the files that need to be uploaded have to have their own ftp objects (in order to catch successes and errors and send the emails)

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #20905 by admin
Replied by admin on topic SFTP initialization error
Hello

It is hard to tell what is wrong in your case.
(If there is something wrong with our software)
Would be possible for us to connect to your SFTP server?

EG: create a user etltools and email us the details

we will then connect remotely and run tests

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #20906 by JohnIngles
I'm afraid I can't let you connect to our sftp server and in any case I don't think it will help much. The upload works fine most of the time but fails consistently on one of the sftp upload objects. It's definitly a problem with the software because this sftp works 99% of the time but will tend to get the active client error if too many sftp objects are called one after another. My guess is that the object (when it finishes or fails) doesn't properly close the sftp connection before the next object is run. MOst of the times we get this error, adding a small pause fixes it. In this case the previous upload object is usually failing (the file it looks for isn't always there) and this failure seems to leave the connection open.

In the picture attached all the US2 objects are the same.
Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #20914 by admin
Replied by admin on topic SFTP initialization error
Hi John

Can you try the latest version, please

19/04/2021 - 6.3.7.18

- Fixed: SFTP Upload issues when no files are found

PS: I really like your package screenshot it is a good example of what our users use our software for

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save