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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008508
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-04-08 15:372009-05-14 16:46
ReporternetworkbView Statuspublic 
Assigned Tosathiyan 
PriorityimmediateResolutionfixedFixed in Version2.40MP4
StatusclosedFix in branch2.40Fixed in SCM revision23a0fe1664c0
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008508: 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'"/>
TagsNo tags attached.
Attached Files? file icon error screenshots.odt [^] (671,809 bytes) 2009-04-17 14:00
png file icon issue-8508.png [^] (41,518 bytes) 2009-04-20 12:10


png file icon AnalyseLink.png [^] (193,572 bytes) 2009-04-20 15:54

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0008507 closedsathiyan The analyze link of the report trial balance does not work in postgres 

-  Notes
(0015406)
sathiyan (reporter)
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 (reporter)
2009-04-20 15:53

The third screen shot shown the right one.
(0015461)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-04-08 15:42 rafaroda Type defect => backport
2009-04-08 15:42 rafaroda fix_in_branch => 2.40
2009-04-17 14:00 sathiyan File Added: error screenshots.odt
2009-04-17 14:00 sathiyan Note Added: 0015406
2009-04-20 12:10 sathiyan File Added: issue-8508.png
2009-04-20 15:53 sathiyan Note Added: 0015441
2009-04-20 15:54 sathiyan File Added: AnalyseLink.png
2009-04-21 06:26 hgbot Checkin
2009-04-21 06:26 hgbot Note Added: 0015461
2009-04-21 06:26 hgbot Status scheduled => resolved
2009-04-21 06:26 hgbot Resolution open => fixed
2009-04-21 06:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/23a0fe1664c016f1c87de0fcabe5371d0f769cc8 [^]
2009-05-10 19:37 psarobe Fixed in Version => 2.40MP4
2009-05-14 16:46 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker