Business Unit mapping will be lost during vRB Upgrade
book
Article ID: 332391
calendar_today
Updated On:
Products
VMware Aria Suite
Issue/Introduction
Symptoms: Business Unit mapping will not be retained once you unregister vRB from vRA
Cause
vRB unregestration from vRA is causing vcac_user_consumer_mapping table to clear the data which is resulting in loosing BU mapping association
Resolution
Perform these steps before unregestering vRB from vRA while upgrading:
1. Take a snapshot of vRB. 2. Take backup of BU mapping table as below: # export PGPASSWORD=`grep 'jdbc.password=\K.*' /usr/local/tomcat/itbm-server/conf/itfm.properties -Po` # /opt/vmware/vpostgres/current/bin/pg_dump --data-only -U itfm_cloud_admin -d postgres -t vcac_user_consumer_mapping > /root/backup.sql 3. Unregister vRB from vRA. Upgrade it and register back. 4. Delete empty BU mapping table after upgrade as below: # /usr/ITFM-Cloud/va-tools/bin/db-client.sh # delete from vcac_user_consumer_mapping; # \q 5. Restore the BU mapping table taken before upgrade as below: # export PGPASSWORD=`grep 'jdbc.password=\K.*' /usr/local/tomcat/itbm-server/conf/itfm.properties -Po` # /opt/vmware/vpostgres/current/bin/psql -U itfm_cloud_admin -d postgres -f /root/backup.sql