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：

1. Log in to the postgresql pod by running the following command:

   oc rsh sre-bastion-postgresql-0 -n kube-system
   

2. 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.