Unable to add additional disks to the deployment in GCP.

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

New and existing deployments in the Google Cloud Platform endpoint fail when adding additional disk with error similar to:

Cannot invoke "Comparable.compareTo(Object)" because the return value of "function.Function.apply(Object)" is null.

Environment

VMware Aria Automation 8.18.x

Cause

In VMware Aria Automation 8.18 an additional "priority" field was added to the storage profile in the vSphere cloud account.

Resolution

• Create an environment snapshot.
• Connect to the console and access provisioning-db
  
  vracli dev psql
\c provisioning-db;
  
  
• Execute the below query:
  
  UPDATE storage_profile
SET storage_items = (
SELECT jsonb_agg(jsonb_set(item, '{priority}', '"1"', true))
FROM jsonb_array_elements(storage_items) AS item
)
WHERE EXISTS (
SELECT 1
FROM jsonb_array_elements_text(endpoint_links) AS link
WHERE link::text IN (
SELECT document_self_link::text
FROM endpoint_state
WHERE endpoint_type IN ('gcp')
));