Cannot move a subnet to a correct site

Products

• IT Management Suite

Issue/Introduction

When trying to move a subnet to a correct site the following error is returned:

Subnet is resource associated with more then one site. Subnet:<Subnet GUID> First Site <Site GUID 1>, Additional Site: <Site GUID 2>"

Environment

ITMS 8.x

Cause

There was an association in the CMDB that would not delete.

Resolution

Make a backup of the CMDB before running the query below:

delete from ResourceAssociation

where ResourceAssociationTypeGuid = 'F71ABA8C-8823-44c8-A750-F03DE84DC5F6'

and ParentResourceGuid = '<GUID of the WRONG site>'

and ChildResourceGuid = '<GUID of Subnet>'