Solved

Health Report

  • 22 February 2021
  • 4 replies
  • 42 views

Badge +1

Hi All;

On the Health report I see warning link below.

Scale Statistics -> "The CommServe database tables are too large. But this is quite fresh instalation.

In more detailes I see that problem is with table "APP_ReportsHistory" 109 MB

 

dbmaintenance  -full was performed. How we can turn this parameter?

 

Regards;

Pawel

icon

Best answer by Stuart Painter 22 February 2021, 15:40

Hi Pawel

I have looked up the details on the hotfix and it appears the report history was being updated each time an FR, MR or services restart was performed, which causes the table to bloat. This behaviour is fixed with the hotfix, so the table should no longer increase in size, but existing records will remain until pruning occurs.

These records will be pruned automatically after 90 days, so you should see this table reduce in size after this time.

Thanks,

Stuart

View original

4 replies

Userlevel 3
Badge +5

Hi Pawel

Thanks for the question, please would you confirm what Feature Pack and Maintenance Release you are running?
There was an issue identified with this table that has been resolved with Hotfix 2622, included in MR22 for FR20:

https://documentation.commvault.com/commvault/v11/article?p=11_20_36.htm
APP_ReportsHistory table may grow to a large size and show up in the health report - 2622

Please let me know your current version and if MR22 or above is applied?

Thanks,

Stuart

Badge +1

Hi Stuart;

 

I have CV 11.20.36

 

Regards;

Pawel

Userlevel 3
Badge +5

Hi Pawel

I have looked up the details on the hotfix and it appears the report history was being updated each time an FR, MR or services restart was performed, which causes the table to bloat. This behaviour is fixed with the hotfix, so the table should no longer increase in size, but existing records will remain until pruning occurs.

These records will be pruned automatically after 90 days, so you should see this table reduce in size after this time.

Thanks,

Stuart

Badge +1

Hi Stuart;

ok, thanks a lot for your explanation and you time.

 

Regards;

Pawel

Reply