Service Operations Insight

Tech Tip: Future dates in CCC chart 

Oct 27, 2015 11:20 AM

ISSUE: CCC defaults to showing a 90 day period of future dates. Example error seen below.

 

 

CAUSE: Future dated data managed to get into the Data Manager Database. For example, CPU utilization metrics for Dec 1st 2015 are present in the database. When rollups are completed, the window is determined by going back 90 days from the latest date. Causing the entire window to be in the future.

 

image003.jpg

 

FIX: The incorrect data needs to be removed from the server_fact and server_virtual_fact tables to prevent the data from populating the rollup tables.  The purge function will remove the offending data. To ensure data is removed run the purge function for tomorrows date until the start date shown in CCC.

For example:

 

Purge.PNG

 

After running the purge rollups need to be run to reset the 90 date range for rollups.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.