PH48461: UCD using SQL server DB install/upgrade fails with error com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name

APAR status

• Closed as program error.

Error description

• When you attempt to install or upgrade UCD on a SQL server
  database fails with error "Invalid column
  name 'EXTERNAL_APPROVAL_PROCESS"
  
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:
  Invalid column name 'EXTERNAL_APPROVAL_PROCESS'.
  com.urbancode.cm.db.updater.ApplyException:
  java.lang.reflect.InvocationTargetException at
  com.urbancode.cm.db.updater.DbUpgradeTask.executeMultiVersionUpg
  rade(DbUpgradeTask.java:2 78) â ¦ Caused by:
  com.urbancode.cm.db.updater.ApplyException:
  java.lang.reflect.InvocationTargetException at
  com.urbancode.cm.db.updater.JavaDbUpdaterAction.apply(JavaDbUpda
  terAction.java:68) at
  com.urbancode.cm.db.updater.DbUpgradeTask.executeMultiVersionUpg
  rade(DbUpgradeTask.java:2 51) ... 116 more Caused by:
  java.lang.reflect.InvocationTargetException at
  sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:62) at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:43) at
  java.lang.reflect.Method.invoke(Method.java:498) at
  com.urbancode.cm.db.updater.JavaDbUpdaterAction.apply(JavaDbUpda
  terAction.java:65) ... 117 more Caused by:
  com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
  name 'EXTERNAL_APPROVAL_PROCESS'. at
  com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase
  Error(SQLServerException. java:265) â ¦ [echo] Install Failed.
  (press return to exit installer)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Deploy Server Web UI Users                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In the FixEmptyRequireApprovals.java upgrade we use upper    *
  * case for column names though the DDL specifies lower case.   *
  * We need to change this to always be lower case. Since sql    *
  * server name case sensitivity is controlled by database       *
  * collation we need to ensure that we always use the same      *
  * case. Our standard is to use lower case.                     *
  *                                                              *
  * This will affect all customers who use mssqlserver as their  *
  * database.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fix is provided in IBM UrbanCode Deploy 7.2.3.1              *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.2.3.1
  

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