Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010184Openbravo ERP09. Financial managementpublic2009-08-04 18:242009-10-06 11:37
rafaroda 
jeneivemalarkodi 
highmajoralways
closedfixed 
20rPath Linux
2.50MP2 
2.50MP6 
Core
No
0010184: Cashflow Forecast PDF button does not work
Cashflow Forecast PDF button does not work
1) Go to Financial Management || Receivables & Payables || Analysis Tools || Cashflow Forecast
2) Click on PDF Format button.

You will get a blank pop-up window.

Error log message says:
20:17:52 [http-8989-1] ERROR org.openbravo.erpCommon.ad_reports.ReportCashflowForecast - Error trying to render the PDF
javax.servlet.ServletException: Could not load object from location : /home/openbravo/workspaces/erp-pi-ora/openbravo/WebContent/src-loc/design/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jasper
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1067)
    at org.openbravo.erpCommon.ad_reports.ReportCashflowForecast.printPageDataPdf(ReportCashflowForecast.java:136)
    at org.openbravo.erpCommon.ad_reports.ReportCashflowForecast.doPost(ReportCashflowForecast.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:326)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:619)
Caused by: javax.servlet.ServletException: Could not load object from location : /home/openbravo/workspaces/erp-pi-ora/openbravo/WebContent/src-loc/design/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jasper
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1018)
    ... 29 more
Caused by: net.sf.jasperreports.engine.JRException: Could not load object from location : /home/openbravo/workspaces/erp-pi-ora/openbravo/WebContent/src-loc/design/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jasper
    at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:267)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:310)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:259)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275)
    at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:424)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:388)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:249)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:889)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:811)
    at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1012)
    ... 29 more


The problem is that the report is pointing to a subreport which file does not exist.
The solution is NOT compiling erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml into a *.jasper file and upload it.

The solution is making ReportCashflowForecast.jrxml pointing to ReportCashflowForecast_sub.jrxml
No tags attached.
related to feature request 0004493 acknowledged rmorley Report Print Option 
related to defect 00106882.50MP7 closed jeneivemalarkodi CashFlow Forecast report does not work in PostgreSQL 
blocks defect 0010656 closed jeneivemalarkodi Cash Flow Forecast Report : Order of data mismatch between html and PDF Reports 
Issue History
2009-08-04 18:24rafarodaNew Issue
2009-08-04 18:24rafarodaAssigned To => rafaroda
2009-08-04 18:29rafarodaRelationship addedrelated to 0004493
2009-08-04 18:30rafarodaNote Added: 0018828
2009-08-19 07:27rafarodaAssigned Torafaroda => balamurugan
2009-08-19 07:27rafarodaStatusnew => scheduled
2009-09-14 07:25rafarodaAssigned Tobalamurugan => jeneivemalarkodi
2009-09-18 12:08hgbotCheckin
2009-09-18 12:08hgbotNote Added: 0020192
2009-09-18 12:08hgbotStatusscheduled => resolved
2009-09-18 12:08hgbotResolutionopen => fixed
2009-09-18 12:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]
2009-09-18 12:21jeneivemalarkodiRelationship addedblocks 0010656
2009-09-22 11:02psarobeStatusresolved => new
2009-09-22 11:02psarobeResolutionfixed => open
2009-09-22 11:02psarobeNote Added: 0020259
2009-09-22 11:15psarobeStatusnew => scheduled
2009-09-22 11:15psarobefix_in_branch => pi
2009-09-22 11:15psarobeStatusscheduled => resolved
2009-09-22 11:15psarobefix_in_branchpi =>
2009-09-22 11:17rafarodaRelationship addedrelated to 0010688
2009-09-22 11:19rafarodaNote Deleted: 0020259
2009-09-22 11:25psarobeStatusresolved => closed
2009-09-22 11:25psarobeNote Added: 0020261
2009-09-22 11:25psarobeFixed in Version => 2.50MP6
2009-09-23 00:00anonymoussf_bug_id0 => 2864613
2009-09-29 14:13hgbotCheckin
2009-09-29 14:13hgbotNote Added: 0020484
2009-09-29 14:13hgbotStatusclosed => resolved
2009-09-29 14:13hgbotResolutionopen => fixed
2009-09-29 14:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]
2009-10-06 11:37psarobeStatusresolved => closed
2009-10-06 11:37psarobeNote Added: 0020766

Notes
(0018828)
rafaroda   
2009-08-04 18:30   
Related to commit of https://issues.openbravo.com/view.php?id=4493#bugnotes [^]
(0020192)
hgbot   
2009-09-18 12:08   
Repository: erp/devel/pi
Changeset: ef76f0b2145588b6fc46d9ab82acdc0e8364ec78
Author: jeneive malarkodi <jeneive.malarkodi <at> openbravo.com>
Date: Fri Sep 18 15:37:39 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]

Fixes Issue 10184: Cashflow Forecast PDF button does not work

---
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
---
(0020261)
psarobe   
2009-09-22 11:25   
New bug has been opened related to this
(0020484)
hgbot   
2009-09-29 14:13   
Repository: erp/devel/pi-pageddatagrid
Changeset: ef76f0b2145588b6fc46d9ab82acdc0e8364ec78
Author: jeneive malarkodi <jeneive.malarkodi <at> openbravo.com>
Date: Fri Sep 18 15:37:39 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]

Fixes Issue 10184: Cashflow Forecast PDF button does not work

---
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
---
(0020766)
psarobe   
2009-10-06 11:37   
Closed again because hudson has reopened without no reason