File upload size does not work, what am i doing wrong?

Q&A
1

Hello

I have a problem with uploading files, i have a *.CSV file with size of 350-400MB. It is a really big file compared to simple documents, but i need to read its contents. 

I (think i) know there are two files, that has file upload limits:

  1. forms-config.properties
  2. console-config.properties

But these files are under this folder:

/BonitaCommunity-7.9.1-tomcat\setup\platform_conf\initial\tenant_template_portal

I just cant find this folder (someone wrote it is here):

BONITA_HOME\client\tenants\default\web\forms\conf\forms-config.properties

 

In the first folder i changed the value to 500 from 15 and 25, but it doesnt seem to work. In chrome by timing i see stalled, but i dont get any errors or warnings, not even in bonita log.

Am i missing something? The documentation said this value cannot be higher than the column size in the database, but i am using mysql, and longblob, wich should be enough.

Is it a configuration problem, or maybe bonita cant handle big documents?

 

Best Regard

Zoltán

 

Edit: Im using Bonita community 7.9

 

Update 1.0: I read somewhere that everything is stored in bonita database, so i replaced the blob with the new config files. It should work, but it doesnt, the system throws exception with java heap space. Im still working on this, but it is really annoying that i cant upload a simple file (even if it is 400megs)

 

Update 2.0: Okay i added a few gigs of ram to my virtual machine... almost 8GB and 3 cores, at least it uploads, but cant save it as document, again java heap space. My question is, do i really need a server with more than 10 gigs to upload a file with 350MB?

2

Hi Zoltán,

If you read the documentation about documents handling, you will have more information about documents settings, especially their limit size.

By default, the maximum size of a document is 25Mb. You can reduce or increase this in your production environment by modifying the value of the form.attachment.max.size property in the console-config.properties file of your tenant.

As you are using 7.9 you should not be obliged to update form-config.properties file, this action is required for V6 forms only. 
The maximum document size cannot exceed the capacity of the database column. This value depends on your database.
This maximum document size will also depend on your web server configuration, it can't be more than the maximum post size of the web server.

Bonita is not a CMS like Alfresco for example, but just delivering a light-CMS system. As all data are stored in Bonita Archive database, we strongly recommend to store documents out of Bonita if you think you are going to manage many big files.

And just FYI here are the recommended software and hardware requirements.

Hope this helps

3

Thank you! I will mark your answer accepted :)

In the end i didnt use Bonita for this task, because i could only use my csv if i inserted it in to the database, and it would be really painful to set the MySQL database in a way it could accept 300MB+ blobs. 

I created a service using Spring, and after the upload i iterate over the whole csv, i am not storing it (it wasnt my intention).

Again thank you for your response!