Missing data updates
![]()
We are running DCC 6.0.1 (iFix 04). Over the past month we have been getting reports that the data in the DCC updated Data Warehouse is not current. We are able to confirm the data in RTC/RQM is different from the Data Warehouse.
Over the months we have had performance issues, and have killed tasks along the way or had the RTC/RQM application server drop for various reasons. based on the identified invalid data it does appear to occur in similar time frames. Two Questions: - What is the best way to ensure the Data Warehouse is current with out rebuilding the whole data warehouse from scratch? We have been making individual changes to the master application data (adding a tag for example) and this seems to fix that one. We are thinking of resetting the time to February and running the ODS/DM tasks. - If we have to kill tasks in the future, what is the recommended method to recover? He have adopted setting the date to today (or the day of the failure) and letting ODS/DM run. |
One answer
![]()
Hi Gene,
If your DW is not up to date, but you don't want to rebuild it entirely, then setting up a specific date for the delta ETL would be the right work around. Keep in mind though, that the data mart data does not get reprocessed. If you run the data mart jobs today, all the totals would be stored as today's totals. If you run it again tomorrow, after setting a previous date for the delta ETL, the totals would be stored as tomorrow's totals. I think a more important question would be, why do you have to kill data collection tasks? I would recommend that you contact IBM Support so they can help you look into the issue and avoid future data loss. Thank you, Clara Forero Comments Thanks - What is the impact of the data being stored for various days totals? Could a change from a week ago appear as if it occurred today?
Hi Gene,
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.