Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0053455
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Reportingminorhave not tried2023-09-13 17:292024-03-18 17:00
ReportertonialcaideView Statuspublic 
Assigned Totonialcaide 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0053455: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0154822)
hgbot (developer)
2023-09-13 17:33

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/47 [^]
(0157804)
hgbot (developer)
2023-11-29 15:06

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/23 [^]
(0158902)
hgbot (developer)
2024-01-06 21:37

 Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/47 [^]
(0160289)
hgbot (developer)
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 (developer)
2024-02-06 10:49

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/23 [^]
(0162229)
hgbot (developer)
2024-03-15 12:36

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/26 [^]
(0162304)
hgbot (developer)
2024-03-18 17:00

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/26 [^]

- Issue History
Date Modified Username Field Change
2023-09-13 17:29 tonialcaide New Issue
2023-09-13 17:29 tonialcaide Assigned To => tonialcaide
2023-09-13 17:33 hgbot Note Added: 0154822
2023-11-29 15:06 hgbot Note Added: 0157804
2024-01-06 21:37 hgbot Note Added: 0158902
2024-02-06 10:49 hgbot Note Added: 0160289
2024-02-06 10:49 hgbot Note Added: 0160290
2024-03-15 12:36 hgbot Note Added: 0162229
2024-03-18 17:00 hgbot Note Added: 0162304

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker