Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0053455 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Modules] Reporting | minor | have not tried | 2023-09-13 17:29 | 2024-07-05 15:40 | |||||||
Reporter | tonialcaide | View Status | public | |||||||||
Assigned To | tonialcaide | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM 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 | |||||||||||
Description | Today 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 Reproduce | N/A | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
![]() |
|
![]() |
|||
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 | |
2024-07-05 15:40 | hgbot | Note Added: 0166756 |
Copyright © 2000 - 2009 MantisBT Group |