OFBiz › OFBiz - Notifications

[jira] [Commented] (OFBIZ-6638) TrialBalance PDF export fails

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 1 message Options
Nicolas Malin (Jira)
Reply | Threaded
Open this post in threaded view
♦
♦
|

[jira] [Commented] (OFBIZ-6638) TrialBalance PDF export fails

Nicolas Malin (Jira)

    [ https://issues.apache.org/jira/browse/OFBIZ-6638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17182613#comment-17182613 ]

Jacques Le Roux commented on OFBIZ-6638:
----------------------------------------

Hi Rohit,

Yes, but as we know we can't get back because of missing axis-1.4, or at least we don't know how. And the call to axis-1.4 does not depend on us but on org.eclipse.birt.runtime:viewservlets. Also Birt viewservlets seems somehow stale https://mvnrepository.com/artifact/org.eclipse.birt.runtime/viewservlets.

I again tried some Gradle tricks but none worked.

I then tried one more thing:
# I removed {{exclude group: 'org.eclipse.birt.runtime.3_7_1', module: 'org.apache.batik.pdf'}} from birt/build.gradle. Unlike said in http://svn.apache.org/viewvc?view=revision&revision=r1753886 it did not prevent Birt from working. But using the "Export as PDF" button rendered a blank page with nothing in log
# I then looked at the HTML generaed source and directly used the request there: https://localhost:8443/accounting/control/TrialBalanceSearchResultsPdf.pdf
# I got one more information: "Original error detected, maybe it would be helps you : org.eclipse.birt.report.engine.api.impl.ParameterValidationException: Required parameter customTimePeriodId is not set."
# I then passed the same (missing) arguments than for CSV: https://localhost:8443/accounting/control/TrialBalanceSearchResultsPdf.pdf?organizationPartyId=Company&customTimePeriodId=6015. This needs to be checked in our code.

I then got another error in log:
{noformat}
2020-08-23 09:26:50,418 |sse-nio-8443-exec-10 |ControlServlet                |T| [[[accounting::TrialBalanceSearchResultsPdf.pdf (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2020-08-23 09:26:50,500 |sse-nio-8443-exec-10 |ConfigXMLReader               |I| controller loaded: 0.0s, 0 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/WEB-INF/handlers-controller.xml
2020-08-23 09:26:50,501 |sse-nio-8443-exec-10 |ConfigXMLReader               |I| controller loaded: 0.019s, 51 requests, 21 views in file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/WEB-INF/common-controller.xml
2020-08-23 09:26:50,524 |sse-nio-8443-exec-10 |ConfigXMLReader               |I| controller loaded: 0.0s, 4 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/commonext/webapp/WEB-INF/controller.xml
2020-08-23 09:26:50,531 |sse-nio-8443-exec-10 |ConfigXMLReader               |I| controller loaded: 0.072s, 512 requests, 241 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/accounting/webapp/accounting/WEB-INF/controller.
xml
2020-08-23 09:26:50,531 |sse-nio-8443-exec-10 |ConfigXMLReader               |I| controller loaded: 0.093s, 9 requests, 9 views in file:/C:/projectsASF/Git/ofbiz-framework/plugins/birt/webapp/accounting/WEB-INF/controller.xml
2020-08-23 09:26:50,596 |sse-nio-8443-exec-10 |RequestHandler                |I| Ran Event [groovy:component://birt/groovyScripts/accounting/TrialBalanceParameters.groovy#] from [request], result is [success]
2020-08-23 09:26:50,597 |sse-nio-8443-exec-10 |RequestHandler                |I| Rendering View [TrialBalanceSearchResultsPdf].  Hidden sessionId by default.
2020-08-23 09:26:50,598 |sse-nio-8443-exec-10 |BirtFactory                   |I| Got report in 0.001s from: file:/C:/projectsASF/Git/ofbiz-framework/plugins/birt/webapp/accounting/reports/TrialBalance.rptdesign
2020-08-23 09:26:50,610 |sse-nio-8443-exec-10 |BirtWorker                    |I| Get report engine
2020-08-23 09:26:50,610 |sse-nio-8443-exec-10 |BirtWorker                    |I| Set BIRT locale:en
2020-08-23 09:26:50,612 |sse-nio-8443-exec-10 |BirtWorker                    |I| BIRT's locale is: en
2020-08-23 09:26:50,612 |sse-nio-8443-exec-10 |BirtWorker                    |I| Run report's task
2020-08-23 09:26:51,391 |sse-nio-8443-exec-10 |ControlServlet                |E| Error in request handler:
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
        at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2363) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:191) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.apache.ofbiz.birt.BirtWorker.exportReport(BirtWorker.java:157) ~[main/:?]
        at org.apache.ofbiz.birt.webapp.view.BirtViewHandler.render(BirtViewHandler.java:145) ~[main/:?]
        at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1183) ~[main/:?]
        at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:908) ~[main/:?]
        at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]
        at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [main/:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:151) [main/:?]
        at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:52) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: java.lang.IndexOutOfBoundsException: Index: 3, Size: 3
        at java.util.ArrayList.rangeCheck(ArrayList.java:657) ~[?:1.8.0_202]
        at java.util.ArrayList.get(ArrayList.java:433) ~[?:1.8.0_202]
        at org.eclipse.birt.report.model.elements.GridItem.getCellPositionInColumn(GridItem.java:393) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.model.elements.GridItem.cacheValues(GridItem.java:267) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.model.elements.ReportDesignImpl.doCacheValues(ReportDesignImpl.java:392) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.model.elements.ReportDesignImpl.cacheValues(ReportDesignImpl.java:379) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.model.api.ReportDesignHandleImpl.cacheValues(ReportDesignHandleImpl.java:1541) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.model.api.ReportDesignHandle.cacheValues(ReportDesignHandle.java:1) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.parser.EngineIRVisitor.translate(EngineIRVisitor.java:275) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.parser.ReportParser.parse(ReportParser.java:178) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.executor.ExecutionContext.getReport(ExecutionContext.java:2214) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.executor.ReportExecutor.<init>(ReportExecutor.java:86) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:107) ~[org.eclipse.birt.runtime-4.4.1.jar:?]
        ... 44 more
