Gateway database upgrade from version 7.1.2 to 8.0.0 or later fails: No Upgrade Path

Products

• STARTER PACK-7
• CA Rapid App Security
• CA API Gateway

Issue/Introduction

Solution

Background

Upgrading the CA API Gateway typically involves changes to the Gateway cluster's database. These changes are implemented during the process of applying an Application Update. A defect is present in version 7.1.2 that does not allow the Gateway database to be upgraded from 7.1.2 to 8.0.0 or later when an upgrade is executed. Necessary routines to facilitate an upgrade from 7.1.2 to 8.0.0 are not present.?This defect was documented in development incident SSG-8485 and is currently resolved in version 8.0.0 and later and does not re-occur as of the publish date of this article. This article will be necessary to facilitate an upgrade from 7.1.2 to 8.0.0.

Presentation

The following error messages may appear when a Gateway database update is executed by an administrator or operator:

The database was not upgraded due to the following reasons:
No upgrade path from "7.1.2" to "8.0.0"

Please note that the value "8.0.0" may reflect another version of the Gateway under different circumstances.

?

Resolution

This can be worked around by making a change to the Gateway database. This change will falsify the current Gateway database version and force the Gateway database upgrading subsystem to use a different set of routines to upgrade the Gateway database. Perform the following procedure to implement this change:

1. Log in to the CA API Gateway appliance as the ssgconfig user
2. Select Option #3: Use a privileged shell (root)
3. Execute the following command:?mysql ssg -e "update ssg_version set current_version='7.1.1'"
4. Verify the change:?mysql ssg -e "select * from ssg_version"
5. The output should reflect "7.1.1"

Attempt to upgrade the Gateway database against once these changes are completed. The error should not reoccur.

Environment

Release:
Component: APIGTW