Environment
Novell ZENworks Configuration Management 11.4
Situation
On Managed devices, the cleanup mechanism cleans up entries in the database which has notuploaded = 'false' and older then 7 days - running every night.
In cases where there are entries in the database where the notuploaded = 'true' but the files don't exist on the file system, the cleanup tool is failing.
ERROR (from zmd-messages.log):
[ZenworksWindowsService] [122] [] [SCP] [] [(Collectionstats.db.db) SqliteCommand.ExecuteReader exception
Type: Novell.Zenworks.Cache.Sqlite.SqliteException
Message: Error in the application.
[DEBUG] [02/17/2016 09:25:21.185] [328] [ZenworksWindowsService] [108] [] [SCP] [] [ReceivedFile SQL query failed.
[ZenworksWindowsService] [108] [] [SCP] [] [Error saving received file info in database. File:
Resolution
This is fixed in version 11.4.3 - see KB 7017820 "ZENworks Configuration Management 11.4.3 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7017820