Symptom
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
Environment
SAP Datasphere
Reproducing the Issue
- Choose the connection in SAP Datasphere.
- Validate the connection.
Cause
Possible Cause 1:
Incorrect protocol used in Cloud Connector.
Possible Cause 2:
Port format incorrect.
Resolution
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>.
Keywords
"Failed to retrieve connection" "Server responded with 500" , KBA , DS-DI-CON , Connections , Problem