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

Reply via email to