Upgrade Guide › Upgrading from 12.5 › Dashboards › Historical Dashboard Data is Lost After Upgrade

Historical Dashboard Data is Lost After Upgrade

If you previously maintained long-term incident trend charts in your dashboard, you may lose some (possibly a significant amount) of the underlying historical data when you upgrade CA DataMinder.

Before CA DataMinder 14.0, incident trend charts in the dashboard were generated from database summary tables. Even if the actual events were purged from the CMS database, it was possible to retain aggregated data in these summary tables and thereby maintain long-term incident trend charts in the dashboard.

However, after you upgrade to the current version of CA DataMinder, these summary tables are no longer used. Instead, the incident trends charts are generated from tables in the data warehouse. The data warehouse is populated from the main event tables in the CMS database. Consequently, if you have already purged historical event data from the CMS, these older events cannot be populated into the data warehouse and so cannot be included in the incident trend charts.

Example

1. Your incident trend charts previously reflected events captured over the period 2008-2012. At the same time, you continually purged events older than 24 months from the CMS database.
2. You upgrade CA DataMinder in 2012. After the upgrade, the CMS only contains events captured since 2010.
3. When the new data warehouse gets populated with event data, it also only contains data for events captured since 2010.
4. Consequently, the new incident trend charts only show data for 2010-2012.