After an upgrade of the CCS (Control Compliance Suite) 9.0.1 to the 2010-1 Update, and installing new content, the synchronization job fails with the following error: Error synchronizing policy module details to the reporting database.
The complete error generated from the failed job captured in SQL Server Agent Job Activity Monitor >View History log file summary:
The Reporting & Analytics 9.0.1 PCU 2010-1 introduces content check mappings (GUIDs) with no real mappings. The missing mappings did not create a problem in the production database (CSM_DB), but it did create a problem in the reporting database (CSM_Reports) as it violates a constraint in one of the reporting database tables. This is why the Scheduled Report Database Synchronization job fails.
The Symantec™ Control Compliance Suite 9.0.1: Reporting and Analytics 2010-2 Update resolves this issue. The synchronization job executes successfully after an upgrade of CCS 9.0.1 to the 2010-1 Update and installation of new content.