Self-Solve Knowledge Search

Minimize Maximize
Error : "Exception occurred. Failed SQL: /* ~~QC */ INSERT INTO GROUPS with ORA-...
This document has not been formally reviewed for accuracy and is provided as is
Title :
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
Product - Version:
quality center 11.00 ;
OS :
Updated :
Wed Jun 25 04:54:10 GMT 2014
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
Problem

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.