Scheduled Backups - Not Working - Now Fixed

More a heads up than a question.

We have been using scheduled backups as soon as they became available. Having been a Sage 50 user for a long time, it was a feature long overdue, and it works beautifully.

However.....It stopped working sometime last week. I only knew because when I closed Sage when leaving work, it said I had not backed up in over a week. When I checked, there were no records of any previous automatic backups or data checks in the last 8 days. I came home, logged back on, and set to work, thinking a reinstall and restore may be the last resort If I cannot figure it out.

We had started seeing performance issues on the network. We also started seeing a message during daily use which none of us had seen before. During a customer search, we would see a very brief popup, "Automated backup in progress". The kind of popup with the progress bar. It was clearly linked to the issue.

I tied various things to get it working. When nothing worked, I was preparing to fully backup and perform a Clean install and restore. In the end I did not need to.

Manually, I could run a data check fine, and run the backup fine. Scheduled backup just would not work, to any location. Using Task Manager, I could see the scheduled process begin, but the file was never created. At this point I also noticed the the Sage 50 Accounts Service V29, had a LOT of disk usage, and more to the point, it never stopped using the disk until I stopped the service manually or rebooted. The disk usage would continue, even with Sage closed and no one logged in. This was the clue...

Knowing that the backup was first created in Windows/Temp, I opened that folder and watched the backup file be created, then disappear, then be created again, then disappear. It never stopped.

Going back into Sage, I noticed that my manual backups were for Data files only, whereas my Scheduled Backups contained Transactional & Customer record attachments. I then tried a manual backup using the same settings as the Scheduled backup, and the backup failed. "Error, unable to open file Customer xxxx/file xxx". Its been a very long time since we have had a backup error.

We keep PDF copies of PO`s in the customers records, as it makes thing easier come audit time. I could open the file (PDF) fine in Windows, but the backup did not like it. I re-saved the file with a different name and deleted the original. Set the scheduled backup and waited. Success. 

In summary, the Attachment files are not checked by the "Check data" option, which is understandable.

But it would appear that the Scheduled Backup does not register the backup error. Instead, it just keeps trying, and trying, and trying to create the backup file as requested. No error messages, no indication anything is wrong, it just keeps going. This explains our performance issues. It even seems to start re-trying after a reboot. Maybe someone at Sage can confirm if this is correct, or whether we just had a glitch.

Apologies for the wall of text, but its used up all of my evening, and info like this can be invaluable. I know because I have been on the other end.

If it helps one person, it's been worth the waffle. Slight smile

Its bed time.

  • 0

    Hi Mark,

    Thanks for using Community Hub, and thank you for your helpful and detailed post!

    Community Hub is a searchable resource so your post is very likely to be of help to anyone experiencing a similar issue in the future, thank you for sharing.

    I've passed the details of your experience over to the product team to look at to see if it's something that can be explored further, and we'll also see if its something that we can add to the product Knowledgebase.

    Regards,

    Andy
    Sage UKI

  • 0

    Hi Mark,

    Further to this, just looking to get a bit more information if we can. 

    How did you know to rename that one item? Was there something about it that stood out, maybe an unusual character in the file name?

    Andy

  • 0 in reply to Andy Rickeard

    Hi Andy.

    During the failed backup, the exact error was, "Error opening file", with the location and filename shown.

    I browsed to that location in explorer, and tried to open the file. The file opened without issue. I then assumed that maybe something in the filename was causing an issue, as it was very Date driven. So I renamed the file. When that did not work, I opened and re-saved the file using my PDF editor. This fixed the issue.

    As the file originated from elsewhere, (Email), I can only assume the file had a hidden issue.

  • 0 in reply to MarkC

    Thanks Mark, were there any non alpha-numeric characters in the original file name?

  • 0 in reply to Andy Rickeard

    Hi Andy.

    Other than Hyphens, No. But our installation is full of attachments with hyphens in the file name.
    Original filename was "Doc - 11 Jan 2024 - 3-38 pm.pdf".
    I changed this to "Doc-11Jan2024-3-38 pm.pdf", using the rename file function, which made no difference.

    Opening & re-saving the file fixed the issue.