installed libreoffice on my ubuntu server. But the other jmix applications on the server cannot use it . Example: they can’t use it to download a report in pdf format. The error is shown below. what is the possible solution?
ReportingException: Unable to convert to calc_pdf_Export. All attempts failed Report name [“Salary payscale pr line” Report (PAYSLIP) ]
Unable to create Open office components.
io.jmix.reports.yarg.formatters.impl.doc.connector.BootstrapException: Unable to connect to the OO process
Unable to connect to the OO process
java.net.ConnectException: Connection refused
I recently experienced this same error when creating PDF documents. Creating Excel documents worked fine. I resolved the issue by changing the Java SDK.
I’m developing a Jmix 2.4.3 project and am using LibreOffice 24.8.4.2. I develop on MacOS (Sequoia 15.2) with IntelliJ IDEA 2024.3.2.2 Ultimate edition. Everything was working with Java 17 (Eclipse Temurin 17.0.14 aarch64). I encountered the error after upgrading my project to Java 21 (Eclipse Temurin 21.0.5 aarch64).
Initially, I tried downgrading LibreOffice with no success. Then I downgraded to Java 17 and everything worked as expected. Upgraded again to Java 21 and I was unable to create PDFs. Finally, I changed the SDK to Amazon Corretto 21.0.6 aarch64 and everything works fine. I have not yet tested on my RedHat server which uses OpenJDK 21.
I don’t know if the issue is really with the Eclipse Temurin implementation of Java or if something needs to be changed in Jmix. However, swapping the SDK resolved the issue for me.
Hope this helps!