|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Hey there.
Every day my log is showing "ERROR: Remote file size verifiсation failed: Remote file size is not equal to the local one". Yet, when I look at the local and remote ZIP file sizes, they are the same. There is nothing wrong with the remote file (SQL restore works fine). Does anyone else have this problem? Is there a way to fix it, or a way to disable file size verification?
Thanks,
-Ed
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Please enable FTP session log (FTP Settings -> Write FTP session to log), repeat your action and send log to us.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Here are the relevant FTP excerpts from my log.
Not sure why the QUIT command is not understand;
maybe that's why the size verification is failing.
FYI: The receiving FTP server is Serv-U version 2.5.
Thanks for your help. Looking forward to your reply.
Happy holidays,
-Ed
12/25/2009 11:12:14 AM Uploading C:\Backup\SPD\SPD200912251112.zip to ftp://...:21/
12/25/2009 11:12:14 AM > USER ...
12/25/2009 11:12:14 AM < 331 User name okay, need password.
12/25/2009 11:12:14 AM > PASS *****
12/25/2009 11:12:14 AM < 230 User logged in, proceed.
12/25/2009 11:12:14 AM > TYPE I
12/25/2009 11:12:14 AM < 200 Type set to I.
12/25/2009 11:12:14 AM > PORT ...
12/25/2009 11:12:14 AM < 200 PORT Command successful.
12/25/2009 11:12:14 AM > STOR SPD200912251112.zip
12/25/2009 11:12:14 AM Data connection established with ...:20 on 12/25/2009 @ 11:12:14 AM
12/25/2009 11:12:14 AM < 150 Opening BINARY mode data connection for spd200912251112.zip.
12/25/2009 11:12:17 AM < 226 Transfer complete.
12/25/2009 11:12:17 AM > QUIT
12/25/2009 11:12:17 AM < 500 '�QUIT': command not understood.
12/25/2009 11:12:17 AM Disconnected from ...:21 on 12/25/2009 @ 11:12:17 AM
12/25/2009 11:12:17 AM Upload of C:\Backup\SPD\SPD200912251112.zip completed
12/25/2009 11:12:17 AM > USER ...
12/25/2009 11:12:17 AM < 331 User name okay, need password.
12/25/2009 11:12:17 AM > PASS *****
12/25/2009 11:12:17 AM < 230 User logged in, proceed.
12/25/2009 11:12:17 AM > TYPE A
12/25/2009 11:12:17 AM < 200 Type set to A.
12/25/2009 11:12:17 AM > PORT ...
12/25/2009 11:12:17 AM < 200 PORT Command successful.
12/25/2009 11:12:17 AM > LIST
12/25/2009 11:12:17 AM Data connection established with ...:20 on 12/25/2009 @ 11:12:17 AM
12/25/2009 11:12:17 AM < 150 Opening ASCII mode data connection for /bin/ls.
12/25/2009 11:12:18 AM < 226 Transfer complete.
12/25/2009 11:12:18 AM > QUIT
12/25/2009 11:12:18 AM < 500 '�QUIT': command not understood.
12/25/2009 11:12:18 AM Disconnected from ...:21 on 12/25/2009 @ 11:12:18 AM
12/25/2009 11:12:18 AM ERROR: Remote file size verifiсation failed: Remote file size is not equal to the local one
12/25/2009 11:12:18 AM Cleaning ftp://...:21/
12/25/2009 11:12:18 AM > USER ...
12/25/2009 11:12:18 AM < 331 User name okay, need password.
12/25/2009 11:12:18 AM > PASS *****
12/25/2009 11:12:18 AM < 230 User logged in, proceed.
12/25/2009 11:12:18 AM > TYPE A
12/25/2009 11:12:18 AM < 200 Type set to A.
12/25/2009 11:12:18 AM > PORT ...
12/25/2009 11:12:18 AM < 200 PORT Command successful.
12/25/2009 11:12:18 AM > LIST
12/25/2009 11:12:18 AM Data connection established with ...:20 on 12/25/2009 @ 11:12:18 AM
12/25/2009 11:12:18 AM < 150 Opening ASCII mode data connection for /bin/ls.
12/25/2009 11:12:18 AM < 226 Transfer complete.
12/25/2009 11:12:18 AM > QUIT
12/25/2009 11:12:18 AM < 500 '�QUIT': command not understood.
12/25/2009 11:12:18 AM Disconnected from ...:21 on 12/25/2009 @ 11:12:18 AM
12/25/2009 11:12:19 AM Confirmation e-mail (Failure) has been successfully sent
12/25/2009 11:12:19 AM ERROR: Job finished (With Errors)
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/7/2010
Posts: 1
Location: Netherlands
|
Same problem over here! Code:DETAILED LOG:
4/7/2010 4:00:05 AM Creating backup of *** to D:\backup
4/7/2010 4:01:13 AM Backup of *** completed
4/7/2010 4:01:13 AM Zipping D:\backup\*** to D:\backup\***
4/7/2010 4:03:02 AM Zip completed (compressed size: 65,782 Kb)
4/7/2010 4:03:02 AM Removing the backup: D:\backup\***
4/7/2010 4:03:02 AM Uploading D:\backup\*** to ftp://***
4/7/2010 4:03:03 AM > USER backup
4/7/2010 4:03:03 AM < 331 Password required for backup
4/7/2010 4:03:03 AM > PASS *****
4/7/2010 4:03:05 AM < 230 User *** logged in
4/7/2010 4:03:05 AM > CWD ***
4/7/2010 4:03:05 AM < 250 CWD command successful
4/7/2010 4:03:05 AM > TYPE I
4/7/2010 4:03:05 AM < 200 Type set to I
4/7/2010 4:03:05 AM > PORT ***
4/7/2010 4:03:05 AM < 200 PORT command successful
4/7/2010 4:03:05 AM > STOR ***
4/7/2010 4:03:05 AM < 150 Opening BINARY mode data connection for ***
4/7/2010 4:03:05 AM Data connection established with *** on 4/7/2010 @ 4:03:05 AM
4/7/2010 4:13:17 AM < 226 Transfer complete
4/7/2010 4:13:17 AM > QUIT
4/7/2010 4:13:17 AM < 221 Goodbye.
4/7/2010 4:13:17 AM Disconnected from *** on 4/7/2010 @ 4:13:17 AM
4/7/2010 4:13:17 AM Upload of D:\backup\*** completed
4/7/2010 4:13:17 AM > USER ***
4/7/2010 4:13:17 AM < 331 Password required
4/7/2010 4:13:47 AM ERROR: Remote file size verifiсation failed: The FTP command execution timed-out.
4/7/2010 4:13:47 AM Removing D:\backup\***
4/7/2010 4:13:47 AM Cleaning ftp://***
4/7/2010 4:13:47 AM > USER ***
4/7/2010 4:13:47 AM < 331 Password required
4/7/2010 4:13:47 AM > PASS *****
4/7/2010 4:13:48 AM < 230 User *** logged in
4/7/2010 4:13:48 AM > CWD ***
4/7/2010 4:13:48 AM < 250 CWD command successful
4/7/2010 4:13:48 AM > TYPE A
4/7/2010 4:13:48 AM < 200 Type set to A
4/7/2010 4:13:48 AM > PORT ***
4/7/2010 4:13:48 AM < 200 PORT command successful
4/7/2010 4:13:48 AM > LIST
4/7/2010 4:13:48 AM Data connection established with *** on 4/7/2010 @ 4:13:48 AM
4/7/2010 4:13:48 AM < 150 Opening ASCII mode data connection for file list
4/7/2010 4:13:48 AM < 226-Transfer complete
4/7/2010 4:13:48 AM < 226 Quotas off
4/7/2010 4:13:48 AM > QUIT
4/7/2010 4:13:48 AM < 221 Goodbye.
4/7/2010 4:13:48 AM Disconnected from *** on 4/7/2010 @ 4:13:48 AM
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Hey there. Every day my log is showing "ERROR: Remote file size verifiсation failed: Remote file size is not equal to the local one". Yet, when I look at the local and remote ZIP file sizes, they are the same. There is nothing wrong with the remote file (SQL restore works fine). I think the issue is the FTP server responed with file size in bytes but SqlBackupAndFtp get local file size in KB as below Quote:SqlBackupAndFtp 6.0.11.30933 Free (run as service) SUMMARY: Database sampleDB: Backup - Success, FTP - Failure DETAILED LOG: 8/8/2011 1:00:10 AM Creating backup of sampleDB to C:\WINDOWS\TEMP 8/8/2011 1:00:10 AM Backup of sampleDB completed 8/8/2011 1:00:10 AM Zipping C:\WINDOWS\TEMP\sampleDB201108080100.bak to E:\dbBackup\sampleDB201108080100.zip 8/8/2011 1:00:14 AM Zip completed (compressed size: 14,366 KB)8/8/2011 1:00:14 AM Removing the backup: C:\WINDOWS\TEMP\sampleDB201108080100.bak 8/8/2011 1:00:14 AM Uploading E:\dbBackup\sampleDB201108080100.zip to ftp://ftp.mytestserver.net:21/ 8/8/2011 1:04:58 AM Upload of E:\dbBackup\sampleDB201108080100.zip completed 8/8/2011 1:05:01 AM WARNING: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:02 AM Trying to get file size again... 8/8/2011 1:05:04 AM WARNING: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:05 AM Trying to get file size again... 8/8/2011 1:05:07 AM ERROR: Remote file size verification failed: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:07 AM Cleaning ftp://ftp.mytestserver.net:21/ 8/8/2011 1:05:09 AM Cleaning E:\dbBackup
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 255
|
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 255
|
It seems the problem is that your FTP Server returns 200 in its response code but not 213 as expected. To find a workaround we need a test connection to your (or similar) FTP server, otherwise we can't reproduce this problem.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Guest wrote:Hey there. Every day my log is showing "ERROR: Remote file size verifiсation failed: Remote file size is not equal to the local one". Yet, when I look at the local and remote ZIP file sizes, they are the same. There is nothing wrong with the remote file (SQL restore works fine). I think the issue is the FTP server responed with file size in bytes but SqlBackupAndFtp get local file size in KB as below Quote:SqlBackupAndFtp 6.0.11.30933 Free (run as service) SUMMARY: Database sampleDB: Backup - Success, FTP - Failure DETAILED LOG: 8/8/2011 1:00:10 AM Creating backup of sampleDB to C:\WINDOWS\TEMP 8/8/2011 1:00:10 AM Backup of sampleDB completed 8/8/2011 1:00:10 AM Zipping C:\WINDOWS\TEMP\sampleDB201108080100.bak to E:\dbBackup\sampleDB201108080100.zip 8/8/2011 1:00:14 AM Zip completed (compressed size: 14,366 KB)8/8/2011 1:00:14 AM Removing the backup: C:\WINDOWS\TEMP\sampleDB201108080100.bak 8/8/2011 1:00:14 AM Uploading E:\dbBackup\sampleDB201108080100.zip to ftp://ftp.mytestserver.net:21/ 8/8/2011 1:04:58 AM Upload of E:\dbBackup\sampleDB201108080100.zip completed 8/8/2011 1:05:01 AM WARNING: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:02 AM Trying to get file size again... 8/8/2011 1:05:04 AM WARNING: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:05 AM Trying to get file size again... 8/8/2011 1:05:07 AM ERROR: Remote file size verification failed: Request: SIZE sampleDB201108080100.zip Response: 200 147117648/8/2011 1:05:07 AM Cleaning ftp://ftp.mytestserver.net:21/ 8/8/2011 1:05:09 AM Cleaning E:\dbBackup
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Any news?
Was working fine this morning sending to a Windows 2000 server have no replaced the Windows 2000 sever with Windows 2008 Server and am seeing this problem every time...
How can this be sorted? is there a solution some two years after the topic was raised?
TIA
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 71
|
Posted: 12 Aug 11 9:56:41 AM: Quote:It seems the problem is that your FTP Server returns 200 in its response code but not 213 as expected. To find a workaround we need a test connection to your (or similar) FTP server, otherwise we can't reproduce this problem. You can find the syntax of the SIZE command at location: http://www.networksorcery.com/enp/rfc/rfc3659.txt
|
|
|
|
|
