The proxy integration bundle does not meet the minimum version requirement

Products

• CA API Developer Portal

Issue/Introduction

Cannot deploy API XXX to the proxy, the proxy integration bundle does not meet the minimum version requirement

Environment

5.2.3

Cause

There was a table missing in your database which should have been created during one of the upgrades.

Resolution

First make sure you have a valid portal db backup then create the table with the following statement:

As a workaround, please execute the query below under the "portal" database.

CREATE TABLE `PRODUCT_TIER_XREF` (
  `PRODUCT_UUID` varchar(36) NOT NULL,
  `TIER_UUID` varchar(36) NOT NULL,
  `RATE_QUOTA_UUID` varchar(36) NOT NULL,
  `IS_DEFAULT_TIER` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `UK_PRODUCT_TIER` (`TENANT_ID`,`PRODUCT_UUID`,`TIER_UUID`),
  KEY `FK_TIER_UUID` (`TENANT_ID`,`TIER_UUID`),
  KEY `FK_TIER_RATE_QUOTA_UUID` (`TENANT_ID`,`RATE_QUOTA_UUID`),
  CONSTRAINT `FK_PRODUCT_UUID` FOREIGN KEY (`TENANT_ID`, `PRODUCT_UUID`) REFERENCES `PRODUCT` (`TENANT_ID`, `UUID`) ON DELETE CASCADE,
  CONSTRAINT `FK_TIER_RATE_QUOTA_UUID` FOREIGN KEY (`TENANT_ID`, `RATE_QUOTA_UUID`) REFERENCES `RATE_QUOTA` (`TENANT_ID`, `UUID`) ON DELETE CASCADE,
  CONSTRAINT `FK_TIER_UUID` FOREIGN KEY (`TENANT_ID`, `TIER_UUID`) REFERENCES `TIER` (`TENANT_ID`, `UUID`) ON DELETE CASCADE
)

Restart portal and then,

Login to the target proxy via the Policy Manager

Tasks > Global Settings > Set the CWP "portal.deployer.enabled" to false

Wait for 1 minute

Set the CWP "portal.deployer.enabled" to true

This complete set of steps solved the issue.