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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010716
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorhave not tried2009-09-23 15:392009-10-12 09:33
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.40MP10
StatusclosedFix in branch2.40Fixed in SCM revisionb992831aebc1
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
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
Summary

0010716: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0010715 closedshuehner On SQL error when using ComboTableData on postgres only error message is '0' instead of the real database error 

-  Notes
(0020317)
hgbot (developer)
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 (developer)
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 (viewer)
2009-10-12 09:33

 Now the error message is displayed as Error:
java.lang.Exception: CODE=0ERROR: syntax error at or near "SELECT"

- Issue History
Date Modified Username Field Change
2009-09-23 15:40 shuehner Type defect => backport
2009-09-23 15:40 shuehner fix_in_branch => 2.40
2009-09-23 15:53 hgbot Checkin
2009-09-23 15:53 hgbot Note Added: 0020317
2009-09-23 15:53 hgbot Status scheduled => resolved
2009-09-23 15:53 hgbot Resolution open => fixed
2009-09-23 15:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]
2009-09-29 12:02 hgbot Checkin
2009-09-29 12:02 hgbot Note Added: 0020443
2009-09-29 12:02 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/b992831aebc19f79e0afe61e203c6d72db2c4b67 [^]
2009-10-12 09:33 arunkumar Status resolved => closed
2009-10-12 09:33 arunkumar Note Added: 0020938
2009-10-12 09:33 arunkumar Fixed in Version => 2.40MP10

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker