ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to synchronize app with more than six api subscriptions

book

Article ID: 199730

calendar_today

Updated On:

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;