Cannot onboard VMs in the Console access page for user not found
When you try to onboard a VM in the Console access page on IBM Cloud Pak console, you might see the error message
user xxx is not found.
Resolving the problem
To resolve this problem, follow the steps：
Log in to the postgresql pod by running the following command:
oc rsh sre-bastion-postgresql-0 -n kube-system
Run the following commands in the postgresql pod:
cat > /tmp/trucate.sql <<EOF truncate table public.user_maps CASCADE; truncate table public.os_user_acls; EOF
cat /tmp/trucate.sql psql -U postgres -w -d bastion -f /tmp/trucate.sql
Note: After you run the commands, all the onboarded VMs will become off-boarded. You need to go to the Console access page, and onboard these VMs again.