Adding an Exchange DAG fails with the error "Cannot insert a resource container. A database error has occurred"

book

Article ID: 100010543

calendar_today

Updated On:

Description

Error Message

ERROR:   Message: Cannot insert a resource container

ERROR:   Reason: A database error has occurred

ERROR: DataAccessBEServer ResourceContainer_Insert: [ResourceContainer_Save]: Insert ResourceContainer caught an error: The DELETE statement conflicted with the REFERENCE constraint "FK_ResourceContainerGroupAssociation_ResourceContainer". The conflict occurred in database "BEDB", table "dbo.ResourceContainerGroupAssociation", column 'RCKey'.

 

Cause

This may occur if the DAG name is already added as another resource - i.e. cluster resource.

 

Resolution

1. Delete the existing resource container with the DAG name.

2. Re-create the DAG resource by selecting Microsoft Exchange DAG in the "Add Server" wizard.

 


Issue/Introduction

Adding an Exchange DAG (Database Availability Group) fails with the following: Figure 1: If the DAG name (EX-DAG) was used adding another cluster node, then adding the Exchange DAG name (EX-DAG) using the same name will fail with "Cannot insert a resource container. A database error has occurred"