If I add a new API proxy with the same name of a proxy previously deleted, Portal UI fails with an error.
API Portal 5.3
When deleting an existing proxy, the key store is not automatically removed from Portal's database's table portal.KEY_STORE. That causes an issue where we cannot reuse the same name when creating a new Proxy (since the item still exists in the database).
We need to remove the keystore of the deleted API Proxy using one of the following two methods:
Option 1 (recommended method):
From Portal UI > Manage Keystore
From the list, click on the "proxy name-keystore" that we intend to remove, then hit the Delete button and Confirm the action.
Option 2:
From the database.
1. List all Proxy names currently saved in the Portal DB KEY_STORE table:
select UUID, NAME from portal.KEY_STORE;
2. Identify the UUID of the affected Proxy name and delete using the below statement (insert correct UUID):
delete from portal.KEY_STORE where UUID = 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx';