3328468 - Datasphere HANA On-Premise connection Data Flow or Replication Flow error Remote source is down

You are using Cloud Connector to connect HANA Database (on-premise) with SAP Datasphere. Getting below error when validating HANA connection in SAP Datasphere, even though HANA Database is up and running.

Connection "XXXX" is valid, but not all features are available.
- Data flows can't be used because of errors in the connection.
- Replication flows can't be used because of errors in the connection.
- Remote tables are enabled.

Data Flows: Cause: Remote source is down! Code:1
Replication Flows: Cause: Remote source is down! Code:1

"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. Log into SAP Datasphere --> Connection
2. Select the connection and click "Validate" button.
3. Get the above message in symptom.

Cause 1: Virtual host and port are not same as internal host and port. Please note that if you are using option 'derive virtual host and port from connection details', you need to make sure that host and port details used in connection should match the virtual host and port in cloud connector.

Cause 2: The location ID in the SAP Cloud Connector is not same as the Location in connection.

Solution for Cause 1:

In the Cloud Connector, there are Virtual Host and Virtual Port as well as Internal Host and Internal Port.

Please make sure the virtual host and port are same as defined in Cloud Connector.

Solution for Cause 2:

Please make sure the Location in connection is same as Location ID defined in Cloud Connector. Check if any typos.

• SAP HANA Connections | SAP Help Portal
• SAP Note 3330354 - SCC Connections Troubleshooting for Datasphere and Data Intelligence

KBA , DS-DI-CON , Connections , Problem