PI12959: ERROR UNIQUE CONSTRAINT VIOLATED WHEN UPGRADING FROM 4.8.5 TO 6.0.1.1

IBM UrbanCode Deploy Fix Pack 5 (6.0.1.5) for 6.0.1
IBM UrbanCode Deploy Fix Pack 6 (6.0.1.6) for 6.0.1
IBM UrbanCode Deploy Fix Pack 7 (6.0.1.7) for 6.0.1
IBM UrbanCode Deploy Fix Pack 8 (6.0.1.8) for 6.0.1
IBM UrbanCode Deploy Fix Pack 9 (6.0.1.9) for 6.0.1
IBM UrbanCode Deploy Fix Pack 10 (6.0.1.10) for 6.0.1
IBM UrbanCode Deploy Fix Pack 11 (6.0.1.11) for 6.0.1
IBM UrbanCode Deploy Fix Pack 12 (6.0.1.12) for 6.0.1
IBM UrbanCode Deploy iFix 1 for 6.0.1.9

APAR status

• Closed as program error.

Error description

• Upgrade from IBM uDeploy 4.8.5 to IBM UrbanCode 6.0.1.1 failed
  with error:
  
  [upgrade] Applying 5.0 change: 16 - Migrating resource groups to
  the
  new resource model
  [upgrade] Feb 18, 2014 4:47:14 PM groovy.sql.Sql executeUpdate
  [upgrade] WARNING: Failed to execute:
  [upgrade] insert into ds_res_grp_cmp_env_mapping
  [upgrade] (id, version, environment_id, component_id,
  resource_id)
  [upgrade] values
  [upgrade] (?, 0, ?, ?, ?)
  [upgrade] because: ORA-00001: unique constraint
  (URBANDEV50.DS_RG2C2E_MAP_UC) violated
  [upgrade]
  
  when using an Oracle database and having the same resource
  mapped to an environment twice.
  
  This issue can be recreated by performing the following actions:
  
  1. Map the resource itself to the environment.
  2. Create a static group containing the same resource
  3. Map the resource group to the same environment.
  

Local fix

• Not available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Oracle database                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Upgrade from IBM uDeploy 4.8.5 to IBM UrbanCode 6.0.1.1      *
  * failed                                                       *
  * with error:                                                  *
  *                                                              *
  * [upgrade] Applying 5.0 change: 16 - Migrating resource       *
  * groups to                                                    *
  * the                                                          *
  * new resource model                                           *
  * [upgrade] Feb 18, 2014 4:47:14 PM groovy.sql.Sql             *
  * executeUpdate                                                *
  * [upgrade] WARNING: Failed to execute:                        *
  * [upgrade] insert into ds_res_grp_cmp_env_mapping             *
  * [upgrade] (id, version, environment_id, component_id,        *
  * resource_id)                                                 *
  * [upgrade] values                                             *
  * [upgrade] (?, 0, ?, ?, ?)                                    *
  * [upgrade] because: ORA-00001: unique constraint              *
  * (URBANDEV50.DS_RG2C2E_MAP_UC) violated                       *
  * [upgrade]                                                    *
  *                                                              *
  * when using an Oracle database and having the same resource   *
  * mapped to an environment twice.                              *
  *                                                              *
  * This issue can be recreated by performing the following      *
  * actions:                                                     *
  *                                                              *
  * 1. Map the resource itself to the environment.               *
  * 2. Create a static group containing the same resource        *
  * 3. Map the resource group to the same environment.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is delivered in IBM UrbanCode Deploy 6.0.1.5
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  UDEPLOY

• Fixed component ID

  5725M7700

Applicable component levels

• R500 PSN

     UP

• R500 PSY

     UP