Database upgrade failed

Products

• CA API Gateway
• API SECURITY

Issue/Introduction

Gateway ssg database upgrade fails when upgrading from 9.2 to 9.4 

Performing database upgrade:

  Testing the upgrade on a test database ...
  Creating test database "ssg_testUpgrade" (without audits).
  Database creation may take a few minutes.
  The database was not upgraded due to the following reasons:

Invalid default value for 'modified'

No changes have been made to the database. Please correct the problem and try again.
Press [Enter] to continue

Environment

Release : 9.4

Component : API Gateway

Resolution

Connect to mysql and set the following global parameters.

mysql> set global sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

mysql> set global sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";