Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043208Openbravo ERPA. Platformpublic2020-01-28 12:232020-02-13 12:07
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q3.4Fixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0043208: export to csv doesn't timeout
DescriptionHaving db.queryTimeout.grid configured, queries to generate CSV don't timeout.
Steps To Reproduce1. define db.queryTimeout.grid=1
2. export a csv that takes more than 1 sec to generate the query
Proposed SolutionApply db.queryTimeout.grid to csv export.

Note that ideally, UI should notify about this error.

Note DefaultJsonDataService.fetch(Map<String, String> parameters, QueryResultWriter writer) method is also used by JSON webservices.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0043029 closed alostale export to csv doesn't timeout 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-02-13 09:27alostaleTypedefect => backport
2020-02-13 09:27alostaleTarget Version => 3.0PR19Q3.4
2020-02-13 09:29alostaleSeveritymajor => critical
2020-02-13 09:36hgbotCheckin
2020-02-13 09:36hgbotNote Added: 0117720
2020-02-13 09:36hgbotStatusscheduled => resolved
2020-02-13 09:36hgbotResolutionopen => fixed
2020-02-13 09:36hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1d19e9db807746db520f34f622102f6b2f7a1249 [^] => http://code.openbravo.com/erp/backports/3.0PR19Q3.4/rev/172a5b62f0d0bf62306b03f84222df5ec05583c9 [^]
2020-02-13 12:07caristuNote Added: 0117730
2020-02-13 12:07caristuStatusresolved => closed

Notes
(0117720)
hgbot   
2020-02-13 09:36   
Repository: erp/backports/3.0PR19Q3.4
Changeset: 172a5b62f0d0bf62306b03f84222df5ec05583c9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jan 28 13:25:57 2020 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR19Q3.4/rev/172a5b62f0d0bf62306b03f84222df5ec05583c9 [^]

fixed BUG-43208: export to csv doesn't timeout

  Apply grid timeout to CSV export.

  Moved timeout profile setting to a more generic part, before it was
  applied only for the query to populate the grid, but it should be for
  every one.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java
---
(0117730)
caristu   
2020-02-13 12:07   
Reviewed