Page 2 of 2

Re: SFTPOpen Error

Posted: Fri Nov 21, 2014 5:04 pm
by tjblow
I have deselected Use intermediate file during copy...." in "Copy Options" TAB. Then had a new group of files submitted and the results were still SFTPOpen Error. When I deselected in same value in the Second move under BestSync, the file transferred successfully? Stay tuned for more updates.

Re: SFTPOpen Error

Posted: Tue Nov 25, 2014 5:06 pm
by tjblow
Here is my lastest update.
Attached is the log file of a transfer that failed using preview. two folders with files.
All files got the SFTP Open error.
After running this process by Preview, unsuccessfully, I ran a manual SFTP process using WINSCP program, and successfully transferred the files. Then when the job ran automatically it ran successfully. Something is going on with the CHIKALAT software being used for the SFTP process. Up until about a month ago we had NO issues like this with this product. But as of now this is causing us a great deal of pain in moving data files from one environment to another. We use this process 24 hours a day.
Would really appreciate some support here. We have done what has been asked of us to do to fix this issue and are taking into the fact that the Posting here and replies are 24 hours in response.
See attached for preview log file.

Re: SFTPOpen Error

Posted: Tue Nov 25, 2014 5:11 pm
by tjblow
Connected to the SFTP server.
>[1]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/1PGC0112.xml
>[2]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/CS.1PGC0112.png
>[3]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/CS.1PGC0112_CB.png
>[4]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/CS.1PGC0112_CB_D.png
>[5]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/CS.1pgc0112_U.png
>[6]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1PGC0112_CB_D_XXL.png
>[7]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1pgc0112_U_XXL.png
>[8]Upload /cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1PGC0112_XXL.png
[6]
[6] OpenFile:
[6] sftpOpenFile:
[6] remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1PGC0112_CB_D_XXL.png
[6] access: writeOnly
[6] createDisposition: createTruncate
[6] v3Flags: 0x1a
[6] Sent FXP_OPEN
[6] StatusResponseFromServer:
[6] Request: FXP_OPEN
[6] InformationReceivedFromServer:
[6] StatusCode: 2
[6] StatusMessage: No such file
[6] --InformationReceivedFromServer
[6] --StatusResponseFromServer
[6] retryFilepath: ./cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1PGC0112_CB_D_XXL.png
[6] remotePath: ./cygdrive/d/DA_Txfer/CURE/1PGC0112/WEB.1PGC0112_CB_D_XXL.png
[6] access: writeOnly
[6] createDisposition: createTruncate
[6] v3Flags: 0x1a
[6] Sent FXP_OPEN
[6] StatusResponseFromServer:
[6] Request: FXP_OPEN
[6] InformationReceivedFromServer:
[6] StatusCode: 2
[6] StatusMessage: No such file
[6] --InformationReceivedFromServer
[6] --StatusResponseFromServer
[6] --sftpOpenFile
[6] Failed.
[6] --OpenFile
[6]--ChilkatLog
[6]
[8]

Re: SFTPOpen Error

Posted: Fri Dec 19, 2014 4:28 pm
by tjblow
OK, still fighting this SFTPOpen error message, but it seems to have changed. I have unchecked the use intermediate file and still not 100% success.
I am using SFTP to connect from a 2008 server to a 2012 server over a VPN.
My log file looks like this
,Ver9.1.1.2
Friday, December 19, 2014 09:44:24 [==>Success:0 Failed:6 Completed Size:0]

D:\TestAssets\ ==> sftp:///cygdrive/d/DA_Txfer/CURE/
Action,File,Time,Size,Result
1==>2,\1PGC9626\1PGC9626.xml, 12/19/2014 03:38:53,5266,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9626/1PGC9626.xml
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFromServer:
1==>2,\1PGC9626\1PGC9626_1470_1.jpg, 12/19/2014 03:38:42,532851,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9626/1PGC9626_1470_1.jpg
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFrom
1==>2,\1PGC9627\1PGC9627.xml, 12/18/2014 19:40:02,3925,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9627/1PGC9627.xml
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFromServer:
1==>2,\1PGC9629\1PGC9629.xml, 12/18/2014 19:50:45,5006,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9629/1PGC9629.xml
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFromServer:
1==>2,\1PGC9657\1PGC9657.xml, 12/18/2014 20:19:22,4612,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9657/1PGC9657.xml
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFromServer:
1==>2,\1PGC9678\1PGC9678.xml, 12/18/2014 20:49:19,5635,SFTP Error:
OpenFile:
sftpOpenFile:
remotePath: /cygdrive/d/DA_Txfer/CURE/1PGC9678/1PGC9678.xml
access: writeOnly
createDisposition: createTruncate
v3Flags: 0x1a
Sent FXP_OPEN
StatusResponseFromServer:
Success,0
Failed,6
Completed Size,0

This repeats for most folders in the folder. Once I get this error I must manually transfer the files via the WINSCP program, which is what comes up when I select the "Explore Folder 2" button.
I have checked on Folder2 and the permissions via the WINSCP program show as rwxrwxrwx on the folder. In Windows security panel for the folder it is accessible by EVERYONE and with FULL CONTROL. I can not determine why the transfer is successful for some folders/files and not others.

Re: SFTPOpen Error

Posted: Sat Dec 20, 2014 4:27 am
by RiseFly
Sorry for the problem, we use ChilKat SFTP component to implement the SFTP sync feature.
We are contacting ChilKat to see if they have any solution of this problem.

Re: SFTPOpen Error

Posted: Wed Dec 24, 2014 4:51 pm
by tjblow
Any Update on this issue?. I am having multiple issues daily with this problem and it is really creating a problem for our production process.
Any resolution or work around would be appreciated.

Re: SFTPOpen Error

Posted: Fri Dec 26, 2014 5:00 pm
by tjblow
Jianping Zhou,
Thank you for your reply. This is only occurring on 1 single task. I have other tasks using SFTP and even going to the same server and parent folder without this issue. What information can I forward to have Risefly assist me on this issue.?