APAR status
Closed as program error.
Error description
Upgrade of UCD from 6.2.10 to 7.1.0.1.ifix01.1062130 fails with the below error ERROR [upgrade] Found n1_6.2.3 current version: 0 [upgrade] Applying n1_6.2.3 change: 1 - Create temporary table for deleted environment cleanup [upgrade] Applying n1_6.2.3 change: 2 - Inserting deleted rows in vc for objects which are associated with deleted environments: com.urbancode.cm.db.updater.ApplyException: java.lang.IllegalStateException: Failed to process query. Unterminated ' character? at com.urbancode.cm.db.updater.DbUpgradeTask.executeMultiVersionUpg rade(DbUpgradeTask.java:273) at com.urbancode.cm.db.updater.DbUpgradeTask.execute(DbUpgradeTask. java:81) ... Caused by: java.lang.IllegalStateException: Failed to process query. Unterminated ' character? ... at upgrade_002_db2_add_deleted_version_in_vc_for_objects_associated _with_deleted_environments$_run_closure3.doCall(upgrade_002_db2_ add_deleted_version_in_vc_for_objects_associated_with_deleted_en vironments.groovy:72) at upgrade_002_db2_add_deleted_version_in_vc_for_objects_associated _with_deleted_environments$_run_closure3.doCall(upgrade_002_db2_ add_deleted_version_in_vc_for_objects_associated_with_deleted_en vironments.groovy) ... at upgrade_002_db2_add_deleted_version_in_vc_for_objects_associated _with_deleted_environments.run(upgrade_002_db2_add_deleted_versi on_in_vc_for_objects_associated_with_deleted_environments.groovy :147) at com.urbancode.cm.db.updater.GroovyDbUpdaterAction.apply(GroovyDb UpdaterAction.java:74) ... 119 more [echo] Install Failed. (press return to exit installer) Database involved is DB2.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All end users on all supported browsers. * **************************************************************** * PROBLEM DESCRIPTION: * * Upgrade of UCD from 6.2.10 to 7.1.0.1.ifix01.1062130 fails * * with * * the below error * * * * ERROR * * * * [upgrade] Found n1_6.2.3 current version: 0 * * [upgrade] Applying n1_6.2.3 change: 1 - Create * * temporary * * table for deleted environment cleanup * * * * [upgrade] Applying n1_6.2.3 change: 2 - Inserting * * deleted * * rows in vc for objects which are associated with deleted * * environments: com.urbancode.cm.db.updater.ApplyException: * * java.lang.IllegalStateException: Failed to process query. * * Unterminated ' character? * * at * * com.urbancode.cm.db.updater.DbUpgradeTask.executeMultiVersio * * nUpg * * rade(DbUpgradeTask.java:273) * * at * * com.urbancode.cm.db.updater.DbUpgradeTask.execute(DbUpgradeT * * ask. * * java:81) * * ... * * Caused by: java.lang.IllegalStateException: Failed to * * process query. Unterminated ' character? * * ... * * at * * * * upgrade_002_db2_add_deleted_version_in_vc_for_objects_associ * * ated * * _with_deleted_environments$_run_closure3.doCall(upgrade_002_ * * db2_ * * add_deleted_version_in_vc_for_objects_associated_with_delete * * d_en * * vironments.groovy:72) * * at * * * * upgrade_002_db2_add_deleted_version_in_vc_for_objects_associ * * ated * * _with_deleted_environments$_run_closure3.doCall(upgrade_002_ * * db2_ * * add_deleted_version_in_vc_for_objects_associated_with_delete * * d_en * * vironments.groovy) * * ... * * at * * * * upgrade_002_db2_add_deleted_version_in_vc_for_objects_associ * * ated * * _with_deleted_environments.run(upgrade_002_db2_add_deleted_v * * ersi * * on_in_vc_for_objects_associated_with_deleted_environments.gr * * oovy * * :147) * * at * * com.urbancode.cm.db.updater.GroovyDbUpdaterAction.apply(Groo * * vyDb * * UpdaterAction.java:74) * * ... 119 more * * [echo] Install Failed. (press return to exit * * installer) * * * * Database involved is DB2. * **************************************************************** * RECOMMENDATION: * * Fixed in version 7.1.2.0 * ****************************************************************
Problem conclusion
Fix is provided in IBM UrbanCode Deploy 7.1.2.0
Temporary fix
Comments
APAR Information
APAR number
PH28456
Reported component name
UC DEPLOY
Reported component ID
5725M5400
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-13
Closed date
2021-02-16
Last modified date
2021-02-16
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
UC DEPLOY
Fixed component ID
5725M5400
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710"}]
Document Information
Modified date:
26 February 2021