Symptoms:
"Timeout in remote operation after 80 seconds. Operation PATCH..."
[ERROR: duplicate key value violates unique constraint "uq_storage_profile_association_state_storage_item_id_storage_de"...
VMware Aria Automation 8.x
This can be caused by temporary datastore unavailability due to infrastructure issues.
Workaround:
vracli db dump provisioning-db > /tmp/provisioning-db.dump
vracli dev psql provisioning-db
select * from storage_profile_association_state where document_update_action = 'DELETE';
DELETE from storage_profile_association_state where document_self_link in (select document_self_link from storage_profile_association_state where document_update_action = 'DELETE');
select * from storage_profile_association_state where document_update_action = 'DELETE';