Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011231Openbravo ERP09. Financial managementpublic2009-11-03 18:272009-11-14 00:00
Reporternetworkb 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP8 
Target Version2.50MP9Fixed in Version2.50MP9 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011231: Error shown when a BP is selected in General Ledger Report and try to print it in PDF or Excel
DescriptionIn General Ledger report, a BP is selected and Print button is pressed the following message is shown:

      
Error:
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    
Important: Only happens when data is retrieved in the HTML format and "Next" arrow is shown in the toolbar
Steps To ReproduceONLY REPRODUCES IN POSTGRESQL

Go to Financial Management > Accounting > Analysis tools > General Ledger Report.
Select two dates (IE From 01-01-2000 to 01-01-2010).
Select an Accounting Schema (be sure that contains accounting entries).
Press HTML button.
Note: to continue, make sure that "Next" arrow is shown in the toolbar
Select a Business Partner.
Press "Printer" buttom.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00112802.40MP11 closed vmromanos General Ledger group information for BP with same name 
Attached Filespng RGL.png (117,679) 2009-11-04 09:16
https://issues.openbravo.com/file_download.php?file_id=1910&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-11-03 18:27networkbNew Issue
2009-11-03 18:27networkbAssigned To => rafaroda
2009-11-04 09:16rafarodaNote Added: 0021550
2009-11-04 09:16rafarodaStatusnew => feedback
2009-11-04 09:16rafarodaFile Added: RGL.png
2009-11-04 09:47rafarodaAssigned Torafaroda => vmromanos
2009-11-04 09:47rafarodaPriorityimmediate => urgent
2009-11-04 09:47rafarodaStatusfeedback => scheduled
2009-11-04 09:47rafarodaProposed Solution updated
2009-11-05 12:29vmromanosStatusscheduled => feedback
2009-11-05 12:32networkbNote Added: 0021603
2009-11-05 13:01vmromanosNote Added: 0021606
2009-11-05 13:36networkbNote Added: 0021607
2009-11-05 13:36networkbStatusfeedback => new
2009-11-05 13:49rafarodaStatusnew => scheduled
2009-11-05 13:49rafarodaNote Added: 0021608
2009-11-05 13:49rafarodafix_in_branch => pi
2009-11-12 19:38vmromanosRelationship addedblocks 0011280
2009-11-12 19:45vmromanosNote Added: 0021792
2009-11-12 20:27hgbotCheckin
2009-11-12 20:27hgbotNote Added: 0021794
2009-11-12 20:27hgbotStatusscheduled => resolved
2009-11-12 20:27hgbotResolutionopen => fixed
2009-11-12 20:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/adeb9642d39d1d6af29202a3dc8c90e5ede95296 [^]
2009-11-13 11:49arunkumarNote Added: 0021807
2009-11-13 11:49arunkumarStatusresolved => closed
2009-11-13 11:49arunkumarFixed in Version => 2.50MP9
2009-11-14 00:00anonymoussf_bug_id0 => 2897492

Notes
(0021550)
rafaroda   
2009-11-04 09:16   
Not able to reproduce the issue with these steps (see attached image). Can you please provide more information?

Thanks.
(0021603)
networkb   
2009-11-05 12:32   
What feedback do you need?
(0021606)
vmromanos   
2009-11-05 13:01   
Rafa said:
"Not able to reproduce the issue with these steps (see attached image). Can you please provide more information?"

It's clear the feedback I need
(0021607)
networkb   
2009-11-05 13:36   
Rafa could reproduce the bug.
(0021608)
rafaroda   
2009-11-05 13:49   
Víctor,

Finally the issue was reproducible, but just in PostgreSQL.

Please go ahead with its fix.

Thanks.
(0021792)
vmromanos   
2009-11-12 19:45   
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    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(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERROR: el operador no existe: character varying = integer
    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
306898 [http-8080-2] ERROR org.openbravo.erpCommon.ad_reports.ReportGeneralLedger - Error captured:
javax.servlet.ServletException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1123)
    at org.openbravo.erpCommon.ad_reports.ReportGeneralLedger.printPageDataPDF(ReportGeneralLedger.java:728)
    at org.openbravo.erpCommon.ad_reports.ReportGeneralLedger.doPost(ReportGeneralLedger.java:174)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:364)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    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:93)
    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:191)
    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:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    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: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1074)
    ... 29 more
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:642)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:344)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1382)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:591)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:524)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:253)
    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:1068)
    ... 29 more
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportGeneralLedger_Previous
    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)
    ... 1 more
Caused by: org.postgresql.util.PSQLException: ERROR: el operador no existe: character varying = integer
    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
(0021794)
hgbot   
2009-11-12 20:27   
Repository: erp/devel/pi
Changeset: adeb9642d39d1d6af29202a3dc8c90e5ede95296
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Nov 12 20:28:44 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/adeb9642d39d1d6af29202a3dc8c90e5ede95296 [^]

Fixed bug 11231: General Ledger Report, jasper error with business partners

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0021807)
arunkumar   
2009-11-13 11:49   
Tested & Working fine