Environment
NetIQ AppManager 8.x
Situation
Data is collected and written to the Data table, but no data is written to the ArchiveData table.
Resolution
To check the ArchiveData enablement value in the AppManager Repository database, run the following query against the QDB:
select * from globalpref
where name = 'ArchiveData'
If the ArchiveData "Val" value is set to "0" or anything other than "1", you can correct this issue by using the following query to enable ArchiveData:
update globalpref
set val = 1
where name = 'ArchiveData'
Cause
The default value for the ArchiveData "Val" value in the GlobalPref table is "1". This allows Management Servers to know to write data to the ArchiveData table. If this value has been manually altered, your Management Servers will not know to write data to the ArchiveData table.
Additional Information
Before making ANY changes to your Repository Database, you should guarantee that you first have a confirmed good, recent back-up of the Repository database.