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:
Executed as user: Domain\User. 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:01:08 AM Error: 2010-04-27 04:01:28.62 Code: 0xC0202009 Source: Content Statement Import Data Flow Insert Dest - ReportingDB (PM_ContentStatement)  Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ContentStatement_Statement". The conflict occurred in database "CSM_Reports", table "dbo.PM_Statement", column 'ID'.". End Error Error: 2010-04-27 04:01:28.62 Code: 0xC0209029 Source: Content Statement Import Data Flow Insert Dest - The package execution failed. The step failed.
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.