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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0001722
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2007-08-04 22:232008-07-08 12:13
Reporteruser71View Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version2.40alpha-r2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0001722: 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


TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0003600 closedcromero Report Sales by partner and Product fails with S 

-  Notes
(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 (viewer)
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 (viewer)
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 (viewer)
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
(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 [^]

- Issue History
Date Modified Username Field Change
2008-07-08 12:13 psarobe Status resolved => closed
2009-12-18 15:59 iciordia Relationship added related to 0008991
2009-12-18 15:59 iciordia Relationship deleted related to 0008991

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker