Skip to main content

Acumatica Snapshots - Uploading and restoring large files

In Acumatica ERP, you can create company snapshots containing your company’s full or partial data. Snapshots that can be saved locally in the same database, or at a specified location.

You can import and restore snapshot to another company, in this case test company, it's pretty handy tool very useful during implementations, customization and support/troubleshooting while you work with data.

You will occasionally run into few technical issues with snapshots, the newer version now needs you to keep all users logged out and in maintenance mode to take snapshot, link to blog article here.

Today we are going to discuss how to export and import snapshots which are larger in file size of above 1GB, this is not a limitation from Acumatica and more to do with constraint and default value set in IIS (Internet Information Server).
IIS by default allows uploading of a file size of 1GB and it limits the upload process and it can be tweaked to upload upto 4 GB file size and that's the limitation of IIS.

Step 1: Locate your Acumatica web.config file on your application server if you have access to your instance if hosted locally or you have access to server.

Open in notepad or your favorite editor and look for specific tag "<httpRuntime" and your code should look something like below screenshot


Step 2: In order to have Acumatica upload and restore larger file size we need to tweak the following code and specify the file size in bytes.
<httpRuntime executionTimeout="300" requestValidationMode="2.0" maxRequestLength="2097152" />
By specifying the maxRequestLength we are allowing Acumatica to process files upto 2 GB.

Note: If you make any changes to web.config ensure all users are logged out and save the file, which will restart the IIS instance and reload this configuration

Step 3: Log back and test uploading a larger file size of 1.5GB and restore the snapshot.

All snapshot files uploaded will be stored under Acumatica root/snapshot folder, we have tested uploading upto 5 GB of snapshot size so it's quite possible depending on your IIS version and latest Acumatica ver 6.1



Comments

Popular posts from this blog

Acumatica Snapshot creation without switching on Maintenance mode Warning

New Security Feature: Snapshot creation without switching on Maintenance mode.

One of the really cool things for System administrator dealing with Acumatica is taking snapshots and being able to re-create another instance or Company, however this led to creating bad records or corrupted data as we are taking snapshots other users might be using the system and there was a good chance of data corruption.

In the latest release 2017 R2 Acumatica now warns user with a message "The snapshot may contain corrupted data because you are not in maintenance mode." letting you know not to take snapshot of the live instance without switching the maintenance mode.



Step 1: Navigate to System --> Management --> Apply Updates, click on the button "Schedule Lockout" and specify the reason for lockout 

Step 2: Navigate to System --> Management --> Manage Companies and click on Create Snapshot

Step 3: Don't forget to remove the lockout. 

Such incremental features allows Acu…

Manage 3dCart Orders, eCommerce distribution made easy with Acumatica Cloud ERP

Selling Online should be as easy as shopping itself - 3dCart.
While we say managing 3dCart orders within Acumatica should be as easy as a click.

Our custom integration package for 3dCart allows business owners to download orders from 3dCart shopping software into Acumatica Cloud ERP for distribution and processing of orders.
We just did build an import scenario or API/Web service to download orders, instead we built the framework to accommodate your growing business, multiple websites orders can now be processed in Acumatica, that's the power of Acumatica framework.

We have several options for order processing in Acumatica
a) Manual type the order - nope old style
b) Import scenario allows to import orders exported from your ecommerce site - Still is bit manual to export/import process
c) Using Web services build an interface to connect multiple websites to import open orders - right way to scale your business.

Acumatica-3dCart Integration We built 3dCart integration with Acumatic…

Demo of Acumatica eSignature Proof of Delivery From InfoSourcing Inc

Acumatica eSignature Plugin demonstration of Proof of delivery feature, the video covers configuration settings, enabling and capturing a signature on shipment screen along with the custom report.



For more product demo's please contact InfoSourcing Inc, we will provide with 14-day trial version for your SaaS or PCS or PCP version.