Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0010688 | Openbravo ERP | 09. Financial management | public | 2009-09-22 11:17 | 2009-10-21 00:00 | ||||||||||||||
| Reporter | rafaroda | ||||||||||||||||||
| Assigned To | jeneivemalarkodi | ||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | have not tried | ||||||||||||||
| Status | closed | Resolution | fixed | ||||||||||||||||
| Platform | OS | 20 | OS Version | rPath Linux | |||||||||||||||
| Product Version | pi | ||||||||||||||||||
| Target Version | 2.50MP7 | Fixed in Version | 2.50MP7 | ||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 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) | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||