Cannot disable an API in Portal

Products

• CA API Developer Portal

Issue/Introduction

Cannot disable an API in developer Portal.

 ssgUrl: The value for this field must be unique

Environment

All Supported versions of Developer Portal.

Cause

Duplicate ssgUrl in the database.

Resolution

Check if there are any duplicate URL with the same pattern in Portal database.

SELECT uuid, name, ssg_url, published_by_portal, portal_status 
FROM API 
WHERE LOWER(ssg_url) = LOWER('<your-ssg-url>');

Change the <your-ssg-url> with correct URL, share the output of the query.

----------

If there are 2 APIs with same ssgUrl, rename the one which you do not need with the update query.

update API set ssg_url='/deletedurl' where uuid='xxxxxxxxxx';