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
Article Type
Technical Solution


Issue





 


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.


Solution



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


    CCS_ReportingAnalytics_v10.0_10001_2054290_QF.zip




 



Legacy ID



2010061622451053


Article URL http://www.symantec.com/docs/TECH133975


Terms of use for this information are found in Legal Notices