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'
|Article:TECH133975|||||Created: 2010-01-16|||||Updated: 2010-09-05|||||Article URL http://www.symantec.com/docs/TECH133975|
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.
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>
3. Replace the file MigrationManifest.xml at the <installDir>
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.
Article URL http://www.symantec.com/docs/TECH133975