Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053455ModulesReportingpublic2023-09-13 17:292024-07-05 15:40
Reportertonialcaide 
Assigned Totonialcaide 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0053455: Replace the obrts_order_data_mv with a table obrts_order_data in reporting db
DescriptionToday we have the materialized view obrts_order_data_mv that is taking a lot of time to refresh (more than 1 hour in Norauto), and it is constantly failing to refresh in the morning.

Please migrate its data into a table, and create the sql associated to the dataload that will update/charge the new data in the table, filtering by the dateFrom, dateTo parameter, others if you think needed.
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-09-13 17:29tonialcaideNew Issue
2023-09-13 17:29tonialcaideAssigned To => tonialcaide
2023-09-13 17:33hgbotNote Added: 0154822
2023-11-29 15:06hgbotNote Added: 0157804
2024-01-06 21:37hgbotNote Added: 0158902
2024-02-06 10:49hgbotNote Added: 0160289
2024-02-06 10:49hgbotNote Added: 0160290
2024-03-15 12:36hgbotNote Added: 0162229
2024-03-18 17:00hgbotNote Added: 0162304
2024-07-05 15:40hgbotNote Added: 0166756

Notes
(0154822)
hgbot   
2023-09-13 17:33   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/47 [^]
(0157804)
hgbot   
2023-11-29 15:06   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/23 [^]
(0158902)
hgbot   
2024-01-06 21:37   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/47 [^]
(0160289)
hgbot   
2024-02-06 10:49   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools [^]
Changeset: d9a3d59db0d803136c0091b4726c7652b620c381
Author: Ludmila Ursu <l.ursu@orisha.com>
Date: 06-02-2024 09:49:52
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/commit/d9a3d59db0d803136c0091b4726c7652b620c381 [^]

Relates to ISSUE-53455: Modified the StandardReportingDataLoader.java, to not use the same connection for saving and reading

---
M src/org/openbravo/reporting/tools/dataloader/StandardReportingDataLoader.java
---
(0160290)
hgbot   
2024-02-06 10:49   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/23 [^]
(0162229)
hgbot   
2024-03-15 12:36   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/26 [^]
(0162304)
hgbot   
2024-03-18 17:00   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/26 [^]
(0166756)
hgbot   
2024-07-05 15:40   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/47 [^]