Since upgrading from 2.0.2 to 2.5 we can only access one days worth of stats on our 4 hosts (2 are 3.0.2 and 2 are 3.5) through the VC performance tab, if you try to access the host directly via VC there are no stats available there either, only the past 18hrs or so. If you look at anything older through VC you get the message "Performance data is currently not available for this entity". My DBA has confirmed that only the VPX_Hist_stat1 has any data in it, the other 3 vpx_hist_stat tables are empty, so are the vpx_sample tables. We tried truncating all these tables with VC down on the recommendation of support but that didn't resolve the issue. From what we can tell we no longer see the rollup running. I cannot find much info on the rollup procedures, I'm trying to find out how they work: where they are located, what kicks them off and what they are actually doing. Note: We are on Oracle. BTW, during the upgrade to VC 2.5 we had issues upgrading the DB, we ran out of space in the undo tablespace, it was quite an ordeal and support ended up having me upgrade the DB manually than re-running the VC upgrade.
Any help would be greatly appreciated, we've been fighting with this for a few days now and my boss is hot for some reports. I'm on the verge of suggesting a full clean install of VC with a new DB.
