Unable to synchronize app with more than six api subscriptions

Products

• CA API Management SaaS

Issue/Introduction

Apps with more than six API subscriptions are failing to synchronize with enrolled api gateways.

Steps to reproduce:
1. create a new app.
2. subscribe the app to seven APIs.
3. the app will not show up in portal_apikey table on the enrolled gateways. No synchronization error is shown in API portal.

Environment

Release : 4.3.2

Component : API MANAGEMENT SAAS

Cause

Customer upgrade OTK from as far back as 3.1 the schema used in the older version defined column apis in table portal_apikey as 

mysql> DESCRIBE portal_apikey;

apis            | varchar(255) | YES  |     | NULL    |       |

 

There was a change during upgrade where it is now defined as:

mysql> DESCRIBE portal_apikey;

| apis            | longtext     | YES  |     | NULL    |       |

Resolution

To resolve alter the table type as followed: 

mysql> alter table portal_apikey modify apis longtext;