[jira] [Comment Edited] (OFBIZ-7317) Net Before Overhead Report is not working

[Nicolas Malin (Jira)]

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