Error Setting Up SFTP in Automation

Toad Data Point & Toad Intelligence Central
1

Good day everyone and Happy New Year

Earlier, I was trying to set-up an Automation Task to SFTP a file from an UNIX server to my local PC. Then, I got the next error when configuring the SFTP Activity Properties:

EnterpriseDT.Net.Ftp.Ssl.SSLFTPException
Method/property not valid for SFTP
Stack Trace:
en EnterpriseDT.Net.Ftp.SecureFTPConnection.CheckFTPType(Boolean ftpOnly)
en EnterpriseDT.Net.Ftp.FTPConnection.GetSystemType()
en EnterpriseDT.Net.Ftp.ExFTPConnection.GetSystemType()
en Quest.Toad.Workflow.Activities.FtpOperationForm.FtpOperationForm_Load(Object sender, EventArgs e)
en System.EventHandler.Invoke(Object sender, EventArgs e)
en System.Windows.Forms.Form.OnLoad(EventArgs e)
en DevExpress.XtraEditors.XtraForm.OnLoad(EventArgs e)
en System.Windows.Forms.Form.OnCreateControl()
en System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
en System.Windows.Forms.Control.CreateControl()
en System.Windows.Forms.Control.WmShowWindow(Message& m)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
en System.Windows.Forms.ContainerControl.WndProc(Message& m)
en System.Windows.Forms.Form.WmShowWindow(Message& m)
en System.Windows.Forms.Form.WndProc(Message& m)
en DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

This same error appear when trying to select “Remote Directory” and/or “Operation Options” in the FTP File Activity Properties. I’ve tried many time to set-up the Automation Task all-over again, with no success.

Also tried using FTP, and then got no error selecting “Remote Directory” and/or “Operation Options”. But, when in “Operation Options”, tried to change Remote Directory to another folder deeper than root directory “/” and then another error popped-out:

EnterpriseDT.Net.Ftp.FTPException
Failed to change directory. (code=550)
Stack Trace:
en EnterpriseDT.Net.Ftp.FTPControlSocket.ValidateReply(FTPReply reply, String[] expectedReplyCodes)
en EnterpriseDT.Net.Ftp.FTPClient.ChDir(String dir)
en EnterpriseDT.Net.Ftp.FTPConnection.ChangeWorkingDirectory(String directory)
en EnterpriseDT.Net.Ftp.ExFTPConnection.ChangeWorkingDirectory(String directory)
en Quest.Toad.Workflow.Activities.FtpOperationForm.RemoteTreeListControl_DoubleClick(Object sender, EventArgs e)
en System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
en DevExpress.XtraTreeList.TreeList.OnDoubleClick(EventArgs e)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
en DevExpress.XtraTreeList.TreeList.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

This last thing happened when trying to set-up “/export/home/transfer/data” but the error above appear when switching from “/export” to “/export/home” on the right side window in “Operation Options”.

Am I doing something wrong setting-up the FTP/SFTP Automation Task?

Hope anyone can help me out!!!

Thanks in advance,
Oscar

2

Hello Oscar,

I have been able to reproduce and fix the SFTP error here. I went ahead and created CR 81,393 to track this issue.

As for the second issue with plain FTP I am unable to reproduce the problem. Is this a connection to the same machine?

Thanks.

3

Hello, Michael.

Thanks for your super-fast reply. Indeed, I'm trying the FTP/SFTP on the same UNIX server (SunOS).

For SFTP, I got 2 error messages:

First, when setting the "Remote Directory" option in the FTP Activity properties ---See IMAGE #1----. Despite the error, I was able to select the desired Remote Directory.

Second, when setting "Operation Options" in the FTP Activity properties ---See IMAGE #2---. The right side of the "FTP Options" window shows no info about Remote Directory, and there's no chance to type-in or select anything.

Then, I tried using FTP.

For FTP, I just got 1 error message:

This error pops-up when setting "Operation Options" in the FTP Activity properties ---See IMAGE #3---. In this case, the right side of the "FTP Options" window shows the Remote Directory folders correctly. But, when going deep into the tree, the error message jumps, after the 2nd-level of depht. In other words, Root Directory (/) is shown OK, double-click in "/export" also OK ---See IMAGE #4---. Then, after double-click in "/export/home/" I got the error.

As a matter of fact, I was doing some tests in another folders/directories, and in none of them I was able to get deeper into the tree after the 1st-level of the directory structure. Same error showed up every time I was trying to get into "/whatever-directory/whatever-directory......". Please, try to get deeper and deeper into the Remote Host Directory Structure and maybe you can get the same error.

Please, excuse me if I'm not able to explain myself clear. I attached some images for reference. If you need any additional info, please just let me know.

Forgot to mention, but I'm using TDA v2.7

Thanks in advance!
Oscar.

Message was edited by: Oscar Gonzalez

TOAD4.jpeg
TOAD4.jpeg794×529 62.7 KB

4

Hello, Michael.

Thanks for your super-fast reply. Indeed, I'm trying the FTP/SFTP on the same UNIX server (SunOS).

For SFTP, I got 2 error messages:

First, when setting the "Remote Directory" option in the FTP Activity properties ---See IMAGE #1----. Despite the error, I was able to select the desired Remote Directory.

