Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011231
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-11-03 18:272009-11-14 00:00
ReporternetworkbView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version2.50MP9
StatusclosedFix in branchpiFixed in SCM revisionadeb9642d39d
ProjectionnoneETAnoneTarget Version2.50MP9
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP8SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011231: 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.
TagsNo tags attached.
Attached Filespng file icon RGL.png [^] (117,679 bytes) 2009-11-04 09:16

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00112802.40MP11 closedvmromanos General Ledger group information for BP with same name 

-  Notes
(0021550)
rafaroda (viewer)
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 (viewer)
2009-11-05 12:32

 What feedback do you need?
(0021606)
vmromanos (viewer)
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 (viewer)
2009-11-05 13:36

 Rafa could reproduce the bug.
(0021608)
rafaroda (viewer)
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 (viewer)
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 (developer)
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 (viewer)
2009-11-13 11:49

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-11-03 18:27 networkb New Issue
2009-11-03 18:27 networkb Assigned To => rafaroda
2009-11-03 18:27 networkb OBNetwork customer => Yes
2009-11-04 09:16 rafaroda Note Added: 0021550
2009-11-04 09:16 rafaroda Status new => feedback
2009-11-04 09:16 rafaroda File Added: RGL.png
2009-11-04 09:47 rafaroda Assigned To rafaroda => vmromanos
2009-11-04 09:47 rafaroda Priority immediate => urgent
2009-11-04 09:47 rafaroda Status feedback => scheduled
2009-11-04 09:47 rafaroda Proposed Solution updated
2009-11-05 12:29 vmromanos Status scheduled => feedback
2009-11-05 12:32 networkb Note Added: 0021603
2009-11-05 13:01 vmromanos Note Added: 0021606
2009-11-05 13:36 networkb Note Added: 0021607
2009-11-05 13:36 networkb Status feedback => new
2009-11-05 13:49 rafaroda Status new => scheduled
2009-11-05 13:49 rafaroda Note Added: 0021608
2009-11-05 13:49 rafaroda fix_in_branch => pi
2009-11-12 19:38 vmromanos Relationship added blocks 0011280
2009-11-12 19:45 vmromanos Note Added: 0021792
2009-11-12 20:27 hgbot Checkin
2009-11-12 20:27 hgbot Note Added: 0021794
2009-11-12 20:27 hgbot Status scheduled => resolved
2009-11-12 20:27 hgbot Resolution open => fixed
2009-11-12 20:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/adeb9642d39d1d6af29202a3dc8c90e5ede95296 [^]
2009-11-13 11:49 arunkumar Note Added: 0021807
2009-11-13 11:49 arunkumar Status resolved => closed
2009-11-13 11:49 arunkumar Fixed in Version => 2.50MP9
2009-11-14 00:00 anonymous sf_bug_id 0 => 2897492

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker