Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008507Openbravo ERP09. Financial managementpublic2009-04-08 15:372009-04-25 00:00
Reporternetworkb 
Assigned Tosathiyan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP3 
Target VersionFixed in Version2.50MP1 
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
Summary0008507: The analyze link of the report trial balance does not work in postgres
DescriptionThe analyze link of the report trial balance does not work in postgres.
You get an error that says.
ERROR: operator does not exist: character varying = numeric

It happens because the query that is built when the ReportAccountingCountDimensionalAnalysesData is executed is incorrect to postgresql. It tries to compare a char with a number.

Steps To Reproduce-Execute the trial balance report
-Click on anal. link
-You get the error
Proposed SolutionModify the ReportAccountingCountDimensionalAnalyses_data.xsql file in the next way:

All the conditions like following:

WHERE A.ID = '1'
should be
WHERE A.ID = TO_CHAR('1')

*There are many with differents chars ('1','8',...)

Then modify the parameter
    <Parameter name="idtableDimension" type="replace" optional="true" after="WHERE A.ID = " text="'1'"/>

with the following:

    <Parameter name="idtableDimension" type="replace" optional="true" after="WHERE A.ID = TO_CHAR(" text="'1'"/>
Additional Information
Tagsmain
Relationships
depends on backport 0008508 closed sathiyan The analyze link of the report trial balance does not work in postgres 
Attached Files? error screenshots.odt (671,809) 2009-04-08 17:34
https://issues.openbravo.com/file_download.php?file_id=1151&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 15:37networkbNew Issue
2009-04-08 15:37networkbAssigned To => rafaroda
2009-04-08 15:37networkbOBNetwork customer => Yes
2009-04-08 15:37networkbRegression testing => No
2009-04-08 15:42rafarodaAssigned Torafaroda => sathiyan
2009-04-08 15:42rafarodaStatusnew => scheduled
2009-04-08 15:42rafarodafix_in_branch => pi
2009-04-08 17:34sathiyanFile Added: error screenshots.odt
2009-04-08 17:37sathiyanNote Added: 0015293
2009-04-21 13:36hgbotCheckin
2009-04-21 13:36hgbotNote Added: 0015477
2009-04-21 13:36hgbotStatusscheduled => resolved
2009-04-21 13:36hgbotResolutionopen => fixed
2009-04-21 13:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9d153730ba917f8d82c3b1bffdc8918418bbf92c [^]
2009-04-22 11:23psarobeTag Attached: main
2009-04-24 12:50psarobeStatusresolved => closed
2009-04-25 00:00anonymoussf_bug_id0 => 2780824

Notes
(0015293)
sathiyan   
2009-04-08 17:37   
We will have some of the other errors in the screen. I have attached screen shots about other errors in different scenario in the same screen. It also should be fixed part of this issue.
(0015477)
hgbot   
2009-04-21 13:36   
Repository: erp/devel/pi
Changeset: 9d153730ba917f8d82c3b1bffdc8918418bbf92c
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Tue Apr 21 17:05:01 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9d153730ba917f8d82c3b1bffdc8918418bbf92c [^]

Fixes bug 8507 The analyze link of the report in trial balance does not work in postgres. It has been fixed.

---
M src-core/src/org/openbravo/xmlEngine/FunctionModuleValue.java
M src/org/openbravo/erpCommon/ad_reports/ReportAccountingCountDimensionalAnalyses.java
M src/org/openbravo/erpCommon/ad_reports/ReportAccountingCountDimensionalAnalyses_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail.java
---