Error creating Active Directory integration in Aria Automation.

Products

• VMware Aria Suite

Issue/Introduction

• The error "query did not return a unique result: 2" occurred when attempting to add an Active Directory integration in a newly created tenant.
• The issue is isolated only to a specific tenant. 

Environment

• VMware Aria Automation 8.x

Cause

• Duplicate entries for the tenant's ORG_ID were present in the ad_abx_config database table, causing the tenant's integration to fail. 

Resolution

1. Take a snapshot and back up all your VRA nodes. 
2. Connect to VRA DB: vracli dev psql
3. Connect to the provisioning-db: \c provisioning-db
4. run the query to delete duplicate rows for the specific tenant's ORG_ID in the ad_abx_config database table using the following SQL command:

DELETE FROM ad_abx_config WHERE org_id='<effected tenant's ORG_ID>';

     5. Add the AD Integration to the tenant again to see if the issue is resolved.