Fetch Softworks

Files not downloading (14 posts)

• Started 12 years ago by Jason Willis
• Latest reply 12 years ago from Jim Matthews

• Jason Willis Member

  I have a apple script that opens fetch and downloads seven files. It has been working for 5 months without any issue and within the last two weeks fetch will download all of the files except the one? I have been banging my head on the table trying to figure this one out any help would be greatly appreciated!!

  tell application "Finder"
  activate
  open application file "Fetch.app" of folder "Applications" of startup disk
  end tell
  tell application "Fetch"
  activate
  make new transfer window at beginning with properties {hostname:"My ip address", username:"myname", password:"password", authentication:SFTP, encrypt:true}
  download remote file "wes_attendance_absent.csv"
  download remote file "aes_attendance_absent.csv"
  download remote file "jes_attendance_absent.csv"
  download remote file "mes_attendance_absent.csv"
  download remote file "wes_attendance_absent.csv"
  download remote file "mis_attendance_absent.csv"
  download remote file "mjh_attendance_absent.csv"
  download remote file "mpc_attendance_absent.csv"
  download remote file "wes_attendance_absent.csv"
  quit application "Fetch"
  end tell

  This file wes_attendance_absent.csv will not download when I run the app from cron, but when I manually run the file it works????

  Please help!

  Edited 12 years ago #

• Jim Matthews Administrator

  Could you change the script to not quit Fetch? Then have cron run it, and afterwards choose "Fetch Transcript" from the Window menu and post the contents. That may offer clues to what is happening with wes_attendance_absent.csv.

  Thanks,

  Jim Matthews
  Fetch Softworks

  Posted 12 years ago #

