Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008508Openbravo ERP09. Financial managementpublic2009-04-08 15:372009-05-14 16:46
Reporternetworkb 
Assigned Tosathiyan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP3 
Target VersionFixed in Version2.40MP4 
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
Summary0008508: 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
TagsNo tags attached.
Relationships
blocks defect 0008507 closed sathiyan The analyze link of the report trial balance does not work in postgres 
Attached Files? error screenshots.odt (671,809) 2009-04-17 14:00
https://issues.openbravo.com/file_download.php?file_id=1191&type=bug
png issue-8508.png (41,518) 2009-04-20 12:10
https://issues.openbravo.com/file_download.php?file_id=1197&type=bug
png

png AnalyseLink.png (193,572) 2009-04-20 15:54
https://issues.openbravo.com/file_download.php?file_id=1198&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 15:42rafarodaTypedefect => backport
2009-04-08 15:42rafarodafix_in_branch => 2.40
2009-04-17 14:00sathiyanFile Added: error screenshots.odt
2009-04-17 14:00sathiyanNote Added: 0015406
2009-04-20 12:10sathiyanFile Added: issue-8508.png
2009-04-20 15:53sathiyanNote Added: 0015441
2009-04-20 15:54sathiyanFile Added: AnalyseLink.png
2009-04-21 06:26hgbotCheckin
2009-04-21 06:26hgbotNote Added: 0015461
2009-04-21 06:26hgbotStatusscheduled => resolved
2009-04-21 06:26hgbotResolutionopen => fixed
2009-04-21 06:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/23a0fe1664c016f1c87de0fcabe5371d0f769cc8 [^]
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-14 16:46psarobeStatusresolved => closed

Notes
(0015406)
sathiyan   
2009-04-17 14:00   
I am not able to reproduce the reported issue. However We 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.
(0015441)
sathiyan   
2009-04-20 15:53   
The third screen shot shown the right one.
(0015461)
hgbot   
2009-04-21 06:26   
Repository: erp/stable/2.40
Changeset: 23a0fe1664c016f1c87de0fcabe5371d0f769cc8
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Tue Apr 21 09:54:04 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/23a0fe1664c016f1c87de0fcabe5371d0f769cc8 [^]

Fixes bug 8508 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
---