3726340 - Error: "hostkey has been changed for remote host (<Virtual host>:<Virtual port>)" in Datasphere

The connection type is Generic SFTP. When validating connection, the following error occurs:

--------------------------------------------------------------------------------
Connection "xxx" couldn’t be established. 
- 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 not supported.

Data Flows: Cause: Possible causes of error: Detailed error message (hostkey has been changed for remote host (<Virtual host>:<Virtual port>))
Replication Flows: Cause: Possible causes of error: Detailed error message (hostkey has been changed for remote host (<Virtual host>:<Virtual port>))

Correlation ID: xxxxxx
--------------------------------------------------------------------------------

SAP Datasphere

Incorrect Host Key

1. Verify if the host and port are the same between Datasphere and SAP Cloud Connector.
2. On the local device where the SFTP service is installed, enter the following code to check the host key:
   • `ssh-keyscan -p $PORT $HOST` (The host and port here should be the same as those mentioned in step 1.)
3. Enter the host hey obtained in step 2 into Datasphere connection.
4. Validate connection.

DS, DSP, DWC, Cloud, On-premise , KBA , DS-DI-CON , Connections , CA-DI-EMB , Data Intelligence Embedded in Data Warehouse Cloud , Problem