A Transport Node error is received when adding a new host to the cluster and if the issue is not resolved within 45 minutes, then the Transport Node Collection state will remain in the unsuccessful state indefinitely.
SDDC-Manager 5.2.1
NSX 4.2
In this particular case, adding the host failed because the Uplink Host Switch Profile had the MTU specified which is expected to be empty. Updating the Uplink Host Switch Profile fixed the issue, but this alone will not update the Transport Node Collection state to success even if all the Transport Nodes are in the success state. The Transport Node Collection state will remain in FAILED_TO_REALIZE.
The user should retry the "Add new host(s) to cluster" operation after fixing the issue which gets the Transport Nodes into success so that the Transport Node State API is called again to recompute the state with the latest Transport Node states.