Why Acumatica can't restore snapshot bigger then 2Gb?

Hello everybody,

today I want to share with you my guess regarding why Acumatica can't restore snapshot bigger then 2 Gb. As far as I see at database level, all files are going into table UploadFileRevision. If to look into structure of this table, you'll find that it has column data, which looks like this: 

if to google a bit, you'll find that maximum size which Varbinary(MAX) can accomodate is 2 Gb. 

That's why if you snapshot is bigger then 2 Gb, look for other way of restoring of your snapshot

Summary

As of now it is my guess on why snapshot can't be restored. I'll update everybody how to deal with this, once I'll find solution, which satisfies me completely.

2 Comments

  • Gabriel Michaud said

    Snapshot ZIP files are not stored in the database. They go in the file system. The limitation is therefore not due to the varbinary(max) field. Check out this article, could be helpful https://acumaticaclouderp.blogspot.com/2017/12/acumatica-snapshots-uploading-and.html

  • docotor said

    Hi Gabriel. Thanks for comment. I believe we talk about two different use cases. When snapshot is created, and when snapshot is uploaded into Acumatica. I've analyzed code of uploading of snapshot. As far as I've seen in the code, I've noticed some lines which lead me to that conclusion.

Add a Comment