Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042161Openbravo ERPA. Platformpublic2019-10-30 14:042019-11-05 10:08
ReporterALopetegui 
Assigned Toalostale 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q4Fixed in Version3.0PR19Q4 
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
Summary0042161: 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.0PR19Q4
2019-11-05 09:21hgbotCheckin
2019-11-05 09:21hgbotNote Added: 0115401
2019-11-05 09:21hgbotStatusscheduled => resolved
2019-11-05 09:21hgbotResolutionopen => fixed
2019-11-05 09:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q4/rev/1fb0e69076add0d20c59cac83407c40f49ecaf3a [^]
2019-11-05 10:08AugustoMauchNote Added: 0115404
2019-11-05 10:08AugustoMauchStatusresolved => closed
2019-11-05 10:08AugustoMauchFixed in Version => 3.0PR19Q4

Notes
(0115401)
hgbot   
2019-11-05 09:21   
Repository: erp/backports/3.0PR19Q4
Changeset: 1fb0e69076add0d20c59cac83407c40f49ecaf3a
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.0PR19Q4/rev/1fb0e69076add0d20c59cac83407c40f49ecaf3a [^]

fixed bug 42161: 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
---
(0115404)
AugustoMauch   
2019-11-05 10:08   
Code reviewed and verified