CollectionStatsDB is not cleaned on Windows platform

  • 7018246
  • 07-Nov-2016
  • 07-Nov-2016


Novell ZENworks Configuration Management 11.4


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:


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