Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010716Openbravo ERPA. Platformpublic2009-09-23 15:392009-10-12 09:33
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP10 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010716: On SQL error when using ComboTableData on postgres only error message is '0' instead of the real database error
DescriptionThe 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 Reproduce1.) 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 SolutionFix 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.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0010715 closed shuehner On SQL error when using ComboTableData on postgres only error message is '0' instead of the real database error 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-23 15:40shuehnerTypedefect => backport
2009-09-23 15:40shuehnerfix_in_branch => 2.40
2009-09-23 15:53hgbotCheckin
2009-09-23 15:53hgbotNote Added: 0020317
2009-09-23 15:53hgbotStatusscheduled => resolved
2009-09-23 15:53hgbotResolutionopen => fixed
2009-09-23 15:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020443
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]
2009-10-12 09:33arunkumarStatusresolved => closed
2009-10-12 09:33arunkumarNote Added: 0020938
2009-10-12 09:33arunkumarFixed in Version => 2.40MP10

Notes
(0020317)
hgbot   
2009-09-23 15:53   
Repository: erp/stable/2.40
Changeset: b992831aebc19f79e0afe61e203c6d72db2c4b67
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Sep 23 15:52:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]

Fixed 10716: Fix error reporting in ComboTableData, don't throw away error text

---
M src/org/openbravo/erpCommon/utility/ComboTableData.java
---
(0020443)
hgbot   
2009-09-29 12:02   
Repository: erp/stable/2.40_pageddatagrid
Changeset: b992831aebc19f79e0afe61e203c6d72db2c4b67
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Sep 23 15:52:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]

Fixed 10716: Fix error reporting in ComboTableData, don't throw away error text

---
M src/org/openbravo/erpCommon/utility/ComboTableData.java
---
(0020938)
arunkumar   
2009-10-12 09:33   
Now the error message is displayed as Error:
java.lang.Exception: CODE=0ERROR: syntax error at or near "SELECT"