hiteksoftware.com

[jtatum]

Hi,

I'm trying to rename an sftp downloaded file using the "append to filename" feature but am not having much luck. I created a new sftp task and set the parameters to the following:

FTP Option: get files
Append to filename: Append Date/Time
Transfer type: auto
Delete source file after transfer option checked

When I run the task it fails and the log says "failed to upload". Below is the complete log. Why does it even try to upload anything? How can I get this to work? Any help would be much appreciated. Note that if I don't have the 'Append to filename' option set it works fine and the file is downloaded successfully. I am using Automize Enterprise 8.05.

Aug 1, 2008 10:21:08 AM
SFTP-J - Restat - Manual Run
Aug 1, 2008 10:21:08 AM
SFTP-J - Restat - Start Instance = 37
Aug 1, 2008 10:21:08 AM
Connecting to SSH2/SFTP-j Profile : Restat
Aug 1, 2008 10:21:14 AM
SFTP - Restat - Connected to server: secureftp.restat.com
Aug 1, 2008 10:21:14 AM
Default Directory: /Home/dataapcinet
Aug 1, 2008 10:21:14 AM
Verifying permissions of: /Home/dataapcinet
Aug 1, 2008 10:21:14 AM
Directory: /Home/dataapcinet , permissions: 711
Aug 1, 2008 10:21:14 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:15 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:15 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:16 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:16 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:16 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:16 AM
SFTP - Restat - Working directory changed to : /Home/dataapcinet
Aug 1, 2008 10:21:17 AM
Failed to upload: /Home/dataapcinet/hewitt_phcy08011021.txt
Aug 1, 2008 10:21:17 AM
FTP session summary:
Aug 1, 2008 10:21:17 AM
Total number of files = 1
Aug 1, 2008 10:21:17 AM
Total number of local files backed up = 0
Aug 1, 2008 10:21:17 AM
Total number of local files failed to back up = 0
Aug 1, 2008 10:21:17 AM
Total number of remote files backed up = 0
Aug 1, 2008 10:21:17 AM
Total number of remote files failed to back up = 0
Aug 1, 2008 10:21:17 AM
Total number of files moved to final staging folder = 0
Aug 1, 2008 10:21:17 AM
Total number of files failed to move to final staging folder = 0
Aug 1, 2008 10:21:17 AM
Total number of source files deleted = 0
Aug 1, 2008 10:21:17 AM
Total source files failed to delete = 0
Aug 1, 2008 10:21:17 AM
Total number of temporary files failed to rename = 0
Aug 1, 2008 10:21:17 AM
Total number of files in folders meeting folder name criteria = 1
Aug 1, 2008 10:21:17 AM
Total number of files meeting filename criteria = 1
Aug 1, 2008 10:21:17 AM
Total number of files meeting filename criteria and date modified criteria = 1
Aug 1, 2008 10:21:17 AM
Total number of files meeting filename criteria, date modified criteria, and new modified files criteria = 1
Aug 1, 2008 10:21:17 AM
Total number of failed transfers = 1
Aug 1, 2008 10:21:17 AM
Total number of files downloaded = 0
Aug 1, 2008 10:21:17 AM
SFTP - Restat - Disconnected from server: secureftp.restat.com
Aug 1, 2008 10:21:17 AM
SFTP-J - Restat - End Instance = 37 , Exit Code = 1 , Runtime (ms) = 9157

[melvin]

do the following:
run task once with append to filename option selected.
Then disable this option and run task again.

Then send us your support files immediately:
help menu
email support generator
Task to analyze field - select your task title
click on ZIP button
email us the support.zip file.

[jtatum]

I just emailed the support files. I do have a workaround for this for now. I created a copy file task and am just renaming the files that way after downloading them. I still would like to know why the 'Append To Filename' option isn't working on the download though. It seems that would be the cleanest solution for me as it would only require 1 task.