Control Compliance Suite 11.x - Error synchronizing user details to the reporting database
Last Updated February 23, 2016
The "Reporting Database Synchronization Job" job completes with an error in the Messages tab.
Error synchronizing user details to the reporting database.,Operation failed. The index entry of length 954 bytes for the index 'PK_ChangeLogEntries' exceeds the maximum length of 900 bytes.
Note: The entry length of 954 as shown in this example can vary.
The underlying error is a common SQL error and due to the way the index (PK_ChangeLogEntries in this case) is configured / created.
The attached SQL script will drop the current index and recreate the index using a method that will less likely cause this limitation to be hit again while maintaining the uniqueness of the index. No data in the table is changed or deleted - the script only touches the index.
This fix will be included into the next product update of CCS 11.1.