SQLite.SQLiteException: Full
at SQLite.SQLiteCommand.ExecuteNonQuery () [0x000ae] in :0
at SQLite.SQLiteConnection.Execute (System.String query, System.Object args) [0x00040] in :0
at ManagerServer.HttpHandlers.Businesses.Business.BackupDownload.Prepare (System.String filename, System.Boolean attachments, System.Boolean emails, System.Boolean history) [0x00104] in :0
at ManagerServer.HttpHandlers.Businesses.Business.BackupDownload.Get () [0x0007a] in :0
at ManagerServer.HttpHandlers.HttpHandler.ProcessRequest () [0x004cb] in :0
If I uncheck the Attachments option the backup will continue without error.
To trigger this error message I use the Backup button from within my present version, 20.9.56.
The file is the [business].manager file found in the ManagerData folder on the server.
I have always done my best to update the software on at least a weekly basis but regrettably, I went on a holiday so I probably don’t have the latest mono-dependent release.
This error appeared in earlier releases so I would guess the backup error will still appear in the latest mono-dependent release. If the error was corrected in the latest mono-dependent release then I’m happy to install it if it is still available, before I install the very latest release.
The error does not appear with my [business].manager files 14.75MB and smaller. My files of 29MB and larger encounter the error. When I uncheck the ATTACHMENTS option for the 29MB and larger files the error is not encountered.
I understand a backup is required using my present version before I can update to the newest version. Also, I have been running Manager on a QNAP system since I started using it and will need to figure out how to install the newest version on my QNAP or, I will have to install the new version on another server like MAC or Ubuntu.
IF it is possible to use my existing [business].manager files in the new installation I could just make copies of them and forget about making a backup - Is that possible?
As always, Thank You for your support and your quick response to my questions. I’m looking forward to your reply.
Mono was deprecated in version 20.9.66. Current version is 20.9.87.
There should be no need for an interim update. The update will work fine as long as your old version is not many, many years old (which it is not). Besides, I doubt any work was being done during the short interval before 20.9.66 that would affect this. Here is what I would do:
Since you can make a backup as long as you exclude attachments, I would make an attachment-free backup using your existing version. (This is just extra insurance.)
Go to the application data folder and make a copy of the business data file. Store this somewhere safe. (Your desktop will be adequate for this purpose. The storage will be temporary.) Leave the original file where it is. This copy is exactly what the backup process would create, except it will not include the date in the file name.
Update to the latest version and see if the problem is resolved. Make sure all functions operate successfully.
As long as things check out correctly, you can delete the temporary copy of your business.
I think you’ve encountered some limit associated with transfers to your QNAP device, not anything to do with Manager. You are on your own there.
also, that’s not entirely true, you don’t need to, but it’s always a good thing.
I don’t know QNAP or it’s underlying operating system, but you should have two other options available to you.
If your intent is to only create a backup, you can either:
if you are able to SSH into the QNAP NAS, then you can probably use scp and copy those files out, just copy everything out of the Application Data folder to a local device. (preferred, but slightly difficult to use if you don’t know what you’re doing)
if you have a share or some “explorer”/“finder” tool available that is able to navigate to the Application Data folder directly, just navigate there and copy the folder/files out (not preferred, but usually easier for those not versed in command line tools)
@LeeK, this thread has wandered a little from my original, intended line of inquiry. So let me return to it.
You did not answer my question: does the problem persist after you update your software? If it does, please post a screen shot of the error message (rather than transcribing it).
It’s been a while but I have been busy since Tuts last post:
I have built a new host system using FreeNas;
Created an Ubuntu 18.04.5 desktop environment;
installed Manager and Caddy using the server install instructions on this site, which were Very Well Written and Accurate - Thank You to whom ever invested the documentation time for us users!!!
The results are:
I can now install the latest Manager release (20.10.93) and was able to import all of my business files directly without depending on backups made previously;
I can make full backups of everything without errors.