topic Large XLS files in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/large-xls-files/m-p/9578#M3449 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">(from email)<BR />While I was evaluating your Alfresco ECM release candidate version 1, I encountered an error while trying to upload a large (200mb+ excel file).&nbsp; You may already be aware of this, but I just wanted to let you know.&nbsp; I wonder if this error is caused by the database I am using rather than your software (I am using MySQL at this point, but when our company implements an ECM solution, we will be using oracle database).&nbsp; <BR /><BR />javax.faces.FacesException: Error calling action method of component with id add-content-upload-end:_id24<BR />caused by:<BR />javax.faces.el.EvaluationException: Exception while invoking expression #{AddContentWizard.next}<BR />caused by:<BR /><STRONG>java.lang.OutOfMemoryError: Java heap space</STRONG></BLOCKQUOTE><BR /><SPAN>Hi,</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>The text extraction used by the indexing is provided by the POI libraries.&nbsp; There is, unfortunately, no way to stream-convert the XLS document: it has to be loaded into memory and manipulated in memory.&nbsp; I can't really say how much memory you will need based on document size.&nbsp; My initial guess is that N*2 MB would be a minimum.&nbsp; This would be over and above memory required for the usuals processing.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>If you have an alternative library available for extracting text from an XLS document, or if you wish to bypass indexing of the XLS documents, then feel free to recommend it to us.</SPAN><BR /><BR /><SPAN>The Open Office converter could also be used for XLS files larger than a given size, but this is slower than the POI libraries.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Mon, 31 Oct 2005 11:03:48 GMT derek 2005-10-31T11:03:48Z Large XLS files https://connect.hyland.com/t5/alfresco-archive/large-xls-files/m-p/9578#M3449 (from email)While I was evaluating your Alfresco ECM release candidate version 1, I encountered an error while trying to upload a large (200mb+ excel file).&nbsp; You may already be aware of this, but I just wanted to let you know.&nbsp; I wonder if this error is caused by the database I am using rather than Mon, 31 Oct 2005 11:03:48 GMT https://connect.hyland.com/t5/alfresco-archive/large-xls-files/m-p/9578#M3449 derek 2005-10-31T11:03:48Z Re: Large XLS files https://connect.hyland.com/t5/alfresco-archive/large-xls-files/m-p/9579#M3450 <HTML><HEAD></HEAD><BODY><SPAN>This has been raised for implementation: </SPAN><A href="http://www.alfresco.org/jira/browse/AR-205" rel="nofollow noopener noreferrer">http://www.alfresco.org/jira/browse/AR-205</A></BODY></HTML> Mon, 31 Oct 2005 12:10:51 GMT https://connect.hyland.com/t5/alfresco-archive/large-xls-files/m-p/9579#M3450 derek 2005-10-31T12:10:51Z