No new data is appearing in Analysis Center after truncating data table in QDB (NETIQKB72894)

  • 7772894
  • 31-Mar-2011
  • 22-Feb-2012

Environment

NetIQ AppManager 7.x
NetIQ Analysis Center 2.7

Situation

No new data is appearing in Analysis Center after truncating data table in QDB

Resolution

Whenever you are using NetIQ Analysis Center in combination with NetIQ AppManager and the Data table of the  AppManager QDB database is going to be truncated, you have to wait for the ETL job to stop running, if currently running, and disable it.

Once the ETL job is disabled, you can truncate the Data table of the QDB, but do not enable the ETL job until there is data in the Data table.

Cause

When the Data table of the NetIQ AppManager QDB database is truncated and if the Analysis Center ETL job is enabled.  The following condition can occur:

If the Data table is empty (no new data has been written to the table) and the ETL begins to run and finds no rows, it causes Analysis Center to set its timestamp back to 0 (or January 1, 1970). 

This causes Analysis Center to begin processing existing data in 48 hour chunks per iteration.

Additional Information

Formerly known as NETIQKB72894

Feedback service temporarily unavailable. For content questions or problems, please contact Support.