Ошибка при формировании отчёта

Вопросы и проблемы
#1

Вот такой стрэктрейс при формировании PDF

2019-05-21 09:37:10.395 INFO  [pool-6-thread-3/app-core/7719061340] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - OOServer is killing office instance with port 8103
2019-05-21 09:37:10.404 INFO  [pool-6-thread-3/app-core/7719061340] com.haulmont.yarg.formatters.impl.doc.connector.JavaProcessManager - Linux office process manager is going to kill following processes [4612, 462
2019-05-21 09:37:10.428 WARN  [pool-6-thread-3/app-core/7719061340] com.haulmont.yarg.formatters.impl.DocFormatter - An error occurred while generating doc report [РО типовая форма договора для юр. лиц и ИП (средн
java.lang.RuntimeException: com.haulmont.yarg.exception.ReportFormattingException: An error occurred while running task in Open Office server. Template name [РО типовая форма договора для юр. лиц и ИП (среднее) от
        at com.haulmont.reports.libintegration.CubaOfficeIntegration.runTaskWithTimeout(CubaOfficeIntegration.java:53) ~[reports-core-6.10.8.jar:6.10.8]
        at com.haulmont.yarg.formatters.impl.DocFormatter.doCreateDocument(DocFormatter.java:129) ~[yarg-2.0.18.jar:na]
        at com.haulmont.yarg.formatters.impl.DocFormatter.renderDocument(DocFormatter.java:88) ~[yarg-2.0.18.jar:na]
        at com.haulmont.yarg.reporting.Reporting.generateReport(Reporting.java:133) [yarg-2.0.18.jar:na]
        at com.haulmont.yarg.reporting.Reporting.runReport(Reporting.java:100) [yarg-2.0.18.jar:na]
        at com.haulmont.yarg.reporting.Reporting.runReport(Reporting.java:83) [yarg-2.0.18.jar:na]
        at com.haulmont.reports.ReportingBean.createReportDocument(ReportingBean.java:335) [reports-core-6.10.8.jar:6.10.8]
        at com.haulmont.reports.ReportingBean.bulkPrint(ReportingBean.java:245) [reports-core-6.10.8.jar:6.10.8]
        at com.groupstp.rtneo.core.bean.report.RtneoReportWorkerBean.lambda$null$12(RtneoReportWorkerBean.java:292) [app-core-0.1a-SNAPSHOT.jar:na]
        at com.groupstp.rtneo.core.bean.report.RtneoReportWorkerBean.executeScheduledReport(RtneoReportWorkerBean.java:360) [app-core-0.1a-SNAPSHOT.jar:na]
        at com.groupstp.rtneo.core.bean.report.RtneoReportWorkerBean.lambda$runBulkReport$13(RtneoReportWorkerBean.java:292) [app-core-0.1a-SNAPSHOT.jar:na]
        at com.haulmont.cuba.core.sys.SecurityContextAwareRunnable.run(SecurityContextAwareRunnable.java:36) ~[cuba-global-6.10.9.jar:6.10.9]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_212]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_212]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_212]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_212]
        at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_212]
Caused by: com.haulmont.yarg.exception.ReportFormattingException: An error occurred while running task in Open Office server. Template name [РО типовая форма договора для юр. лиц и ИП (среднее) от 17.01 (1).odt]
        at com.haulmont.yarg.formatters.impl.AbstractFormatter.wrapWithReportingException(AbstractFormatter.java:254) ~[yarg-2.0.18.jar:na]
        at com.haulmont.yarg.formatters.impl.DocFormatter.lambda$doCreateDocument$0(DocFormatter.java:125) ~[yarg-2.0.18.jar:na]
        at com.haulmont.reports.libintegration.CubaOfficeIntegration.lambda$null$0(CubaOfficeIntegration.java:35) ~[reports-core-6.10.8.jar:6.10.8]
        at com.haulmont.cuba.core.sys.AppContext.withSecurityContext(AppContext.java:179) ~[cuba-global-6.10.9.jar:6.10.9]
        at com.haulmont.reports.libintegration.CubaOfficeIntegration.lambda$runTaskWithTimeout$1(CubaOfficeIntegration.java:33) ~[reports-core-6.10.8.jar:6.10.8]
        ... 4 common frames omitted
