3447819 - Error "Virtual destination port is not valid" in S/4HANA On-Premise Connection - SAP Datasphere

This KBA applies to SAP Datasphere connections to ABAP-based On-Premise systems (e.g., S/4HANA, ECC, or BW) via SAP Cloud Connector.

The following error occurs for feature data flow and replication flow when validating connection in SAP Datasphere.

Connection "<connection_name>" couldn’t be established.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.

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