Error creating Active Directory integration in Aria Automation.
book
Article ID: 383044
calendar_today
Updated On: 11-28-2024
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
- Take a snapshot and back up all your VRA nodes.
- Connect to VRA DB:
vracli dev psql
- Connect to the
provisioning-db: \c provisioning-db
- 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.
Feedback
Was this article helpful?
thumb_up
Yes
thumb_down
No