Environment
Situation
Resolution
NetIQ Analysis Center uses the ETL job to pull data from the AppManager Repository (QDB). By default, the ETL job runs every 5 minutes, but you can configure this interval in SQL Enterprise Manager. If your environment has a large QDB, you should increase the interval to allow 30 minutes or 1 hour per iteration.
Initially, the ETL job gathers the oldest 7 days of data per iteration from the AppManager Repository. After the ETL job has collected all historical data, it collects current data. So, if you have 3 weeks of data in the QDB, you should allow for three iterations of the ETL job to complete, and then an additional iteration to collect current data.