Unable to login with Workspace One (vDIM) in NSX-T appliances

In this article, I am going to guide you how to solve/workaround Workspace One (vDIM) login issue

From time to time getting following messages appear when login at NSX or other portals which is integrated to Workspace one (formerly known as VMware Identity manager)

The problem is db disk is full

Solution:

Take snapshot of VM prior to run the following commands

dolby@localhost [ ~ ]# export PGPASSWORD=’Google 😃’
dolby@localhost [ ~ ]# /opt/vmware/vpostgres/current/bin/psql -U postgres saas

truncate table “OAuth2RefreshToken” CASCADE;
select count() from “OAuth2RefreshToken”;
select count() from “OAuth2AccessToken”;
select count(*) from “SuiteTokenCache”;
vacuum full verbose;
reindex table “OAuth2RefreshToken” ;
vacuum full verbose;
\q

If the disk is 100% full you have to increase the db-disk, before running the truncate-command. Please do the following:

• Shut down the appliance gracefully
• Increase Hard Disk 2 from vcenter with 5 GB
• Power on the appliance
• pvresize /dev/sdb
• lvextend /dev/mapper/db_vg-db /dev/sdb
• resize2fs -p /dev/mapper/db_vg-db
• Ensure horizon-workspace, elasticsearch, vpostgres, and rabbitmq-server are running (service <service-name> status) and restart if necessary (service <service-name> restart)

I hope this article has been informative. thank you for reading.