Caused by: java.lang.NullPointerException: null
        at com.haulmont.yarg.formatters.impl.doc.TableManager.getTablesNames(TableManager.java:65) ~[yarg-2.0.18.jar:na]
        at com.haulmont.yarg.formatters.impl.DocFormatter.fillTables(DocFormatter.java:151) ~[yarg-2.0.18.jar:na]
        at com.haulmont.yarg.formatters.impl.DocFormatter.lambda$doCreateDocument$0(DocFormatter.java:118) ~[yarg-2.0.18.jar:na]
        ... 7 common frames omitted
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -nologo is deprecated.  Use --nologo instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -nodefault is deprecated.  Use --nodefault instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -norestore is deprecated.  Use --norestore instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -nolockcheck is deprecated.  Use --nolockcheck instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -nofirststartwizard is deprecated.  Use --nofirststartwizard instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -headless is deprecated.  Use --headless instead.
2019-05-21 09:37:10.481 DEBUG [OOServer: ERR] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - ERR: Warning: -accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp; is deprecated.  Use --accept=socket,
2019-05-21 09:37:11.057 INFO  [pool-6-thread-3/app-core/7719061340] com.haulmont.yarg.formatters.impl.doc.connector.OOServer - OOServer is killing office instance with port 8100
2019-05-21 09:37:11.079 INFO  [pool-6-thread-3/app-core/7719061340] com.haulmont.yarg.formatters.impl.doc.connector.JavaProcessManager - Linux office process manager is going to kill following processes [4646, 466
2019-05-21 09:37:11.103 DEBUG [pool-6-thread-3/app-core/7719061340] com.haulmont.cuba.core.app.execution.ExecutionsImpl - End execution context: group=Reporting, key=2aa68558-0794-363a-573d-0123f188a755

версия офиса: LibreOffice 6.0.7.3 00m0(Build:3)

#2

Помогает презапуск libreoffice, но это, конечно, не дело:

libreoffice --headless --backtrace
#4

Здравствуйте.

PDF печатается в итоге при наличии ошибки? Ошибка может быть если libreoffice работает нестабильно. В этом случае мы останавливаем процесс и запускаем повторно. Поидее со второго повтора должно распечататься без проблем.

#6

Добрый день! После запуска приложения, при первой попытке печати в PDF, выдает ошибку:
“java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=127.0.0.1,port=8101,localHost=localhost,localPort=53128,peerHost=localhost,peerPort=8101”. Со второй попытки все начинает работает в штатном режиме.

Используется Libreoffice.

Полный текст ошибки:
web_1 | Caused by: com.haulmont.yarg.exception.ReportingException: An error occurred while running task in Open Office server
web_1 | at com.haulmont.yarg.formatters.impl.xls.DocumentConverterImpl.lambda$convertOnes$0(DocumentConverterImpl.java:88) ~[yarg-2.2.5.jar:na]
web_1 | at com.haulmont.reports.libintegration.CubaOfficeIntegration.lambda$null$0(CubaOfficeIntegration.java:46) ~[reports-core-7.2.1.jar:7.2.1]
web_1 | at com.haulmont.cuba.core.sys.AppContext.withSecurityContext(AppContext.java:179) ~[cuba-global-7.2.1.jar:7.2.1]
web_1 | at com.haulmont.reports.libintegration.CubaOfficeIntegration.lambda$runTaskWithTimeout$1(CubaOfficeIntegration.java:44) ~[reports-core-7.2.1.jar:7.2.1]
web_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_242]
web_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_242]
web_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_242]
web_1 | … 1 common frames omitted
web_1 | Caused by: com.sun.star.lang.DisposedException: java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=127.0.0.1,port=8101,localHost=localhost,localPort=53128,peerHost=localhost,peerPort=8101
web_1 | at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge$MessageDispatcher.run(java_remote_bridge.java:171) ~[jurt-3.0.0.jar:na]
web_1 | 20:35:51.635 INFO c.h.r.w.r.v.ReportRestControllerExceptionHandler- RestAPIException: Run report error, java.io.IOException: com.sun.star.io.IOException: EOF reached - socket,host=127.0.0.1,port=8101,localHost=localhost,localPort=53128,peerHost=localhost,peerPort=8101

#8

Здравствуйте,
Попробуйте увеличить значение свойства reporting.office.docFormatterTimeout = 50, возможно не хватает времени при первом запуске - https://doc.cuba-platform.com/reporting-7.2-ru/app_properties.html#reporting.docFormatterTimeout. Свойство указывается в app.properties core модуля.

#10

Добрый день!
Установил параметр: reporting.office.docFormatterTimeout = 60
Ошибка при первом запуске осталась.

#11

Какая версия установлена LibreOffice/OpenOffice?