NetIQ Analysis Center 2.6
NetIQ Analysis Center 2.7
NetIQ Analysis Center 2.7.5
ETL Step 16 taking longer than expected to complete
ETL causing transaction logs to grow excessively
ETL down for long period of time
To recover from this problem there are two options:
- Remove problem data source from Analysis Center. After removing the problem data source you will loose all existing historical data in Analysis Center for that data source. Then re-add the data source back to Analysis Center. All available data in the QDB repository will be imported into the new data source. The amount of historical data available is dependent upon the data retention policy configured in the AppManager repository.
- SQL queries can be run against the affected data source data mart database to purge the backlog of data & the ETL last load date rolled forward to the current day.
Contact NetIQ Technical Support and refer to KB Article Number NETIQKB72238 to obtain the queries & assistance to execute them.