Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042163Openbravo ERPA. Platformpublic2019-10-30 14:042019-11-05 11:00
ReporterALopetegui 
Assigned Toalostale 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q2.4Fixed in Version 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
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
Summary0042163: 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.0PR19Q2.4
2019-11-05 09:16hgbotCheckin
2019-11-05 09:16hgbotNote Added: 0115400
2019-11-05 09:16hgbotStatusscheduled => resolved
2019-11-05 09:16hgbotResolutionopen => fixed
2019-11-05 09:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q2.4/rev/d65560d0a983a400bb7235263d74ca7acdfc8e76 [^]
2019-11-05 11:00AugustoMauchNote Added: 0115410
2019-11-05 11:00AugustoMauchStatusresolved => closed

Notes
(0115400)
hgbot   
2019-11-05 09:16   
Repository: erp/backports/3.0PR19Q2.4
Changeset: d65560d0a983a400bb7235263d74ca7acdfc8e76
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.0PR19Q2.4/rev/d65560d0a983a400bb7235263d74ca7acdfc8e76 [^]

fixed bug 42163: 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
---
(0115410)
AugustoMauch   
2019-11-05 11:00   
Code reviewed and verified