Unable to synchronize app with more than six api subscriptions

Products

• API MANAGEMENT SAAS
• 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.

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    |       |

Environment

Release : 4.3.2

Component : API MANAGEMENT SAAS

Resolution

To resolve alter the table type as followed: 

mysql> alter table portal_apikey modify apis longtext;