2020-08-23 09:26:51,392 |sse-nio-8443-exec-10 |ControlServlet                |E| An error occurred, going to the errorPage: file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/error/Error.ftl
2020-08-23 09:26:51,393 |sse-nio-8443-exec-10 |ControlServlet                |W| Error while trying to write error message using response.getOutputStream or response.getWriter, sending error code [500], and message [<html><body><h1>ERROR
 MESSAGE</h1><hr><p>ERROR in error page, (infinite loop or error page not found with name [file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/error/Error.ftl]</p><p>Original error detected, maybe it would be helps you :
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</p></body></html>]
2020-08-23 09:26:51,394 |sse-nio-8443-exec-10 |ServerHitBin                  |I| Visit delegatorName=default, ServerHitBin delegatorName=default
2020-08-23 09:26:51,396 |sse-nio-8443-exec-10 |ControlServlet                |T| [[[accounting::TrialBalanceSearchResultsPdf.pdf (Domain:https://localhost)] Request Done- total:0.978,since last([accounting::Tria...):0.978]]
{noformat}

It seems we have never been near than a solution. At least I hope so and that not removing org.apache.batik.pdf is not the reason of this last issue. We need to look at the Birt source, but I run out of time at the moment...

Note, we need also to check: "ERROR in error page, (infinite loop or error page not found with name [file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/error/Error.ftl]" I have worked on that recently and must have missed this case for Birt (weird it's common and should be there), not a big deal.



> TrialBalance PDF export fails
> -----------------------------
>
>                 Key: OFBIZ-6638
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6638
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: Release Branch 16.11, Release Branch 18.12, Release Branch 17.12, Trunk
>            Reporter: Jacques Le Roux
>            Assignee: Jacques Le Roux
>            Priority: Major
>             Fix For: 14.12.01, 15.12.01
>
>         Attachments: OFBIZ-6638.patch, image-2019-01-12-14-53-56-292.png
>
>
> # Get to http://demo-trunk.ofbiz.apache.org/accounting/control/TrialBalance?organizationPartyId=Company
> #    pick a "Custom Time Period Id" (default works also)
> #    Submit
> Then the CSV export works but not the PDF, this in trunk demo.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)
Free forum by Nabble Edit this page