issue running report for 3 months in iConsole

Document ID : KB000093151
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
We have an issue with running a report in the iConsole. We can run the report fine when looking up a few days or even a few weeks.  But when we run the report for a few months we run into slow downs and even errors.   We even have these issues when running this report as an Admin as well.
Resolution:
Most of the time this issue is resolved or averted by proper database maintenance. If you run into this issue it is heavily recommended to do a clean up and defrag of your database to resolve this issue.