Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043206Openbravo ERPA. Platformpublic2020-01-28 12:232020-02-13 12:06
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR20Q1Fixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0043206: 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.0PR20Q1
2020-02-13 09:29alostaleSeveritymajor => critical
2020-02-13 09:39hgbotCheckin
2020-02-13 09:39hgbotNote Added: 0117722
2020-02-13 09:39hgbotStatusscheduled => resolved
2020-02-13 09:39hgbotResolutionopen => fixed
2020-02-13 09:39hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1d19e9db807746db520f34f622102f6b2f7a1249 [^] => http://code.openbravo.com/erp/backports/3.0PR20Q1/rev/09ba2d7b1341a4738f0bf691619fa34ec7298735 [^]
2020-02-13 12:06caristuNote Added: 0117728
2020-02-13 12:06caristuStatusresolved => closed
2020-02-13 12:06caristuFixed in Version => 3.0PR20Q1

Notes
(0117722)
hgbot   
2020-02-13 09:39   
Repository: erp/backports/3.0PR20Q1
Changeset: 09ba2d7b1341a4738f0bf691619fa34ec7298735
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.0PR20Q1/rev/09ba2d7b1341a4738f0bf691619fa34ec7298735 [^]

fixed BUG-43206: 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
---
(0117728)
caristu   
2020-02-13 12:06   
Reviewed