[
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)
