LibreOffice fails with big tables

Support
#1

Hi

I am having some issues with LibreOffice that I need to address.
When I generate entity report with lines like invoices with 1-40 lines everything is ok. If there are like 200 lines, the pages loads for 5-10 seconds and then I get the message “Libre Office has stopped working” (on windows) and Cuba says “Could’n find OpenOffice” I have tried with .doc and .pdf reports on windows and linux. How can I tweak open office for big reports?

the log looks like this:

 2018-10-11 09:45:32.426 ERROR [http-nio-8080-exec-16/app-core/george.serban] com.haulmont.cuba.core.sys.ServiceInterceptor - Exception: 
com.haulmont.reports.exception.FailedToConnectToOpenOfficeException: java.util.concurrent.TimeoutException Report name [Aviz Insotire]
 at com.haulmont.reports.ReportingBean.createReportDocument(ReportingBean.java:319) ~[reports-core-6.9.5.jar:6.9.5]
 at com.haulmont.reports.ReportingBean.createReportDocument(ReportingBean.java:284) ~[reports-core-6.9.5.jar:6.9.5]
 at com.haulmont.reports.ReportingBean.createReport(ReportingBean.java:202) ~[reports-core-6.9.5.jar:6.9.5]
 at com.haulmont.reports.ReportServiceBean.createReport(ReportServiceBean.java:45) ~[reports-core-6.9.5.jar:6.9.5]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_73]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_73]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_73]
 at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_73]

I have found the intrstructions at: Cancelling Reports - CUBA Platform. Report Generator , I have set the properties in “Administration > Application Properties” but I do not see the “Running Report” window.

#3

Hi,

Try to increase property reporting.openoffice.docFormatterTimeout in the core property. Property equals 20 seconds by default and specifies timeout for the LibreOffice.

Thank you,
Andrey

#5

I increasead docFormatterTimeout but libreoffice crashes for some reason when my report has more than 90 lines … do you have any idea on how to debug? I can’t find the libre office log anywhere…

#6

I have set reporting.backgroundReportProcessingTimeoutMs to 600000 in Administration \ Application properties and LibreOffice does not crash but it takes 2 minutes to create the report … any ideas on how to speed it up?

1 Like
#7

I still have this issue

How long does it take for you to generate a simple invoice with 300 lines, with doc template, generate to pdf using LibreOffice?!

Thank you
George

#8

I think the issue is with .odt templates … with the same content 300 lines i get
.odt -> pdf 10 minutes
.xlsx -> pdf 2 seconds

with odt and xlsx starter template generated by cuba

Thanks

#9

Hi,

For docx -> pdf 3-4 sec, xslx -> pdf 3-4 sec, odt -> pdf 30 sec.
it is preferable to use xlsx/xls for reports that contain a large amount of data.

#10

Thank you Andrey
I changed the template to HTML and it works great (2sec for 300 lines)

kind regards