NSX Manager Shows "Not Available" in SDDC Manager Due to Database "ERROR" State

Products

• VMware SDDC Manager / VCF Installer

Issue/Introduction

Within VMware Cloud Foundation (VCF), the NSX cluster displays as "Not Available" under Services in the management domain of the SDDC Manager UI.
The /var/log/vmware/vcf/operationsmanager/operationsmanager.log records the following connection failures:

YYYY-MM-DDT:HH:MM:SS.###+0000 DEBUG [vcf_om,################################,####] [c.v.v.c.n.s.c.c.ApiConnection,om-exec-25] Created ApiClient connection to: #################
YYYY-MM-DDT:HH:MM:SS.###+0000 ERROR [vcf_om,################################,####] [c.v.v.c.n.s.c.c.ComplexHelpers,om-exec-25] Exception occurred during NSX API invocation
java.util.concurrent.ExecutionException: com.vmware.vapi.std.errors.Unauthorized: Unauthorized (com.vmware.vapi.std.errors.unauthorized) => {
    messages = [],
    data = struct => {error_message=The credentials were incorrect or the account specified has been locked., error_code=403, module_name=common-services},
    errorType = UNAUTHORIZED
}

Environment

SDDC Manager 5.x

Cause

SDDC Manager could not log into the NSX Manager due to an incorrect password or a locked account.
Because of this login failure, SDDC Manager marked the NSX Manager with an ERROR status in its internal database, causing it to display as "Not Available" in the user interface.

Resolution

To resolve this issue, the NSX entry must be changed to "ACTIVE" in the SDDC Manager database.

Please contact the Broadcom team for further assistance.

KB for reference: Creating and managing Broadcom cases