• Jason Willis Member

  pdate check skipped at 3/6/12 9:37 AM (next check after 3/12/12 9:35 PM)
  Connecting to username@ip address port 22 (3/6/12 9:37 AM)
  SSH2_FXP_INIT 3
  SSH2_FXP_REALPATH 1, .
  /
  SSH2_FXP_STAT 2, /
  SSH2_FXP_OPENDIR 3, /
  SSH2_FXP_READDIR 4
  09-22-2011 09:37AM <DIR> ..
  03-06-2012 09:30AM 75 aes_attendance_absent.csv
  03-05-2012 04:31PM 188 aes_lunch_balance.csv
  03-05-2012 08:30PM 1265306 follett_students.csv
  03-06-2012 09:30AM 78 jes_attendance_absent.csv
  03-05-2012 04:30PM 235 jes_lunch_balance.csv
  03-06-2012 09:30AM 198 mes_attendance_absent.csv
  03-05-2012 04:31PM 663 mes_lunch_balance.csv
  03-06-2012 09:31AM 235 mis_attendance_absent.csv
  03-05-2012 04:32PM 1316 mis_lunch_balance.csv
  03-06-2012 09:31AM 314 mjh_attendance_absent.csv
  03-05-2012 04:33PM 969 mjh_lunch_balance.csv
  03-06-2012 08:32AM 2 mpc_attendance_absent.csv
  03-05-2012 08:31PM 767804 nurse.csv
  03-05-2012 08:33PM 419360 schoolmessenger_students.csv
  12-09-2011 02:34PM 456717 teacherease_bus_export.csv
  03-05-2012 08:32PM 1232373 versatrans.csv
  03-06-2012 08:32AM 2 wes_attendance_absent.csv
  03-05-2012 04:34PM 43 wes_lunch_balance.csv
  SSH2_FXP_READDIR 5
  SSH2_FXP_CLOSE 6
  SSH2_FX_OK 6
  SSH2_FXP_OPEN 7, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 8
  SSH2_FXP_CLOSE 11
  SSH2_FX_OK 11
  Successful download of wes_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 12, /aes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 13
  SSH2_FXP_CLOSE 16
  SSH2_FX_OK 16
  Successful download of aes_attendance_absent.csv as text file (75 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 17, /jes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 18
  SSH2_FXP_CLOSE 21
  SSH2_FX_OK 21
  Successful download of jes_attendance_absent.csv as text file (78 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 22, /mes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 23
  SSH2_FXP_CLOSE 26
  SSH2_FX_OK 26
  Successful download of mes_attendance_absent.csv as text file (198 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 27, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 28
  SSH2_FXP_CLOSE 31
  SSH2_FX_OK 31
  Successful download of wes_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 32, /mis_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 33
  SSH2_FXP_CLOSE 36
  SSH2_FX_OK 36
  Successful download of mis_attendance_absent.csv as text file (235 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 37, /mjh_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 38
  SSH2_FXP_CLOSE 41
  SSH2_FX_OK 41
  Successful download of mjh_attendance_absent.csv as text file (314 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 42, /mpc_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 43
  SSH2_FXP_CLOSE 46
  SSH2_FX_OK 46
  Successful download of mpc_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_OPEN 47, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 48
  SSH2_FXP_CLOSE 51
  SSH2_FX_OK 51
  Successful download of wes_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:37 AM
  SSH2_FXP_REALPATH 14, .
  /
  SSH2_FXP_REALPATH 13, .
  /
  SSH2_FXP_REALPATH 52, .

  This is what I get when the cron runs. Here is what I get when I manually run the file:

  Fetch 5.7.1 (5H465) Intel (Web Store) running on Mac OS X 10.6.8 (10K549) Intel English
  StuffIt Engine 0x820, StuffIt SDK Version 10.1.1b1
  Partial serial FETCHED001-L0D8-D511 T
  Connecting to username@ip address port 22 (3/6/12 9:40 AM)
  SSH2_FXP_INIT 3
  SSH2_FXP_REALPATH 1, .
  /
  SSH2_FXP_STAT 2, /
  SSH2_FXP_OPENDIR 3, /
  SSH2_FXP_READDIR 4
  09-22-2011 09:37AM <DIR> ..
  03-06-2012 09:30AM 75 aes_attendance_absent.csv
  03-05-2012 04:31PM 188 aes_lunch_balance.csv
  03-05-2012 08:30PM 1265306 follett_students.csv
  03-06-2012 09:30AM 78 jes_attendance_absent.csv
  03-05-2012 04:30PM 235 jes_lunch_balance.csv
  03-06-2012 09:30AM 198 mes_attendance_absent.csv
  03-05-2012 04:31PM 663 mes_lunch_balance.csv
  03-06-2012 09:31AM 235 mis_attendance_absent.csv
  03-05-2012 04:32PM 1316 mis_lunch_balance.csv
  03-06-2012 09:31AM 314 mjh_attendance_absent.csv
  03-05-2012 04:33PM 969 mjh_lunch_balance.csv
  03-06-2012 09:32AM 80 mpc_attendance_absent.csv
  03-05-2012 08:31PM 767804 nurse.csv
  03-05-2012 08:33PM 419360 schoolmessenger_students.csv
  12-09-2011 02:34PM 456717 teacherease_bus_export.csv
  03-05-2012 08:32PM 1232373 versatrans.csv
  03-06-2012 09:32AM 99 wes_attendance_absent.csv
  03-05-2012 04:34PM 43 wes_lunch_balance.csv
  SSH2_FXP_READDIR 5
  SSH2_FXP_CLOSE 6
  SSH2_FX_OK 6
  SSH2_FXP_OPEN 7, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 8
  SSH2_FXP_CLOSE 11
  SSH2_FX_OK 11
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 12, /aes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 13
  SSH2_FXP_CLOSE 16
  SSH2_FX_OK 16
  Successful download of aes_attendance_absent.csv as text file (75 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 17, /jes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 18
  SSH2_FXP_CLOSE 21
  SSH2_FX_OK 21
  Successful download of jes_attendance_absent.csv as text file (78 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 22, /mes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 23
  SSH2_FXP_CLOSE 26
  SSH2_FX_OK 26
  Successful download of mes_attendance_absent.csv as text file (198 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 27, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 28
  SSH2_FXP_CLOSE 31
  SSH2_FX_OK 31
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 32, /mis_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 33
  SSH2_FXP_CLOSE 36
  SSH2_FX_OK 36
  Successful download of mis_attendance_absent.csv as text file (235 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 37, /mjh_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 38
  SSH2_FXP_CLOSE 41
  SSH2_FX_OK 41
  Successful download of mjh_attendance_absent.csv as text file (314 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 42, /mpc_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 43
  SSH2_FXP_CLOSE 46
  SSH2_FX_OK 46
  Successful download of mpc_attendance_absent.csv as text file (80 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM
  SSH2_FXP_OPEN 47, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 48
  SSH2_FXP_CLOSE 51
  SSH2_FX_OK 51
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 9:41 AM

  Notice the file size difference of the we_attendance_absent. Why is this?

  Posted 12 years ago #

• Jim Matthews Administrator

  That's very strange! I see a size difference with mpc_attendance_absent.csv as well.

  Something else to try:

  1) Enable the Debug menu by holding down Command-Option-Shift-Control and typing the letter D
  2) From the Debug menu, choose Logging > SFTP log
  3) Leave Fetch running and let cron run the job
  4) Collect the contents of Fetch Transcript; there should be some additional information.

  Also, it might simplify things a bit to have the script download each file only once.

  Thanks,

  Jim Matthews
  Fetch Softworks

  Posted 12 years ago #

• Jason Willis Member

  I do have a separate script to download the wes_attendance_absent.csv file. It still is not working through cron.

  Posted 12 years ago #

• Jason Willis Member

  When I invoke the cron to run this is what I get:

  Fetch 5.7.1 (5H465) Intel (Web Store) running on Mac OS X 10.6.8 (10K549) Intel English
  StuffIt Engine 0x820, StuffIt SDK Version 10.1.1b1
  Partial serial FETCHED001-L0D8-D511 T
  Update check skipped at 3/6/12 10:19 AM (next check after 3/12/12 9:35 PM)
  Connecting to min201@69.36.33.101 port 22 (3/6/12 10:20 AM)
  SSH2_FXP_INIT 3
  SFTP server version: 3
  SSH2_FXP_REALPATH 1, .
  /
  SSH2_FXP_STAT 2, /
  SSH2_FXP_ATTRS 2
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x41ff
  SSH2_FXP_OPENDIR 3, /
  SSH2_FXP_HANDLE 3
  SSH2_FXP_READDIR 4
  09-22-2011 09:37AM <DIR> ..
  filename: ..
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x41ff
  03-06-2012 09:30AM 75 aes_attendance_absent.csv
  filename: aes_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 75
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:30 AM 3/6/12 9:30 AM
  03-05-2012 04:31PM 188 aes_lunch_balance.csv
  filename: aes_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 188
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:31 PM 3/5/12 4:31 PM
  03-05-2012 08:30PM 1265306 follett_students.csv
  filename: follett_students.csv
  SSH2_FILEXFER_ATTR_SIZE 1265306
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 9:57 PM 3/5/12 8:30 PM
  03-06-2012 09:30AM 78 jes_attendance_absent.csv
  filename: jes_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 78
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:30 AM 3/6/12 9:30 AM
  03-05-2012 04:30PM 235 jes_lunch_balance.csv
  filename: jes_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 235
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:30 PM 3/5/12 4:30 PM
  03-06-2012 09:30AM 198 mes_attendance_absent.csv
  filename: mes_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 198
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:30 AM 3/6/12 9:30 AM
  03-05-2012 04:31PM 663 mes_lunch_balance.csv
  filename: mes_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 663
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:31 PM 3/5/12 4:31 PM
  03-06-2012 09:31AM 235 mis_attendance_absent.csv
  filename: mis_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 235
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:31 AM 3/6/12 9:31 AM
  03-05-2012 04:32PM 1316 mis_lunch_balance.csv
  filename: mis_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 1316
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:32 PM 3/5/12 4:32 PM
  03-06-2012 09:31AM 314 mjh_attendance_absent.csv
  filename: mjh_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 314
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:31 AM 3/6/12 9:31 AM
  03-05-2012 04:33PM 969 mjh_lunch_balance.csv
  filename: mjh_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 969
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:33 PM 3/5/12 4:33 PM
  03-06-2012 09:32AM 80 mpc_attendance_absent.csv
  filename: mpc_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 80
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:32 AM 3/6/12 9:32 AM
  03-05-2012 08:31PM 767804 nurse.csv
  filename: nurse.csv
  SSH2_FILEXFER_ATTR_SIZE 767804
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 9:57 PM 3/5/12 8:31 PM
  03-05-2012 08:33PM 419360 schoolmessenger_students.csv
  filename: schoolmessenger_students.csv
  SSH2_FILEXFER_ATTR_SIZE 419360
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 10:03 PM 3/5/12 8:33 PM
  12-09-2011 02:34PM 456717 teacherease_bus_export.csv
  filename: teacherease_bus_export.csv
  SSH2_FILEXFER_ATTR_SIZE 456717
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 12/9/11 2:34 PM 12/9/11 2:34 PM
  03-05-2012 08:32PM 1232373 versatrans.csv
  filename: versatrans.csv
  SSH2_FILEXFER_ATTR_SIZE 1232373
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 9:57 PM 3/5/12 8:32 PM
  03-06-2012 09:32AM 99 wes_attendance_absent.csv
  filename: wes_attendance_absent.csv
  SSH2_FILEXFER_ATTR_SIZE 99
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:32 AM 3/6/12 9:32 AM
  03-05-2012 04:34PM 43 wes_lunch_balance.csv
  filename: wes_lunch_balance.csv
  SSH2_FILEXFER_ATTR_SIZE 43
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/5/12 4:34 PM 3/5/12 4:34 PM
  SSH2_FXP_READDIR 5
  SSH2_FXP_CLOSE 6
  SSH2_FX_OK 6
  SSH2_FXP_OPEN 7, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 7
  SSH2_FXP_FSTAT 8
  SSH2_FXP_ATTRS 8
  SSH2_FILEXFER_ATTR_SIZE 99
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 99
  SSH2_FXP_READ 9, 0, 32768
  SSH2_FXP_DATA 9, 0, 99
  SSH2_FXP_READ 10, 32768, 32768
  SSH2_FX_EOF 10
  SSH2_FXP_CLOSE 11
  SSH2_FX_OK 11
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 12, /aes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 12
  SSH2_FXP_FSTAT 13
  SSH2_FXP_ATTRS 13
  SSH2_FILEXFER_ATTR_SIZE 75
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 75
  SSH2_FXP_READ 14, 0, 32768
  SSH2_FXP_DATA 14, 0, 75
  SSH2_FXP_READ 15, 32768, 32768
  SSH2_FX_EOF 15
  SSH2_FXP_CLOSE 16
  SSH2_FX_OK 16
  Successful download of aes_attendance_absent.csv as text file (75 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 17, /jes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 17
  SSH2_FXP_FSTAT 18
  SSH2_FXP_ATTRS 18
  SSH2_FILEXFER_ATTR_SIZE 78
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 78
  SSH2_FXP_READ 19, 0, 32768
  SSH2_FXP_DATA 19, 0, 78
  SSH2_FXP_READ 20, 32768, 32768
  SSH2_FX_EOF 20
  SSH2_FXP_CLOSE 21
  SSH2_FX_OK 21
  Successful download of jes_attendance_absent.csv as text file (78 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 22, /mes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 22
  SSH2_FXP_FSTAT 23
  SSH2_FXP_ATTRS 23
  SSH2_FILEXFER_ATTR_SIZE 198
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 198
  SSH2_FXP_READ 24, 0, 32768
  SSH2_FXP_DATA 24, 0, 198
  SSH2_FXP_READ 25, 32768, 32768
  SSH2_FX_EOF 25
  SSH2_FXP_CLOSE 26
  SSH2_FX_OK 26
  Successful download of mes_attendance_absent.csv as text file (198 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 27, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 27
  SSH2_FXP_FSTAT 28
  SSH2_FXP_ATTRS 28
  SSH2_FILEXFER_ATTR_SIZE 99
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 10:15 AM 3/6/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 99
  SSH2_FXP_READ 29, 0, 32768
  SSH2_FXP_DATA 29, 0, 99
  SSH2_FXP_READ 30, 32768, 32768
  SSH2_FX_EOF 30
  SSH2_FXP_CLOSE 31
  SSH2_FX_OK 31
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 32, /mis_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 32
  SSH2_FXP_FSTAT 33
  SSH2_FXP_ATTRS 33
  SSH2_FILEXFER_ATTR_SIZE 235
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 235
  SSH2_FXP_READ 34, 0, 32768
  SSH2_FXP_DATA 34, 0, 235
  SSH2_FXP_READ 35, 32768, 32768
  SSH2_FX_EOF 35
  SSH2_FXP_CLOSE 36
  SSH2_FX_OK 36
  Successful download of mis_attendance_absent.csv as text file (235 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 37, /mjh_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 37
  SSH2_FXP_FSTAT 38
  SSH2_FXP_ATTRS 38
  SSH2_FILEXFER_ATTR_SIZE 314
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 314
  SSH2_FXP_READ 39, 0, 32768
  SSH2_FXP_DATA 39, 0, 314
  SSH2_FXP_READ 40, 32768, 32768
  SSH2_FX_EOF 40
  SSH2_FXP_CLOSE 41
  SSH2_FX_OK 41
  Successful download of mjh_attendance_absent.csv as text file (314 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 42, /mpc_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 42
  SSH2_FXP_FSTAT 43
  SSH2_FXP_ATTRS 43
  SSH2_FILEXFER_ATTR_SIZE 80
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 9:36 AM 3/6/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 80
  SSH2_FXP_READ 44, 0, 32768
  SSH2_FXP_DATA 44, 0, 80
  SSH2_FXP_READ 45, 32768, 32768
  SSH2_FX_EOF 45
  SSH2_FXP_CLOSE 46
  SSH2_FX_OK 46
  Successful download of mpc_attendance_absent.csv as text file (80 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_OPEN 47, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 47
  SSH2_FXP_FSTAT 48
  SSH2_FXP_ATTRS 48
  SSH2_FILEXFER_ATTR_SIZE 99
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/6/12 10:15 AM 3/6/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 99
  SSH2_FXP_READ 49, 0, 32768
  SSH2_FXP_DATA 49, 0, 99
  SSH2_FXP_READ 50, 32768, 32768
  SSH2_FX_EOF 50
  SSH2_FXP_CLOSE 51
  SSH2_FX_OK 51
  Successful download of wes_attendance_absent.csv as text file (99 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/6/12 10:20 AM
  SSH2_FXP_REALPATH 52, .
  /

  The file gets downloaded correctly. It's only when the machine does it on its own that the file does not get downloaded????

  Posted 12 years ago #

• Jim Matthews Administrator

  Do you mean that the problem only happens when cron launches Fetch?

  Posted 12 years ago #

• Jason Willis Member

  Yes only when cron launches fetch. If I manually run the script it works. But the weird thing is that it was working for a long time?

  Posted 12 years ago #

• Jim Matthews Administrator

  Is it possible that you have two copies of Fetch on your Mac, and that cron is launching a different one? I don't know why a different version wouldn't behave the same way, but it's one possibility to investigate.

  Posted 12 years ago #

• Jason Willis Member

  Emptied the trash, made sure that there is not another instance of Fetch on the server.

  Posted 12 years ago #

• Jason Willis Member

  Here's the info when cron runs the app:

  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:31 AM 3/7/12 8:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 2
  SSH2_FXP_READ 9, 0, 32768
  SSH2_FXP_DATA 9, 0, 2
  SSH2_FXP_READ 10, 32768, 32768
  SSH2_FX_EOF 10
  SSH2_FXP_CLOSE 11
  SSH2_FX_OK 11
  Successful download of wes_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 12, /aes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 12
  SSH2_FXP_FSTAT 13
  SSH2_FXP_ATTRS 13
  SSH2_FILEXFER_ATTR_SIZE 75
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:30 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 75
  SSH2_FXP_READ 14, 0, 32768
  SSH2_FXP_DATA 14, 0, 75
  SSH2_FXP_READ 15, 32768, 32768
  SSH2_FX_EOF 15
  SSH2_FXP_CLOSE 16
  SSH2_FX_OK 16
  Successful download of aes_attendance_absent.csv as text file (75 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 17, /jes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 17
  SSH2_FXP_FSTAT 18
  SSH2_FXP_ATTRS 18
  SSH2_FILEXFER_ATTR_SIZE 229
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:30 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 229
  SSH2_FXP_READ 19, 0, 32768
  SSH2_FXP_DATA 19, 0, 229
  SSH2_FXP_READ 20, 32768, 32768
  SSH2_FX_EOF 20
  SSH2_FXP_CLOSE 21
  SSH2_FX_OK 21
  Successful download of jes_attendance_absent.csv as text file (229 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 22, /mes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 22
  SSH2_FXP_FSTAT 23
  SSH2_FXP_ATTRS 23
  SSH2_FILEXFER_ATTR_SIZE 246
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:30 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 246
  SSH2_FXP_READ 24, 0, 32768
  SSH2_FXP_DATA 24, 0, 246
  SSH2_FXP_READ 25, 32768, 32768
  SSH2_FX_EOF 25
  SSH2_FXP_CLOSE 26
  SSH2_FX_OK 26
  Successful download of mes_attendance_absent.csv as text file (246 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 27, /mis_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 27
  SSH2_FXP_FSTAT 28
  SSH2_FXP_ATTRS 28
  SSH2_FILEXFER_ATTR_SIZE 201
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:31 AM 3/7/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 201
  SSH2_FXP_READ 29, 0, 32768
  SSH2_FXP_DATA 29, 0, 201
  SSH2_FXP_READ 30, 32768, 32768
  SSH2_FX_EOF 30
  SSH2_FXP_CLOSE 31
  SSH2_FX_OK 31
  Successful download of mis_attendance_absent.csv as text file (201 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 32, /mjh_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 32
  SSH2_FXP_FSTAT 33
  SSH2_FXP_ATTRS 33
  SSH2_FILEXFER_ATTR_SIZE 128
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:31 AM 3/7/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 128
  SSH2_FXP_READ 34, 0, 32768
  SSH2_FXP_DATA 34, 0, 128
  SSH2_FXP_READ 35, 32768, 32768
  SSH2_FX_EOF 35
  SSH2_FXP_CLOSE 36
  SSH2_FX_OK 36
  Successful download of mjh_attendance_absent.csv as text file (128 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_OPEN 37, /mpc_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 37
  SSH2_FXP_FSTAT 38
  SSH2_FXP_ATTRS 38
  SSH2_FILEXFER_ATTR_SIZE 2
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 8:50 AM 3/7/12 8:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 2
  SSH2_FXP_READ 39, 0, 32768
  SSH2_FXP_DATA 39, 0, 2
  SSH2_FXP_READ 40, 32768, 32768
  SSH2_FX_EOF 40
  SSH2_FXP_CLOSE 41
  SSH2_FX_OK 41
  Successful download of mpc_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM
  SSH2_FXP_REALPATH 42, .

  Here is when I manually run the app:

  SSH2_FILEXFER_ATTR_SIZE 51
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 51
  SSH2_FXP_READ 9, 0, 32768
  SSH2_FXP_DATA 9, 0, 51
  SSH2_FXP_READ 10, 32768, 32768
  SSH2_FX_EOF 10
  SSH2_FXP_CLOSE 11
  SSH2_FX_OK 11
  Successful download of wes_attendance_absent.csv as text file (51 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 12, /aes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 12
  SSH2_FXP_FSTAT 13
  SSH2_FXP_ATTRS 13
  SSH2_FILEXFER_ATTR_SIZE 75
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 75
  SSH2_FXP_READ 14, 0, 32768
  SSH2_FXP_DATA 14, 0, 75
  SSH2_FXP_READ 15, 32768, 32768
  SSH2_FX_EOF 15
  SSH2_FXP_CLOSE 16
  SSH2_FX_OK 16
  Successful download of aes_attendance_absent.csv as text file (75 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 17, /jes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 17
  SSH2_FXP_FSTAT 18
  SSH2_FXP_ATTRS 18
  SSH2_FILEXFER_ATTR_SIZE 229
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 229
  SSH2_FXP_READ 19, 0, 32768
  SSH2_FXP_DATA 19, 0, 229
  SSH2_FXP_READ 20, 32768, 32768
  SSH2_FX_EOF 20
  SSH2_FXP_CLOSE 21
  SSH2_FX_OK 21
  Successful download of jes_attendance_absent.csv as text file (229 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 22, /mes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 22
  SSH2_FXP_FSTAT 23
  SSH2_FXP_ATTRS 23
  SSH2_FILEXFER_ATTR_SIZE 246
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:30 AM
  SSH2_FXP_ATTRS attr.getsize() == 246
  SSH2_FXP_READ 24, 0, 32768
  SSH2_FXP_DATA 24, 0, 246
  SSH2_FXP_READ 25, 32768, 32768
  SSH2_FX_EOF 25
  SSH2_FXP_CLOSE 26
  SSH2_FX_OK 26
  Successful download of mes_attendance_absent.csv as text file (246 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 27, /mis_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 27
  SSH2_FXP_FSTAT 28
  SSH2_FXP_ATTRS 28
  SSH2_FILEXFER_ATTR_SIZE 201
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 201
  SSH2_FXP_READ 29, 0, 32768
  SSH2_FXP_DATA 29, 0, 201
  SSH2_FXP_READ 30, 32768, 32768
  SSH2_FX_EOF 30
  SSH2_FXP_CLOSE 31
  SSH2_FX_OK 31
  Successful download of mis_attendance_absent.csv as text file (201 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 32, /mjh_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 32
  SSH2_FXP_FSTAT 33
  SSH2_FXP_ATTRS 33
  SSH2_FILEXFER_ATTR_SIZE 128
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:31 AM
  SSH2_FXP_ATTRS attr.getsize() == 128
  SSH2_FXP_READ 34, 0, 32768
  SSH2_FXP_DATA 34, 0, 128
  SSH2_FXP_READ 35, 32768, 32768
  SSH2_FX_EOF 35
  SSH2_FXP_CLOSE 36
  SSH2_FX_OK 36
  Successful download of mjh_attendance_absent.csv as text file (128 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM
  SSH2_FXP_OPEN 37, /mpc_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_HANDLE 37
  SSH2_FXP_FSTAT 38
  SSH2_FXP_ATTRS 38
  SSH2_FILEXFER_ATTR_SIZE 156
  SSH2_FILEXFER_ATTR_PERMISSIONS 0x81ff
  SSH2_FILEXFER_ATTR_ACMODTIME 3/7/12 9:32 AM 3/7/12 9:32 AM
  SSH2_FXP_ATTRS attr.getsize() == 156
  SSH2_FXP_READ 39, 0, 32768
  SSH2_FXP_DATA 39, 0, 156
  SSH2_FXP_READ 40, 32768, 32768
  SSH2_FX_EOF 40
  SSH2_FXP_CLOSE 41
  SSH2_FX_OK 41
  Successful download of mpc_attendance_absent.csv as text file (156 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM

  Have you been able to think of anything?

  Posted 12 years ago #

• Jim Matthews Administrator

  In the cron case, the server said that the wes_attendance_absent.csv file was 2 bytes long, and last modified at 3/7/12 8:32 AM. When you run the script manually the server said it was 51 bytes long, and last modified 3/7/12 9:32 AM. So it appears that the file is being modified between the script runs, and perhaps that explains the difference.

  Is it possible that the script, or some other process, changes the length of some of these files?

  Jim Matthews
  Fetch Softworks

  Posted 12 years ago #

• Jason Willis Member

  They are being exported from our student information system,

  Its says: Successful download of wes_attendance_absent.csv as text file (2 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:37 AM

  But when I manually run it:
  SSH2_FXP_REALPATH 7, /wes_attendance_absent.csv
  /wes_attendance_absent.csv
  SSH2_FXP_STAT 8, /wes_attendance_absent.csv
  SSH2_FXP_OPEN 9, /wes_attendance_absent.csv [ SSH2_FXF_READ ]
  SSH2_FXP_FSTAT 10
  SSH2_FXP_CLOSE 13
  SSH2_FX_OK 13
  Successful download of wes_attendance_absent.csv as text file (51 bytes, 0 bytes/sec, 0:00 elapsed) completed at 3/7/12 9:38 AM

  Posted 12 years ago #

• Jim Matthews Administrator

  Fetch is doing the same thing in each case, but the file that it finds on the server is different, both in size and when it was last modified. Is the timing of the cron script related to the timing of the export from the student information system? It seems like there is some interaction there.

  Posted 12 years ago #