Admin Gear Icon Configuration options are not shown in Admin Console logged as admin role

Products

• CA API Developer Portal

Issue/Introduction

We are logged in Dev Portal as admin and we can't see the gear Icon where we can set the portal configurations.

 

Environment

Release : 5.0

Cause

lock on the databasechangeloglock table not allowing the analytics pod to start correctly. Then do not shows the Admin gear icon neither.

Resolution

* seems to be a lock on the databasechangeloglock table similar to the one mentioned on the KB below, but this case is related to analytics database instead.

1. Please, login to the analytics database 

- docker exec -it -u 0 $(docker ps -q -f name=portal_portaldb.1) su -c 'PGPASSWORD=7layer psql -U admin portal'

- \c analytics

- and execute the below query (for mysql ):
UPDATE DATABASECHANGELOGLOCK SET locked=0, lockgranted=null, lockedby=null WHERE id=1;

for PostgreSQL DB :

UPDATE DATABASECHANGELOGLOCK SET LOCKED=false, LOCKGRANTED=null, LOCKEDBY=null where ID=1;

**after the Update command the analytics Pod start to work properly and you are able to see the Admin gear icon again

Additional Information

CA API Developer Portal containers are not coming up
https://knowledge.broadcom.com/external/article/112262/ca-api-developer-portal-containers-are-n.html