Have you seen such error before when you try to upload snapshot of the size more than a gigabyte?
The Error message: “Snapshot file size exceed the maximum allowed size”.
There are multiple reasons why it is not allowed – connection stability, IIS limitations, Memory size, on the fly processing limitations and so on.
But what you still need to restore a snapshot and you need to in any possible way? Lucky you there is a stable way for that using Acumatica Configuration Wizard.
Wizard uses the same engine as snapshots to import data during setup, so it can easily insert your snapshots data with no matter on how big is your snapshots as it does not require in memory processing any more.
Lets check how to do it.
- First of all get a zip file of a snapshot and extract all files to the folder. I recommend you the same format as other files in Acumatica data folders. In Acumatica 2017 it is XML format.
- Put the folder into “C:\Program Files (x86)\Acumatica ERP\Database\Data” folder and make sure that all files are there.
- Now you can launch Acumatica configuration wizard and it will automatically add your folder to list of data sets it can insert in Acumatica. This data sets are available
- And just complete installation like you install normal demo data.
Your snapshot data will be there as soon as installation is completed.
Hope it helps!
Unfortunately this approach ignores custom columns data. Even if your snapshot has custom columns (columns with USR prefix), it won’t be inserted during restoration.
The problem is fixed in 2024r1 version of Acumatica.