Dear all,
I would like to upload an Excel File which has a size more than 2,5.
For example I have a Excel file which has a size of 60 MB.
I manipulate the model.xml to and change the default setting like:
- Size (Default=2,500KB) to 250000 KB
- Number of rows (Default 20,000) to 2,000,000
-> Now it´s possible to upload a file which is bigger than 2,5 MB but after a while I got the following error message.
Does anybody has an idea which parameter or what else I have to increase?
(http://fs5.directupload.net/images/161202/ptzty2ql.png) (http://www.directupload.net)
(http://fs5.directupload.net/images/161202/9nohe8z4.png) (http://www.directupload.net)
The error says you have run out of JVM memory.
Your increase was to 250M and 2M rows. You will probably have to decrease this. Try say 75M and something over the number of rows you have and see if your file can be processed.
For the future, I would look at a more traditional toolset to getting the data into the database, e.g. an ETL process. I kind of doubt this capability was meant to deal with large datasets.