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

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

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

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

Resolution

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.

Cause

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.