Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001722Openbravo ERPZ. Otherspublic2007-08-04 22:232008-07-08 12:13
Reporteruser71 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0001722: Report Sales by partner and Product fails with SQl error
DescriptionReceive the following error regardless of what choice is made in Report Sales by partner and Product:

***
Error executing SQL statement for : ReportSalesPartnerProduct
***

Tried all choices (excel, pdf and html)

This occurred very shortly after a fresh install of the most recent production version (2.33).

Environment is:
- Windows 2003 server standard edition
- Postgres 8.2.4
- Apache Tomcat 5.5.23
- Java 2 jdk 5
- Apache Ant 1.7.0


Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003600 closed cromero Report Sales by partner and Product fails with S 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-08 12:13psarobeStatusresolved => closed
2009-12-18 15:59iciordiaRelationship addedrelated to 0008991
2009-12-18 15:59iciordiaRelationship deletedrelated to 0008991

Notes
(0005311)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1767737 [^]
(0001693)
user71   
2007-08-05 21:19   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1835421
Originator: YES

postgresql.log event is:
2007-08-05 13:32:34 ERROR: function ad_column_identifier("unknown", numeric, character varying) does not exist at character 8
2007-08-05 13:32:34 HINT: No function matches the given name and argument types. You may need to add explicit type casts.
2007-08-05 13:32:34 STATEMENT: SELECT AD_COLUMN_IDENTIFIER('C_BPartner', C_BPARTNER_ID, $1) AS PARTNER, C_BPARTNER_ID, sum(GRANDTOTAL) AS GRANDTOTAL, count(C_BPARTNER_ID) AS ORDERNO
    FROM C_ORDER
    WHERE ISSOTRX = 'Y'
      AND DOCSTATUS IN ('CO', 'CL')
      AND C_ORDER.AD_CLIENT_ID IN (0,1000000)
    GROUP BY C_BPARTNER_ID
    ORDER BY ORDERNO DESC
(0001694)
cromero   
2007-10-19 12:35   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1500614
Originator: NO

Fixed.
File ReportSalesPartnerProduct.jrxml has been modified in order to add a needed cast for Postgre.

Carlos Romero
Openbravo Team
(0001695)
pjuvara   
2007-10-31 15:20   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1871571
Originator: NO

This problem still reproduces in 2.35
When I execute the report with HTML output, I get the following error:
Error:
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportSalesPartnerProduct_srpt

The PDF and Excel output create corrupted files.

This problem occurs in PostgreSQL but not in Oracle.

Environment: Acceptance Test 2.35
(0001696)
cromero   
2008-01-17 13:41   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1500614
Originator: NO

Fixed since revision 2031.
Also file ReportSalesPartnerProduct_srpt.jasper has been modified in order to add a needed cast for Postgre.

Carlos Romero
Openbravo Team