I had a support call (w#81479) with SW because my volume and CPU details to hourly process in database maintenance was no longer updating the tables. In the logs we had errors saying there was duplicate data. The data in the cpuload_hourly and volumeusage hourly tables was expendable, so support had me truncate the two tables, as well as the daily tables.
However, I have now discovered that the cpuload_detail and volumeusage_detail tables were also cleared, yet they were not truncated. And no, we did not back up the database (would have been a good suggestion by SW support). My volumedetail table size went from 45MB to 4MB, and my cpuloaddetail table went from 13MB to 2MB.
Is there some reason why the detail tables would get impacted when the hourly and daily tables get truncated?
