No data in the Archivedata table while there is data in the Data table (NETIQKB70562)

  • 7770562
  • 02-Aug-2007
  • 15-Feb-2012


NetIQ AppManager 6.x
NetIQ AppManager 7.0.x


No data in the Archivedata table while there is data in the Data table.
Report jobs event with no data for reports.


You can confirm that this is the cause of the problem in your environment by running the following query in SQL Query Analyzer against the AppManager Repository Database:

select * from globalpref where name = 'ArchiveData'

Check the results from the query, the Val column should contain a value of "1" for ArchiveData.  If the Val value is "0" you will need to run the following query against the AppManager Repository to correct this entry:

update globalpref set val = 1 where name = 'ArchiveData'

Once this has been run, you should start seeing NEW data entered in the ArchiveData table along with the data being written to the Data table.  This will not recover previously uncollected data.


The GlobalPref value for ArchiveData has been changed to "0" in the AppManager Repository (QDB).

Additional Information

Formerly known as NETIQKB70562

The fix will require that you manually update the AppManager Repository Database, thus it is recommended that you first confirm that you have a recent, good back-up of the AppManager Repository Database before proceeding.