Unable To Add API To Application

Products

• CA API Developer Portal

Issue/Introduction

We have made a particular API available to a desired organization.  We then attempt to create a new application and associate that with the organization which has visibility to our desired API.  We then want to add the API to the application but it is not present in the list of available API's to add to the application.

Environment

CA API Developer Portal 5.x

Cause

The following mysql setting was not configured within the my.cnf file

group_concat_max_len=512000

Resolution

After adding the group_concat_max_len setting within the my.cnf file and restarting the mysql service we could then successfully add the api to the application.

We document the need for this setting within our Portal documentation which you can reference here.