PH15581: DB2 FOR Z\OS THE ALTER TABLE STATEMENT CANNOT DROP MULTIPLE COLUMNS. SEPARATE ALTER TABLE STEPS ARE REQUIRED.

APAR status

• Closed as program error.

Error description

• Upgrade generates the following error:
  [upgrade] Applying n1_7.0.2 change: 2 - Remove unused security
  library features 1/3
  : com.urbancode.cm.db.updater.ApplyException: DB2 SQL Error:
  SQLCODE=-104, SQLSTATE=42601, SQLERRMC= ;RESTRICT,
  DRIVER=3.69.66: alter table sec_user
                  drop column sec_license_type_id_requested
                  drop column sec_license_type_id_received
                  drop column licensed_session_count
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All end users on all supported browsers.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Upgrade generates the following error:                       *
  *   [upgrade] Applying n1_7.0.2 change: 2 - Remove unused      *
  * security                                                     *
  * library features 1/3                                         *
  * : com.urbancode.cm.db.updater.ApplyException: DB2 SQL Error: *
  * SQLCODE=-104, SQLSTATE=42601, SQLERRMC= ;RESTRICT,           *
  * DRIVER=3.69.66: alter table sec_user                         *
  *                 drop column sec_license_type_id_requested    *
  *                 drop column sec_license_type_id_received     *
  *                 drop column licensed_session_count           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fixed in version 7.0.4.1                                     *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.0.4.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