Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042162Openbravo ERPA. Platformpublic2019-10-30 14:042019-11-05 10:27
ReporterALopetegui 
Assigned Toalostale 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q3.2Fixed in Version3.0PR19Q3.2 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2018-07-24
Regression introduced in release3.0PR18Q4
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
Triggers an Emergency PackNo
Summary0042162: Grid timeout returns unclear message in the backoffice
DescriptionThe grid timeout returns unclear message to the user:

org.hibernate.exception.GenericJDBCException: could not extract ResultSet
Steps To ReproduceDefine low value to db.queryTimeout.grid in Openbravo.properties.

Open a window in the backend and filter the window to provoke a timeout.

The grid shows the unclear message.
Proposed SolutionHandle the hibernate exception to show better message to the user.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0042153 closed alostale Grid timeout returns unclear message in the backoffice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-10-31 09:11alostaleTypedefect => backport
2019-10-31 09:11alostaleTarget Version => 3.0PR19Q3.2
2019-11-05 09:13hgbotCheckin
2019-11-05 09:13hgbotNote Added: 0115399
2019-11-05 09:13hgbotStatusscheduled => resolved
2019-11-05 09:13hgbotResolutionopen => fixed
2019-11-05 09:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q3.2/rev/23a72ef4e19bfb5b37556112664dcdcb650bafad [^]
2019-11-05 10:27AugustoMauchNote Added: 0115408
2019-11-05 10:27AugustoMauchStatusresolved => closed
2019-11-05 10:27AugustoMauchFixed in Version => 3.0PR19Q3.2

Notes
(0115399)
hgbot   
2019-11-05 09:13   
Repository: erp/backports/3.0PR19Q3.2
Changeset: 23a72ef4e19bfb5b37556112664dcdcb650bafad
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Oct 31 09:05:28 2019 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR19Q3.2/rev/23a72ef4e19bfb5b37556112664dcdcb650bafad [^]

fixed bug 42162: grid timeout returns unclear message

When a query timeout occurs fetching grid data, the message displayed in
UI is not user friendly.

This is caused by different exception thrown after Hibernate upgrade.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/JsonUtils.java
---
(0115408)
AugustoMauch   
2019-11-05 10:27   
Code reviewed and verified