3640118 - Error "The port must be a number" when validate S/4HANA On-Premise connection in Datasphere

Symptom

When validate the S/4HANA On-Premise connection in Datasphere, below error message is displayed in the details:

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Parameter "Port" invalid: "xxx". The port must be a number. (adapter type: abapodbc, source name:xxx), Code: 5921, SQL State: HY000

Cloud Connector is selected for Data Provisioning Option under Remote Tables section of S/4HANA On-Premise connection to use the ABAP SQL service to federate data with remote tables.

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

Environment

SAP Datasphere

Reproducing the Issue

Select the checkbox in front of the connection to S/4HANA On-Premise.
Click Validate button.

Cause

Virtual host and port of HTTPS protocol mapping is not used in Datasphere connection.

Resolution

Use the virtual host and port of HTTPS protocol mapping (in SCC) in Datasphere connection.

Remote table feature validation fails because it expects to be associated with system mapping defined with protocol HTTP in Cloud connector as explained in previously provided SAP help portal Using ABAP SQL Services for Accessing Data from SAP S/4HANA

"When you want to use a connection for both data or replication flows and remote tables, you need to create two system mapping entries in the Cloud Connector considering the following:

Feature

Protocol

Host

Virtual Host

Virtual Port

Data flow and replication flow

RFC

Enter the same host for both system mapping entries.

Enter the same virtual host for both system mapping entries.

Also, the virtual host must be the same in the Cloud Connector system mapping and in the connection's Cloud Connector properties.

The virtual port is derived from the instance number (system number) entered in the system mapping:

sapgw<system number>.

Remote tables

HTTPS

Enter the same virtual port in the Cloud Connector system mapping and in the connection's Cloud Connector properties.

In the SAP Datasphere Connections app, you must enter the virtual port for the HTTPS protocol and the virtual host in separate fields. Deriving virtual host and port is not supported in the Connections app because of the different virtual ports used in the two system mappings."

Keywords

remote tables, parameter port invalid, sapgw00, connection validation error, odbcforabap, sql state hy000, code 5921, virtual host, virtual port, enter virtual host and port, https configuration , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions