0010688: CashFlow Forecast report does not work in PostgreSQL

Description

CashFlow Forecast report does not work in PostgreSQL but does in Oracle.

Steps To Reproduce

1. goto - > Financial Management || Receivables & Payables || Analysis Tools || Cashflow Forecast.
2. Give Date

Click on PDF button.

11:00:28 [http-8880-6] ERROR net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 22820750: exception
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportCashflowForecast_sub
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1193)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:843)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:792)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:539)
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)
    at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: IN types character varying and integer cannot be matched
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)
    ... 9 more
11:00:28 [http-8880-6] ERROR org.openbravo.erpCommon.ad_reports.ReportCashflowForecast - Error trying to render the PDF
javax.servlet.ServletException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportCashflowForecast_sub
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1083)
    at org.openbravo.erpCommon.ad_reports.ReportCashflowForecast.printPageDataPdf(ReportCashflowForecast.java:133)
    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:336)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    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:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
    at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
    at java.lang.Thread.run(Unknown Source)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0010184		closed	jeneivemalarkodi	Cashflow Forecast PDF button does not work
related to	defect	0010656		closed	jeneivemalarkodi	Cash Flow Forecast Report : Order of data mismatch between html and PDF Reports

Notes
(0020293) hgbot (developer) 2009-09-23 07:51	Repository: erp/devel/pi Changeset: b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 Author: Jeneive MalarKodi <jeneive.malarkodi <at> openbravo.com> Date: Wed Sep 23 11:19:02 2009 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 [^] Fixes Issue 10688: CashFlow Forecast report does not work in PostgreSQL --- M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml ---

(0020501) hgbot (developer) 2009-09-29 14:17	Repository: erp/devel/pi-pageddatagrid Changeset: b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 Author: Jeneive MalarKodi <jeneive.malarkodi <at> openbravo.com> Date: Wed Sep 23 11:19:02 2009 +0530 URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 [^] Fixes Issue 10688: CashFlow Forecast report does not work in PostgreSQL --- M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml ---

(0021197) arunkumar (reporter) 2009-10-20 10:13	Cash Flow forecast report works in Postgres.Tested & Working fine.

Issue History
Date Modified	Username	Field	Change
2009-09-22 11:17	rafaroda	New Issue
2009-09-22 11:17	rafaroda	Assigned To	=> jeneivemalarkodi
2009-09-22 11:17	rafaroda	Relationship added	related to 0010184
2009-09-22 11:17	rafaroda	Relationship added	related to 0010656
2009-09-22 11:18	rafaroda	Priority	normal => high
2009-09-22 11:18	rafaroda	Status	new => scheduled
2009-09-23 07:51	hgbot	Checkin
2009-09-23 07:51	hgbot	Note Added: 0020293
2009-09-23 07:51	hgbot	Status	scheduled => resolved
2009-09-23 07:51	hgbot	Resolution	open => fixed
2009-09-23 07:51	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 [^]
2009-09-23 16:11	psarobe	Target Version	=> 2.50MP6
2009-09-23 16:12	psarobe	Tag Attached: 250mp6
2009-09-24 19:24	psarobe	Tag Detached: 250mp6
2009-09-24 19:25	psarobe	Target Version	2.50MP6 => 2.50MP7
2009-09-29 14:17	hgbot	Checkin
2009-09-29 14:17	hgbot	Note Added: 0020501
2009-09-29 14:17	hgbot	Fixed in SCM revision	http://code.openbravo.com/erp/devel/pi/rev/b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/b4990292ae3ed1e7fe4214ff54dfe5e04ca5f267 [^]
2009-10-20 10:13	arunkumar	Status	resolved => closed
2009-10-20 10:13	arunkumar	Note Added: 0021197
2009-10-20 10:13	arunkumar	Fixed in Version	=> 2.50MP7
2009-10-21 00:00	anonymous	sf_bug_id	0 => 2882767