After upgrading to Control Compliance Suite (CCS) 10.0, the Reports and Dashboard data migration process fails with the following error:Reinstating indexes (SERIOUS ERROR!!): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name'dbo.SubjectTestResult' and the index name 'unci_SubjectTestResult_SID_SV_TID_TV_ED_RelID_RN'

Products

• Control Compliance Suite Windows
• Control Compliance Suite Response Assessment Module

Issue/Introduction

 

Cause

This issue occurs if Response Assessment Module (RAM) configured with CCS 9.0.1 and the following operations were performed prior to upgrade: RAM Question that is linked to CCS policies was renamed. OR ·         RAM Questionnaire that contains questions linked to CCS policies was renamed.

Resolution

Follow these steps to apply the Quick Fix

1. Extract the content of the zip file at a known location.
2. Take a backup of the file MigrationManifest.xml from <installDir>\Program Files\Symantec\CCS\Reporting and Analytics\Application Server.
3. Replace the file MigrationManifest.xml at the <installDir>\Program Files\Symantec\CCS\Reporting and Analytics\Application Server location with the file extracted at the known location.

Apply Quick Fix QF10001 and re-launch the data migration utility.

Note - If you have upgraded to CCS 10.0 and not started data migration, you can avoid receiving this error by applying the Quick Fix QF10001 before performing the data migration.


CCS_Reporting&Analytics_v10_10001_2054290_QF