Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042153Openbravo ERPA. Platformpublic2019-10-30 14:042019-12-12 23:01
ReporterALopetegui 
Assigned Toalostale 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q1 
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
Summary0042153: 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
related to defect 0035268 closed jarmendariz Request timeout message is not handled properly in the UI 
depends on backport 00421613.0PR19Q4 closed alostale Grid timeout returns unclear message in the backoffice 
depends on backport 00421623.0PR19Q3.2 closed alostale Grid timeout returns unclear message in the backoffice 
depends on backport 00421633.0PR19Q2.4 closed alostale Grid timeout returns unclear message in the backoffice 
caused by feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
Attached Filesjpg Message.jpg (30,574) 2019-10-30 14:04
https://issues.openbravo.com/file_download.php?file_id=13464&type=bug
jpg

? gridTiemoutlog (12,718) 2019-10-30 14:05
https://issues.openbravo.com/file_download.php?file_id=13465&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-10-30 14:04ALopeteguiNew Issue
2019-10-30 14:04ALopeteguiAssigned To => platform
2019-10-30 14:04ALopeteguiFile Added: Message.jpg
2019-10-30 14:04ALopeteguiModules => Core
2019-10-30 14:04ALopeteguiRegression level => Production - Confirmed Stable
2019-10-30 14:04ALopeteguiRegression date => 2019-01-01
2019-10-30 14:04ALopeteguiRegression introduced in release => 3.0PR19Q1
2019-10-30 14:04ALopeteguiTriggers an Emergency Pack => No
2019-10-30 14:05ALopeteguiFile Added: gridTiemoutlog
2019-10-31 08:00alostaleRelationship addedrelated to 0035268
2019-10-31 08:45alostaleAssigned Toplatform => alostale
2019-10-31 09:08alostaleRelationship addedcaused by 0037064
2019-10-31 09:10alostaleRegression date2019-01-01 => 2018-07-24
2019-10-31 09:10alostaleRegression introduced in release3.0PR19Q1 => 3.0PR18Q4
2019-10-31 09:10alostaleRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
2019-10-31 09:10alostalePrioritynormal => immediate
2019-10-31 09:10alostaleSummaryGrid timeout returns unclear message in the backend => Grid timeout returns unclear message in the backoffice
2019-10-31 09:10alostaleReview Assigned To => AugustoMauch
2019-10-31 09:11alostaleStatusnew => scheduled
2019-11-05 09:01hgbotCheckin
2019-11-05 09:01hgbotNote Added: 0115398
2019-11-05 09:01hgbotStatusscheduled => resolved
2019-11-05 09:01hgbotResolutionopen => fixed
2019-11-05 09:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b67ca267208bac298155eeae1f9c862c8ac6548a [^]
2019-11-05 15:43AugustoMauchNote Added: 0115416
2019-11-05 15:43AugustoMauchStatusresolved => closed
2019-11-05 15:43AugustoMauchFixed in Version => 3.0PR20Q1
2019-12-12 23:01hudsonbotCheckin
2019-12-12 23:01hudsonbotNote Added: 0116271

Notes
(0115398)
hgbot   
2019-11-05 09:01   
Repository: erp/devel/pi
Changeset: b67ca267208bac298155eeae1f9c862c8ac6548a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Oct 31 09:05:28 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b67ca267208bac298155eeae1f9c862c8ac6548a [^]

fixed bug 42153: 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
---
(0115416)
AugustoMauch   
2019-11-05 15:43   
Code reviewed and verified
(0116271)
hudsonbot   
2019-12-12 23:01   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/954d2b7a66fb [^]
Maturity status: Test