PI53224: ATTEMPTS TO INSTALL UCD DESIGN SERVER 6.2 ON MYSQL 5.7.9 RESULT IN FAILURE

IBM UrbanCode Deploy Fix Pack 2 (6.2.0.2) for 6.2
IBM UrbanCode Deploy Interim Fix 1 for 6.2.0.2

APAR status

• Closed as program error.

Error description

• You will get the error "Failed to execute: SET
  storage_engine=InnoDB" when installing UCD Design Server on
  MySQL 5.7.9.
  
  The corresponding error call stack is
  ----->
  Installing server files into /opt/ibm-ucd-patterns...Creating
  new encryption key.
  Creating Security Database Schema ...
  Creating Security Database Foreign Keys ...
  Creating Security Database Indexes ...
  Creating IBM UrbanCode Deploy Blueprint Design Server Database
  Schema
  ...
  [ant:sql] Failed to execute:   SET storage_engine=InnoDB
  : java.sql.SQLException: Unknown system variable
  'storage_engine'
  at
  org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:670)
  at
  org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
  292)
  at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke
  (DelegatingMethodAccessorImpl.java:56)
  <-----
  
  Cause: It is because the "storage_engine" variable used in UCD
  Design Server installation was removed in MySQL 5.7.9.
  

Local fix

• Downgrade to MySQL version (5.5.xx up to 5.7.8).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You will get the error "Failed to execute: SET               *
  * storage_engine=InnoDB" when installing UCD Design Server on  *
  * MySQL 5.7.9.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is available in IBM UrbanCode Deploy 6.2.0.2
  

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

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP

• R611 PSN

     UP

• R611 PSY

     UP

• R612 PSN

     UP

• R612 PSY

     UP

• R613 PSN

     UP

• R613 PSY

     UP

• R620 PSN

     UP

• R620 PSY

     UP