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.
VMware Aria Automation 8.18.x
In VMware Aria Automation 8.18 an additional "priority" field was added to the storage profile in the vSphere cloud account.
vracli dev psql
\c provisioning-db;
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')
));