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

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

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> if in Cloud Connector choose without load balancing.

For example:

In "Add System Mapping" screen, use 2-digtal number like 55 for Virtual Instance Number

The final virtual port would be sapgw55.

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