cdpStats.db corrupt - ZCM satellite server stops replicating

  • Document ID:7009146
  • Creation Date:09-Aug-2011
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

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

Situation

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, )] [] []


Resolution

Workaround:
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.

Status

Reported to Engineering

Additional Information

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