Deployments or items not found after upgrading to vRealize Automation 7.5

Products

• VMware Aria Suite

Issue/Introduction

Searching for deployments or resources by name will not yield any results in the UI (Deployments tab).

Symptoms:
Searching for deployments or resources by name will not yield any results in the UI (Deployments tab) after upgrading to vRealize Automation(vRA) 7.5

Environment

VMware vRealize Automation 7.5.x

Cause

Upgrading from a pre vRA 7.5 system to a 7.5 environment can cause existing resources to lose their values in the 'keywords' field in the database. The keywords field is populated by the catalog-service using data from providers. During the upgrade process, we are failing to trigger functions that repopulate the 'keywords' field when we fetch fresh data from providers.

Resolution

To resolve this problem:

Prior to performing the below, please ensure to snapshot each vRA appliance.

Note there are two scripts attached to this article. For vRA environments with less than 50 deployment objects use the 'touch_all_deploymentsSmall.sh' script. For vRA environments with more than 50 deployment objects use the 'touch_all_deploymentsLarge.sh' script.

1. Depending on Number of deployments download the relevant shell script to the primary vRealize Automation appliance.
2. Give the script executable permissions:
chmod +x 'touch_all_deploymentsLarge.sh'
or
chmod +x 'touch_all_deploymentsSmall.sh'
3. Run the script using:
./touch_all_deploymentsLarge.sh
or
./touch_all_deploymentsSmall.sh
4. Enter the vRA environment URL when prompted (this should be JUST the base URL (eg: https://my-vra-environment.local)
The 'https://' is required to be entered when prompted for URL or else the script will not run.
5. Enter a tenant admin username when prompted. You can also enter a business group admin username, but if you do this, you will need to re-run this script for each business group in your environment.
6. Enter the password for the user you entered above.
7. Let the script run. It should print out a rolling log of how many deployments are being refreshed and having their provider/keyword data repopulated.
8. Log into the vRA UI and confirm that the search function now returns deployments/machines as expected.