CA API Portal Private API Association in Account Plan

Products

• CA API Developer Portal

Issue/Introduction

Portal 4.3.2

we make APIs in Account Plan, 
we associate Account Plan with the organization
we create an apps linked to organization 
but we can't add all the private APIs to Apps which are in the Account Plan.
In Account Plan we have 10 APIs, but in the APPs, we can only select 4 APIs, why?

The behaviour is very intermittent - sometimes it shows 4 APIs, other time it shows 3 APIS etc.

 

Environment

Release : 4.3.2

Component : API PORTAL

Cause

The root cause is, we're creating view table named  'API_LIST_VIEW' in a way that doesn't take DB global setting group_concat_max_len into consideration.

The default value for this parameter is small (1024) which is not able to handle large number of organization UUIDs for which the api is associated to.

mysql>> use portal;

mysql>> SELECT @@group_concat_max_len; - which returns 1024 by default

Resolution

The root cause is we're creating view table named 'API_LIST_VIEW' in a way that doesn't take DB global setting group_concat_max_len into consideration.

The default value for this parameter is small (1024) which is not able to handle large number of organization UUIDs for which the api associated to.

Please ask DBA to change group_concat_max_len to 512000 and restart the server.

You need yo have the setting in my.cnf or my.cfg, and the restart mysql service.

Make sure the setting is under the [mysqld] group header

[mysqld]group_concat_max_len=512000
then you can restart mysql service.