Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008507 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-04-08 15:37 | 2009-04-25 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | sathiyan | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 9d153730ba91 | |||
| 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 | 0008507: 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 | main | |||||||
| Attached Files |  error screenshots.odt [^] (671,809 bytes) 2009-04-08 17:34 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015293) sathiyan (viewer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-08 15:37 | networkb | New Issue | |
| 2009-04-08 15:37 | networkb | Assigned To | => rafaroda |
| 2009-04-08 15:37 | networkb | OBNetwork customer | => Yes |
| 2009-04-08 15:37 | networkb | Regression testing | => No |
| 2009-04-08 15:42 | rafaroda | Assigned To | rafaroda => sathiyan |
| 2009-04-08 15:42 | rafaroda | Status | new => scheduled |
| 2009-04-08 15:42 | rafaroda | fix_in_branch | => pi |
| 2009-04-08 17:34 | sathiyan | File Added: error screenshots.odt | |
| 2009-04-08 17:37 | sathiyan | Note Added: 0015293 | |
| 2009-04-21 13:36 | hgbot | Checkin | |
| 2009-04-21 13:36 | hgbot | Note Added: 0015477 | |
| 2009-04-21 13:36 | hgbot | Status | scheduled => resolved |
| 2009-04-21 13:36 | hgbot | Resolution | open => fixed |
| 2009-04-21 13:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9d153730ba917f8d82c3b1bffdc8918418bbf92c [^] |
| 2009-04-22 11:23 | psarobe | Tag Attached: main | |
| 2009-04-24 12:50 | psarobe | Status | resolved => closed |
| 2009-04-25 00:00 | anonymous | sf_bug_id | 0 => 2780824 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |