Error creating Active Directory integration in Aria Automation.
search cancel

Error creating Active Directory integration in Aria Automation.

book

Article ID: 383044

calendar_today

Updated On:

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.