Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005211Openbravo ERP09. Financial managementpublic2008-09-23 17:422008-12-03 12:33
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
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
Summary0005211: 'Invoice Taxes Report' does not work in PostgreSQL due to UUID
Description'Invoice Taxes Report' stopped to work in PostgreSQL due to UUID with error message:

14:08:42 [http-8386-Processor22] ERROR net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 13349923: exception
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportTaxInvoiceSale
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:616)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:605)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:891)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:716)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:522)
    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:595)
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
    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)
    ... 10 more
14:08:42 [http-8386-Processor22] ERROR org.openbravo.erpCommon.ad_reports.ReportTaxInvoiceJR - Error captured: javax.servlet.ServletException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportTaxInvoiceSale
Steps To Reproduce1) Using PostgreSQL, launch 'Invoice Taxes Report' report (Financial Management || Receivables & Payables || Analysis Tools || Invoice Taxes Report)
Proposed Solution
Additional Information
TagsUUID project
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 17:42rafarodaNew Issue
2008-09-23 17:42rafarodaAssigned To => rafaroda
2008-09-23 17:42rafarodasf_bug_id0 => 2124796
2008-09-23 17:42rafarodaRegression testing => No
2008-09-23 17:42rafarodaTag Attached: UUID project
2008-09-23 17:43rafarodaStatusnew => scheduled
2008-09-23 17:43rafarodafix_in_branch => trunk
2008-09-29 12:28svnbotCheckin
2008-09-29 12:28svnbotNote Added: 0009247
2008-09-29 12:28svnbotStatusscheduled => resolved
2008-09-29 12:28svnbotResolutionopen => fixed
2008-09-29 12:28svnbotsvn_revision => 8028
2008-12-03 12:33krishnaStatusresolved => closed

Notes
(0009247)
svnbot   
2008-09-29 12:28   
Repository: openbravo
Revision: 8028
Author: rafaroda
Date: 2008-09-29 12:27:59 +0200 (Mon, 29 Sep 2008)

Fixes bug 0005211 Converted 'cCounrtyId' parameter to 'String' in 'ReportTaxInvoice' reports.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8028&sc=1 [^]