Topic "SFTP Problem: "1 requests to fill 1 data gaps were issued""

Author Message
cjmorelock
[View user's profile]

Joined: 2014-01-28
Posts: 2
I have a scheduled task that runs each day at the same time to transfer a file from an SFTP site using WinSCP Portable version 5.1.5. The files are SQL Server .bak files (.bak). Most days the transfer completes successfully. But maybe once a week, the file appears to transfer correctly, but the transferred file is not a valid SQL Server backup file, and were I to try to restore it to SQL Server, the restore would fail. If I begin the job again later to transfer the file, it will work--i.e. I will have a valid SQL Server backup file that I can restore to SQL Server. Attached are (what I believe to be) the relevant part the logs from 1) a transfer that works correctly and 2) a transfer that does not work correctly. Can anyone shed some light on what might be the problem? Thanks.
WinSCP_Log.jpg (411.83 KB) [Download]

Description: Shows log for a successful transfer and an unsuccessful transfer.

martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24991
Location: Prague, Czechia
Are you sure that the file was not being written to, while you were downloading it? The message (from subject) would indicate that.
cjmorelock
[View user's profile]

Joined: 2014-01-28
Posts: 2
prikryl wrote:
Are you sure that the file was not being written to, while you were downloading it? The message (from subject) would indicate that.


Thank you. It is possible that the file is still being written to. If my understanding is correct, I can only see the time stamp indicating when the file began being written to and not when it finished being written to. To me it seems like I'm allowing more than enough time for this particular file to be written before I start transferring it, but perhaps not. I just didn't know if the message in the log, "1 request to fill 1 data gaps were issued", could indicate some other problem than this. So thank you for this confirmation.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License