SAP Knowledge Base Article - Public

3509849 - 'couldn't be established' error in SAP Datasphere when using Generic SFTP connection

Symptom

While setting up the Generic SFTP connection from SAP Datasphere to SFTP server, the following errors appears:

  • Connection <SFTP NAME> couldn't be established.
    - Data flows can't be used because of errors in the connection.
    - Replication flows are not supported.
    - Remote tables are not supported.
    Data Flows: Cause: Possible causes of error: Detailed error message (hostkey has been changed for remote host (<SFTP URL>))

  • Connection <SFTP NAME>  couldn't be established.
    - Data flows can't be used because of errors in the connection.
    - Replication flows are not supported.
    - Remote tables are not supported.
    Data Flows: Cause: Possible causes of error: Detailed error
    message connection is closed by foreign host)

Environment

SAP Datasphere

Cause

The SFTP hostkey is not set properly in SAP Datasphere.

Resolution

This response is coming from SFTP side and means that the hostkey used by SAP Datasphere is not set properly. To solve the issue ensure the correct hostkey is set in the Generic SFTP Connection configuration using the SAP Help Generic SFTP Connections.

See Also

3456649 - FAQ: Datasphere simple questions
SAP Datasphere - Data Provisioning Agent Guided Answer
SAP Datasphere Troubleshooting Help

Keywords

Sftp, ftp, protocol, matching, host, key, hostkey, pem, certificate, how, to generate, server , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions