Monday, 25 December 2017

Restore Large Snapshot

Hi Everyone,

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".
Acumatica Snapshot Size Limits
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.
  1. 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.
  2. Put the folder into "C:\Program Files (x86)\Acumatica ERP\Database\Data" folder and make sure that all files are there.
    1. Acumatica Database Data Folder
    2. Acumatica Custom Database Data
  3. 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
    1. Acumatica Custom Database Data
  4. 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!

5 comments:

Umesh Ramaswamy said...

Cool. Thanks Tim.

Saiful Murad said...

Hi Sergey,

If I export in Binary format, will I be able to extract and restore?
I tried to extract and put the folder and the installer cannot detect folder with *.adb. Thanks.

Sergey Marenich said...

Hi Saiful,
I think it should work with ADB, but I have not tested it that time.

Ahmed Z said...

Binary format doesn't work for me. Installer detects the folder but is stuck at "Reserving Company IDs."

Would be great if we could do that as it is the default snapshot format.

Any reason to do it in XML format?

Sergey Marenich said...

Hi Ahmed,
Yes it looks like binary format is not supported here anymore.
The reason for XML is that you can see and edit data without need to restore snapshot first. Basically just easier to use.
Hope it helps.