[ https://issues.apache.org/jira/browse/OFBIZ-7317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15331674#comment-15331674 ]
Rohit Koushal edited comment on OFBIZ-7317 at 6/15/16 1:23 PM: --------------------------------------------------------------- Found various problem under this report 1. Type miss-match between parameter defined in the report and the passed parameters. Just because of that we are getting an exception like The type of parameter "DateYear" is expected as "integer", not "java.lang.String". 2. This report totally depends on demo data provided under the SalesOrderItems applications/order/data/SalesOrderDemoData.xml. 3. This report has lots of hard coded check and values based on SalesOrderDemoData.xml data . 4. There are too many non-existing fields(like eBay, RRC, OtherFree and NBO etc) which we tried to get from entity SalesOrderItemStarSchema. I didn't find any documentation of this report over the confluence, In my opinion, we need to remove this report as its foundation totally depends on the demo data. was (Author: rohit.koushal): Found out various problem under this report 1. This report depends on demo data provided under the SalesOrderItems applications/order/data/SalesOrderDemoData.xml. 2. This report have lots of hard coded check and values. > Net Before Overhead Report is not working > ------------------------------------------ > > Key: OFBIZ-7317 > URL: https://issues.apache.org/jira/browse/OFBIZ-7317 > Project: OFBiz > Issue Type: Sub-task > Components: order, specialpurpose/birt > Reporter: Rohit Koushal > Assignee: Rohit Koushal > > Net Before Overhead Report is not working > Screen : > https://ofbiz-vm.apache.org:8443/ordermgr/control/OrderPurchaseReportOptions > Section : Net Before Overhead Report > Getting error like > {code} > [java] > org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The > type of parameter "DateYear" is expected as "integer", not "java.lang.String". > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask.validateParameterValueType(EngineTask.java:940) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:862) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:789) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:706) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1531) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:692) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:95) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) > ~[org.eclipse.birt.runtime_4.3.1.v20130918-1142.jar:?] > [java] at org.ofbiz.birt.BirtWorker.exportReport(BirtWorker.java:143) > ~[ofbiz-birt.jar:?] > [java] at > org.ofbiz.birt.webapp.view.BirtViewHandler.render(BirtViewHandler.java:118) > ~[ofbiz-birt.jar:?] > [java] at > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) > ~[ofbiz-webapp.jar:?] > [java] at > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) > ~[ofbiz-webapp.jar:?] > [java] at > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) > [ofbiz-webapp.jar:?] > [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) > [servlet-api-3.1.jar:?] > [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > [servlet-api-3.1.jar:?] > [java] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:323) > [ofbiz-webapp.jar:?] > [java] at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) > [tomcat-8.0.33-catalina.jar:8.0.33] > [java] at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) > [tomcat-8.0.33-tomcat-coyote.jar:8.0.33] > [java] at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) > [tomcat-8.0.33-tomcat-coyote.jar:8.0.33] > [java] at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) > [tomcat-8.0.33-tomcat-coyote.jar:8.0.33] > [java] at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) > [tomcat-8.0.33-tomcat-coyote.jar:8.0.33] > [java] at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [?:1.8.0_66] > [java] at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [?:1.8.0_66] > [java] at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > [tomcat-8.0.33-tomcat-util.jar:8.0.33] > [java] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_66] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)