Deployment of NSX VMs fail

Products

• VMware NSX for vSphere

Issue/Introduction

Symptoms:

• Deployment of NSX VMs fail.
• The NSX Manager logs contains entries similar to:
  
  2018-02-09 09:24:39.053 GMT ERROR ViInventoryThread SqlExceptionHelper:131 - ERROR: duplicate key value violates unique constraint "domain_object_relationships_pkey"
   Detail: Key (source_id, target_id, relationship)=(dvportgroup-1775, 5019ac82-xxxx-xxxx-xxxx-2fb4f13a8d26.000, dependent_dependency) already exists.
   
  Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment. 

Environment

VMware NSX for vSphere 6.4.x

Cause

This issue occurs because of corruption in the NSX Database.

Resolution

To resolve this issue, contact Broadcom Support and note this Knowledge Base article ID (319562) in the problem description. 

Workaround:
To work around this issue:

• Ensure there are no third party scripts on the appliance running that are making changes ot the NSX Database.
• There are no manual changes done on the NSX Database.