Unable to add a NAT Rule in Edge Gateway due the error "query did not return a unique result: 2"

Products

• VMware Cloud Director

Issue/Introduction

• Unable to Add a NAT Rule in an Edge Gateway
• When trying to Add the NAT rule the task fails with the error below:

Internal Server Error - query did not return a unique result: 2

         com.vmware.vcloud.api.presentation.service.internalServerError: Internal Server Error at:
     com.vmware.vloud.common.future.FutureUtil.convertExecutionException(FutureUtil.java: 264)

Environment

VMware Cloud Director 10.5.1.1

Cause

The issue is due to a duplicate entry  in the database for the affected Edge Gateway
The duplicate entry is in the "allocated_ip_address" table.

Resolution

To resolve this issue, please Contact Broadcom Support.
Database modifications are required to remove those duplicate entries and will require VMware Technical Support assistance. 

Additional Information