LibreOffice fails with big tables

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.

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

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…

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

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

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

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.

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

kind regards