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


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.

Comments (2) -

  • 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 comment