Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008508 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2009-04-08 15:37 | 2009-05-14 16:46 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | sathiyan | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40MP4 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 23a0fe1664c0 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP3 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008508: The analyze link of the report trial balance does not work in postgres | |||||||
| Description | The 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 Solution | Modify 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'"/> | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  error screenshots.odt [^] (671,809 bytes) 2009-04-17 14:00 issue-8508.png [^] (41,518 bytes) 2009-04-20 12:10
AnalyseLink.png [^] (193,572 bytes) 2009-04-20 15:54
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015406) sathiyan (viewer) 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 (viewer) 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 --- |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |