Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010715 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-09-23 15:39 | 2009-10-17 00:00 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 7c302cdb1c7f | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010715: On SQL error when using ComboTableData on postgres only error message is '0' instead of the real database error | |||||||
| Description | The error reporting code inside ComboTableData does throw away the error message text and only keep the error code number. This lead to completely useless errror message shown to the user. | |||||||
| Steps To Reproduce | 1.) Produce an sql error in some sql executes by ComboTableData update ad_ref_table set whereclause = 'XISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep=\'Y\')' where ad_reference_id = 190; 2.) Login as openbravo admin 3.) Go to masterdata management -> Product 4.) Error message 'Error: 0' (on postgres) is shown | |||||||
| Proposed Solution | Fix ComboTableData to not throw away the database provided error message. This is not perfect but provides (depending on the real sql error) more info to report in a support ticket. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0020315) shuehner (administrator) 2009-09-23 15:39 |
Note the steps to reproduce contain an artificial testcase just to reproduce an error here. The real error came up when testing the patch attached to issue 10318. |
|
(0020316) hgbot (developer) 2009-09-23 15:51 |
Repository: erp/devel/pi Changeset: 7c302cdb1c7fb0dffc75218fdc78c4981f71b14e Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed Sep 23 15:50:13 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/7c302cdb1c7fb0dffc75218fdc78c4981f71b14e [^] Fixed 10715: Fix error reporting in ComboTableData, don't throw away error text --- M src/org/openbravo/erpCommon/utility/ComboTableData.java --- |
|
(0020507) hgbot (developer) 2009-09-29 14:17 |
Repository: erp/devel/pi-pageddatagrid Changeset: 7c302cdb1c7fb0dffc75218fdc78c4981f71b14e Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed Sep 23 15:50:13 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7c302cdb1c7fb0dffc75218fdc78c4981f71b14e [^] Fixed 10715: Fix error reporting in ComboTableData, don't throw away error text --- M src/org/openbravo/erpCommon/utility/ComboTableData.java --- |
|
(0021105) marvintm (viewer) 2009-10-16 12:43 |
I followed the steps to reproduce the problem, and I got the new, improved message. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-23 15:39 | shuehner | New Issue | |
| 2009-09-23 15:39 | shuehner | Assigned To | => shuehner |
| 2009-09-23 15:39 | shuehner | OBNetwork customer | => No |
| 2009-09-23 15:39 | shuehner | Note Added: 0020315 | |
| 2009-09-23 15:39 | shuehner | Relationship added | related to 0010318 |
| 2009-09-23 15:40 | shuehner | Status | new => scheduled |
| 2009-09-23 15:40 | shuehner | fix_in_branch | => pi |
| 2009-09-23 15:40 | shuehner | Relationship added | related to 0010344 |
| 2009-09-23 15:40 | shuehner | Relationship deleted | related to 0010318 |
| 2009-09-23 15:51 | hgbot | Checkin | |
| 2009-09-23 15:51 | hgbot | Note Added: 0020316 | |
| 2009-09-23 15:51 | hgbot | Status | scheduled => resolved |
| 2009-09-23 15:51 | hgbot | Resolution | open => fixed |
| 2009-09-23 15:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7c302cdb1c7fb0dffc75218fdc78c4981f71b14e [^] |
| 2009-09-23 16:12 | psarobe | Tag Attached: 250mp6 | |
| 2009-09-24 19:12 | psarobe | Tag Detached: 250mp6 | |
| 2009-09-29 14:17 | hgbot | Checkin | |
| 2009-09-29 14:17 | hgbot | Note Added: 0020507 | |
| 2009-09-29 14:17 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/7c302cdb1c7fb0dffc75218fdc78c4981f71b14e [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/7c302cdb1c7fb0dffc75218fdc78c4981f71b14e [^] |
| 2009-10-16 12:43 | marvintm | Status | resolved => closed |
| 2009-10-16 12:43 | marvintm | Note Added: 0021105 | |
| 2009-10-17 00:00 | anonymous | sf_bug_id | 0 => 2880776 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |