No upgrade path from 9.4.00

book

Article ID: 220709

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

API Gateway database upgrade failed with the below error.


Error message: 
“No upgrade path from 9.4.00”

Cause

The problem is with ssg database "DATABSECHANGELOG" table name is in lower case(databasechangelog).

Environment

Release : 10.0

Component : API GATEWAY

Resolution

The DATABSECHANGELOG table name should be in UPPERCASE.

Steps to update the table name:

Take a backup of databasechangelog table
# mysqldump -uroot -p ssg databasechangelog > DATABASECHANGELOG.sql

# vi DATABASECHANGELOG.sql
Search for databasechangelog and change all entries to DATABSECHANGELOG.
Save the file.

Drop the existing databasechangelog table.

mysql> use ssg;
mysql> drop table databasechangelog;

Import DATABSECHANGELOG table name to ssg database.

# mysql -uroot -p ssg < DATABASECHANGELOG.sql

Connect to mysql ssg database and check if the DATABSECHANGELOG table name is in UPPERCASE.
# show tables;

--------------------------------------------------------------------------

Re-run database upgrade from ssgconfig menu.