You are not logged in.
Pages: 1
Hi,
I've got the following error exporting a report which as a JXLS template associated.
Report is working ok, but if I select an increasing number of rows (es. 50.000) I've got the following error:
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException:
RecordFormatException: Tried to read data but the maximum length for this record type is 100,000,000. If the file is not corrupt and not large, please open an issue on bugzilla to request increasing the maximum allowable size for this record type. You can set a higher override value with IOUtils.setByteArrayMaxOverride()
Is it possibile to configure / increase this limit?
Kind regards,
Stefano
Offline
Hi Stefano,
you can set this parameter:
org.apache.poi.util.IOUtils.setByteArrayMaxOverride(2_147_483_647);
at reportserver filesystem in path /bin/onstartup.d with your own script.
After then ReportServer will load your settings at startup.
greatings
Marcel
Offline
Hi Marcel,
thank you very much.
Everything is working fine now.
For anyone who's interested I've create a Config.groovy script with this content:
// setting report max size limit
org.apache.poi.util.IOUtils.setByteArrayMaxOverride(2_147_483_647);
and loaded using ReportServer Administration menu: File System -> FileServer root
into folder: bin -> onstartup.d -> Config.groovy
I've also increased Java memory with this option (according to ReportServer documentation):
CATALINA_OPTS=-Xms2048M -Xmx12288M -server -XX:+UseParallelGC -Dfile.encoding=UTF8
and now I'm able to extract some very big reports too.
Best regards,
Stefano
Offline
Pages: 1