Problem upgrading APIM Gateway from 9.0 to 9.1 database schema

Document ID : KB000045926
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem

Failing upgrade to database schema from 9.0 to 9.1 for a Software Gateway Installation:- 

Table 'ssg.databasechangelog' doesn't exist 

Cause: 

/etc/my.cnf is the MySQL configuration, it contained a line 'lower_case_table_names=1' meaning that table names are case sensitive.  However database contains both databasechangelog and DATABASECHANGELOG which was causing upgrade to fail.  

Resolution:

Remove both databasechangelog tables from ssg and upgrade can be performed.