0010184: Cashflow Forecast PDF button does not work

Description

Cashflow Forecast PDF button does not work

Steps To Reproduce

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.

Proposed Solution

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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	feature request	0004493		acknowledged	rmorley	Report Print Option
related to	defect	0010688	2.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

Notes
(0018828) rafaroda (developer) 2009-08-04 18:30	Related to commit of https://issues.openbravo.com/view.php?id=4493#bugnotes [^]

(0020192) hgbot (developer) 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 (manager) 2009-09-22 11:25	New bug has been opened related to this

(0020484) hgbot (developer) 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 (manager) 2009-10-06 11:37	Closed again because hudson has reopened without no reason

Issue History
Date Modified	Username	Field	Change
2009-08-04 18:24	rafaroda	New Issue
2009-08-04 18:24	rafaroda	Assigned To	=> rafaroda
2009-08-04 18:29	rafaroda	Relationship added	related to 0004493
2009-08-04 18:30	rafaroda	Note Added: 0018828
2009-08-19 07:27	rafaroda	Assigned To	rafaroda => balamurugan
2009-08-19 07:27	rafaroda	Status	new => scheduled
2009-09-14 07:25	rafaroda	Assigned To	balamurugan => jeneivemalarkodi
2009-09-18 12:08	hgbot	Checkin
2009-09-18 12:08	hgbot	Note Added: 0020192
2009-09-18 12:08	hgbot	Status	scheduled => resolved
2009-09-18 12:08	hgbot	Resolution	open => fixed
2009-09-18 12:08	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]
2009-09-18 12:21	jeneivemalarkodi	Relationship added	blocks 0010656
2009-09-22 11:02	psarobe	Status	resolved => new
2009-09-22 11:02	psarobe	Resolution	fixed => open
2009-09-22 11:02	psarobe	Note Added: 0020259
2009-09-22 11:15	psarobe	Status	new => scheduled
2009-09-22 11:15	psarobe	fix_in_branch	=> pi
2009-09-22 11:15	psarobe	Status	scheduled => resolved
2009-09-22 11:15	psarobe	fix_in_branch	pi =>
2009-09-22 11:17	rafaroda	Relationship added	related to 0010688
2009-09-22 11:19	rafaroda	Note Deleted: 0020259
2009-09-22 11:25	psarobe	Status	resolved => closed
2009-09-22 11:25	psarobe	Note Added: 0020261
2009-09-22 11:25	psarobe	Fixed in Version	=> 2.50MP6
2009-09-23 00:00	anonymous	sf_bug_id	0 => 2864613
2009-09-29 14:13	hgbot	Checkin
2009-09-29 14:13	hgbot	Note Added: 0020484
2009-09-29 14:13	hgbot	Status	closed => resolved
2009-09-29 14:13	hgbot	Resolution	open => fixed
2009-09-29 14:13	hgbot	Fixed in SCM revision	http://code.openbravo.com/erp/devel/pi/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/ef76f0b2145588b6fc46d9ab82acdc0e8364ec78 [^]
2009-10-06 11:37	psarobe	Status	resolved => closed
2009-10-06 11:37	psarobe	Note Added: 0020766