3447819 - Connection validation virtual destination port not valid error - SAP Datasphere

Validating SAP S/4HANA On-Premise connection in Datasphere gets below error for Data Flow and Replication Flow:

Data Flows: Cause: Failed to retrieve connection xxxxxx::RFC::NamedUser. Server responded with 500
Virtual destination port <port> is not valid
Replication Flows: Cause: Failed to retrieve connection xxxxxx::RFC::NamedUser. Server responded with 500
Virtual destination port <port> is not valid

SAP Datasphere

1. Choose the connection in SAP Datasphere.
2. Validate the connection.

Possible Cause 1:

Incorrect protocol used in Cloud Connector.

Possible Cause 2:

Port format incorrect.

Resolution for Cause 1:

For SAP S/4HANA On-Premise connection, data flows, replication flows scenario, please use Protocol RFC in Cloud Connector when adding system mapping information.

For detail information, please see Configure Cloud Connector | SAP Help Portal.

Resolution for Cause 2:

Port format is like sapgw<virtual_instance_number> or sapms<virtualsid>.

"Failed to retrieve connection" "Server responded with 500" , KBA , DS-DI-CON , Connections , Problem