Error : "Exception occurred. Failed SQL: /* ~~QC */ INSERT INTO GROUPS with ORA-00001: unique constraint (AVIATION_SCQC_SANDBX1_DB.GROUPS_PK) violated " upgrading QC10 project to ALM11

  • Document ID:KM01009956
  • Creation Date:25-Jun-2014
  • Modified Date:25-Jun-2014
    • Micro Focus Products:
      quality center 11.00

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Upgrading a QC 10 project to ALM 11 results in an error about in GROUPS table. 3 USer( TDAdmin, Developer, Viewer) for GR_ID and GR_GROUP_ID values not match

Error

Customer symptom

During the upgrade process they got the following error:

22:40:20  Exception occurred. Failed SQL: /* ~~QC */ INSERT INTO GROUPS (GR_GROUP_ID,GR_ID,GR_GROUP_NAME,GR_IS_SYSTEM) VALUES (/*P*/1,/*P*/1,/*P*/'QATester',/*P*/'Y') [Mercury][Oracle JDBC ...

22:40:20  Driver][Oracle]ORA-00001: unique constraint (AVIATION_SCQC_SANDBX1_DB.GROUPS_PK) violated

Cause

cause :
 GROUPS table in 3 USer( TDAdmin, Developer, Viewer) for GR_ID and GR_GROUP_ID values not match

Fix

The group IDs of the first 3 User groups should match their GR_GROUP_ID values as shown below:

GR_GROUP_NAME                      GR_ID                            GR_GROUP_ID
TDAdmin                                            0                                              0
Developer                                          3                                              3
Viewer                                                4                                              4

Please  you should make a backup of the DB and involve your DBA before making any modifications.