Unable to revert CMS settings

Products

• CA API Developer Portal
• CA API Gateway

Issue/Introduction

After setting and applying the CMS integration settings, they cannot be reverted via the Web UI. The original values will not be accepted.
If the settings are incorrect the Web UI is no longer usable. How can this be reverted?

Environment

Release: APIXSP99000-4.2-API Developer Portal-Enhanced Experience-Partner
Component:

Resolution

The settings will need to be changed directly in the database.

If you are using the internal database please use the following to get access to the database:

1. Get the container id of the portal_portaldb docker container by running : docker ps
2. Access the psql interface of the container using : docker exec -it <container_id>  psql -U admin portal

 

To reset the values, please use the following commands (substitute <tenant_id> with the id of the affected tenant)

UPDATE setting SET value='' where name = 'CONTENT_MANAGEMENT_AUTHOR_HOST' and tenant_id='<tenant_id';
UPDATE setting SET value='' where name = 'CONTENT_MANAGEMENT_AUTHOR_AUTH_URI' and tenant_id='<tenant_id';
UPDATE setting SET value = '/admin/navigation' where name = 'NAVIGATION_PRIMARY_URI' and tenant_id='<tenant_id';
DELETE from setting where name = 'CONTENT_MANAGEMENT_SAML_SESSION_URI' and tenant_id='<tenant_id';

After this restart the portal with ./portal.sh