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

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." 

SAP Datasphere

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