cdpStats.db corrupt - ZCM satellite server stops replicating

  • 7009146
  • 09-Aug-2011
  • 27-Apr-2012


Novell ZENworks 10 Configuration Management Content
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Content
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3.3 Content


Satellite servers were replicating fine but then stop replicating content
The satellite agent properties page for Satellite Content shows "Synchronization Status: 0 of 0 files synchronized"
zac cvc shows files to be synchronized
zac cdp replicate runs without error but still no files are listed to be synchronized
Workstations are unable to find content on the satellite server

zcm-messages.log file will show entries such as:

 [DEBUG] [08/09/2011 09:10:34.852] [3392] [ZenworksWindowsService] [29] [] [Sqlite] [] [cdpStats.db SqliteCommand.ExecuteReader.prepare::ExecuteNonQuery returned error: CANTOPEN] [] []
 [DEBUG] [08/09/2011 09:10:34.852] [3392] [ZenworksWindowsService] [29] [] [Sqlite] [] [(cdpStats.db) SqliteCommand.ExecuteReader.sqlite3_exec(no_want_results) returned error: CANTOPEN] [] []
 [DEBUG] [08/09/2011 09:10:34.852] [3392] [ZenworksWindowsService] [29] [] [Sqlite] [] [(cdpStats.db) Throwing sqlite exception from ExecuteReader(sql, want_results, err, errMsg): (replace into ContentEntries (contentId, path, length) values ('eb5351da48382d90b1921f87cc67a13a', 'C:\Program Files\Novell\ZENworks\work\content-repo\content\eb\eb5351da48382d90b1921f87cc67a13a.zc', 305), False, CANTOPEN, )] [] []


Starting with ZCM 10.3.1, the cdpStats.db file may be deleted and will be automatically rebuilt.

To fix the corrupt file and get the content to replicate, follow the steps below:

  1. Stop the Novell ZENworks Agent Service
  2. Delete (or move) the cdpStats.db (and cdpStats.db-journal) file(s) from %ZENWORKS_HOME%\work\content-repo\content (where %ZENWORKS_HOME% is the path to the ZENworks directory structure).
  3. Start the Novell ZENworks Agent Service
  4. At a command prompt, run the following:
    1. zac cc
    2. zac ref
    3. zac cvc
    4. zac cdp replicate
  5. Check the agent properties page.  It may take a minute for the Satellite section to reappear.  You should see content files beginning to replicate.


Reported to Engineering

Additional Information

It appears the cdpStats.db database becomes corrupt for reasons not yet known.