ADF Linked Service Logging Table Location

Question

I'm creating an ADF linked service to an sftp with a key and passphrase. Where is the logging table for troubleshooting? This is the error when I test the linked service when creating it.
Invalid Sftp credentials provided for 'SshPublicKey' authentication type. Invalid data type, INTEGER(02) is expected, but was 32 Activity 10

Answer 1

Hi Isa Bella,

Thank you for posting query in Microsoft Q&A Platform.

The error message indicates that the SFTP server is expecting an INTEGER(02) data type for the SshPublicKey authentication type, but it received a 32 data type instead.

To troubleshoot this issue, you can try the following steps:

Verify that the SFTP credentials you provided are correct. Make sure that the key and passphrase are correct, and that they match the credentials that you use to access the SFTP server.

Check the data type of the SshPublicKey authentication type. The SFTP server may be expecting a different data type than what you provided. You can check the SFTP server documentation or contact the SFTP server administrator to verify the correct data type.

1. Check the configuration of the SFTP server. The SFTP server may be configured to only accept certain data types for the SshPublicKey authentication type. You can check the SFTP server documentation or contact the SFTP server administrator to verify the correct configuration.

Check the network connectivity between the Azure Data Factory instance and the SFTP server. There may be network issues that are preventing the Azure Data Factory instance from connecting to the SFTP server. You can try pinging the SFTP server from the Azure Data Factory instance to verify the network connectivity.

1. Try using a different authentication type. If the SshPublicKey authentication type is not working, you can try using a different authentication type, such as Password or SshPrivateKey.

Hope this helps. Please let me know how it goes. Thank you.