Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043207Openbravo ERPA. Platformpublic2020-01-28 12:232020-02-13 12:06
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q4.2Fixed in Version3.0PR19Q4.2 
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
Summary0043207: 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.0PR19Q4.2
2020-02-13 09:29alostaleSeveritymajor => critical
2020-02-13 09:37hgbotCheckin
2020-02-13 09:37hgbotNote Added: 0117721
2020-02-13 09:37hgbotStatusscheduled => resolved
2020-02-13 09:37hgbotResolutionopen => fixed
2020-02-13 09:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1d19e9db807746db520f34f622102f6b2f7a1249 [^] => http://code.openbravo.com/erp/backports/3.0PR19Q4.2/rev/cdb34cc7e8ee8cb2fc503ff5546bdccee93443c4 [^]
2020-02-13 12:06caristuNote Added: 0117729
2020-02-13 12:06caristuStatusresolved => closed
2020-02-13 12:06caristuFixed in Version => 3.0PR19Q4.2

Notes
(0117721)
hgbot   
2020-02-13 09:37   
Repository: erp/backports/3.0PR19Q4.2
Changeset: cdb34cc7e8ee8cb2fc503ff5546bdccee93443c4
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.0PR19Q4.2/rev/cdb34cc7e8ee8cb2fc503ff5546bdccee93443c4 [^]

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