Second, when setting "Operation Options" in the FTP Activity properties ---See IMAGE #2---. The right side of the "FTP Options" window shows no info about Remote Directory, and there's no chance to type-in or select anything.

Then, I tried using FTP.

For FTP, I just got 1 error message:

This error pops-up when setting "Operation Options" in the FTP Activity properties ---See IMAGE #3---. In this case, the right side of the "FTP Options" window shows the Remote Directory folders correctly. But, when going deep into the tree, the error message jumps, after the 2nd-level of depht. In other words, Root Directory (/) is shown OK, double-click in "/export" also OK ---See IMAGE #4---. Then, after double-click in "/export/home/" I got the error.

As a matter of fact, I was doing some tests in another folders/directories, and in none of them I was able to get deeper into the tree after the 1st-level of the directory structure. Same error showed up every time I was trying to get into "/whatever-directory/whatever-directory......". Please, try to get deeper and deeper into the Remote Host Directory Structure and maybe you can get the same error.

Please, excuse me if I'm not able to explain myself clear. I attached some images for reference. If you need any additional info, please just let me know.

Forgot to mention, but I'm using TDA v2.7

Thanks in advance!
Oscar.

Message was edited by: Oscar Gonzalez

TOAD3.jpeg
TOAD3.jpeg794×529 91.8 KB

5

Hello, Michael.

Thanks for your super-fast reply. Indeed, I'm trying the FTP/SFTP on the same UNIX server (SunOS).

For SFTP, I got 2 error messages:

First, when setting the "Remote Directory" option in the FTP Activity properties ---See IMAGE #1----. Despite the error, I was able to select the desired Remote Directory.

Second, when setting "Operation Options" in the FTP Activity properties ---See IMAGE #2---. The right side of the "FTP Options" window shows no info about Remote Directory, and there's no chance to type-in or select anything.

Then, I tried using FTP.

For FTP, I just got 1 error message:

This error pops-up when setting "Operation Options" in the FTP Activity properties ---See IMAGE #3---. In this case, the right side of the "FTP Options" window shows the Remote Directory folders correctly. But, when going deep into the tree, the error message jumps, after the 2nd-level of depht. In other words, Root Directory (/) is shown OK, double-click in "/export" also OK ---See IMAGE #4---. Then, after double-click in "/export/home/" I got the error.

As a matter of fact, I was doing some tests in another folders/directories, and in none of them I was able to get deeper into the tree after the 1st-level of the directory structure. Same error showed up every time I was trying to get into "/whatever-directory/whatever-directory......". Please, try to get deeper and deeper into the Remote Host Directory Structure and maybe you can get the same error.

Please, excuse me if I'm not able to explain myself clear. I attached some images for reference. If you need any additional info, please just let me know.

Forgot to mention, but I'm using TDA v2.7

Thanks in advance!
Oscar.

Message was edited by: Oscar Gonzalez

TOAD2.jpeg
TOAD2.jpeg794×529 50.6 KB

6

Hello, Michael.

Thanks for your super-fast reply. Indeed, I’m trying the FTP/SFTP on the same UNIX server (SunOS).

For SFTP, I got 2 error messages:

First, when setting the “Remote Directory” option in the FTP Activity properties —See IMAGE #1----. Despite the error, I was able to select the desired Remote Directory.

Second, when setting “Operation Options” in the FTP Activity properties —See IMAGE #2—. The right side of the “FTP Options” window shows no info about Remote Directory, and there’s no chance to type-in or select anything.

Then, I tried using FTP.

For FTP, I just got 1 error message:

This error pops-up when setting “Operation Options” in the FTP Activity properties —See IMAGE #3—. In this case, the right side of the “FTP Options” window shows the Remote Directory folders correctly. But, when going deep into the tree, the error message jumps, after the 2nd-level of depht. In other words, Root Directory (/) is shown OK, double-click in “/export” also OK —See IMAGE #4—. Then, after double-click in “/export/home/” I got the error.

As a matter of fact, I was doing some tests in another folders/directories, and in none of them I was able to get deeper into the tree after the 1st-level of the directory structure. Same error showed up every time I was trying to get into “/whatever-directory/whatever-directory…”. Please, try to get deeper and deeper into the Remote Host Directory Structure and maybe you can get the same error.

Please, excuse me if I’m not able to explain myself clear. I attached some images for reference. If you need any additional info, please just let me know.

Forgot to mention, but I’m using TDA v2.7

Thanks in advance!
Oscar.

Message was edited by: Oscar Gonzalez
TOAD1.jpeg

7

Hello Oscar,

Thank you for the very detailed explanation. I’ve reproduced the issues and will be fixing all issues in the same CR.

Thanks again.

8

You’re welcome, man!
I’m glad to be helpful :smiley:

Thanks to you, Debbie and all QUEST’s team for the great job you’re doing improving this wonderful tool, TDA.

Do you know, by any chance, if this CR will make it for tne next update scheduled for the next week (according to Debbie)???

Best regards,
Oscar.

9

Hello Oscar,

We are all very happy to hear that you enjoy using the product. :slight_smile:

The CR has in fact been fixed and will be included in the upcoming beta.

Thanks again for all your help in resolving this issue.

10

Great news!

Just few more days… Thanks again!

Best regards,
Oscar