The issue occurs under the following circumstances:
The code throws a null pointer exception when the targetLinks contains a null value for azure load balancer objects.
To workaround the issue:
1. Before proceeding first take a snapshot of the vRealize Automation appliance(s)
2. SSH to the vRealize Automation appliance and login as root user.
3. Connect to the provisioning service postgres database instance: answer yes when prompted.
vracli dev psql provisioning-db
4.validate you are hitting the issue by checking for null entries in the load_balancer_state table of the provisioning service postgres database:
SELECT load_balancer_state.name, endpoint_state.endpoint_type, endpoint_state.name
FROM load_balancer_state
JOIN endpoint_state ON load_balancer_state.endpoint_link = endpoint_state.document_self_link
where load_balancer_state.target_links is null;
5. Update load_balancer_state table so that target_links is non-null for each of the LBs returned by above query that are on endpoints of type azure:
update load_balancer_state set target_links = '[]' where name = 'the LB name returned in preceding Query ';