PH38671: ON DB2, UPGRADE TO 7.1.2.0 FAILS WITH UNTERMINATED ' (APOSTROPHE} CHARACTER ERROR

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  Upgrade of UrbanCode Deploy to 7.1.2.0.ifix01.1104215. it
  randomly fails with the error:
  Failed to process query. Unterminated ' character?
  
  Install log:
  [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?
  ...
  Caused by: java.lang.IllegalStateException: Failed to process
  query. Unterminated ' character?
  ...
  upgrade_002_db2_add_deleted_version_in_vc_for_objects_associated
  _with_deleted_environments.run
  (upgrade_002_db2_add_deleted_version_in_vc_for_objects_associate
  d_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)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Only systems using DB2 as the database                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Upgrade of UrbanCode Deploy to 7.1.2.0.ifix01.1104215. it    *
  * randomly fails with the error: Failed to process query.      *
  * Unterminated ' character?                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in 7.2.1.0
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels