VCLS VMs failed to deploy in cluster with error "duplicate key value violates unique constraint "hdcs_cluster_agencies_pkey""

Products

• VMware vCenter Server

Issue/Introduction

Failed to deploy VCLS VMs in cluster(s)

Retreat mode is not enabled in the cluster 

wcpsvc.log shows corruption in the database 

T##:##:##.000Z info wcp [eamagency/create.go:69] [opID=vCLS] Started creating agency for cluster domain-c#####

T##:##:##.000Z error wcp [eamagency/create.go:91] [opID=vCLS] Unable to create entity in db for cluster agency: pq: duplicate key value violates unique constraint "hdcs_cluster_agencies_pkey"

 

Cause

This is due to corruption in database as the VCLS agencies were manually deleted through EAM API or other way.

Resolution

Please open a support case with Broadcom Support and refer to this KB article to resolve the issue