Getting SFTP error for data source

[Ravish Shetty]

Hello,

We are getting below error when trying to retrieve a file from SFTP.

Surprisingly this same data source works fine in Development but not in our QA servicenow environment. I manually entered the password in the data sources in both Development and QA data sources. These data sources do not use MID servers.

Edit: Issue is sporadic in QA right now. it works some times and does not work other times.

Thanks,

Ravish

[Tanushree Maiti]

Issue

SFTP data source connection fails with the error - com.glide.db.impex.datasource.DataSourceException: java.io.IOException: SSH authentication failed, SSH connected, but user not authenticated

Cause

 SFTP data source connection with SSH key-based authentication' is not supported by ServiceNow .

 

Resolution

 SFTP data source connection with SSH key-based authentication' is not supported by ServiceNow .

Use 'Username' and 'Password' authentication mechanism instead.

An Alternative would be to use the integration hub SFTP Step.

According to the documentation for SFTP step when using the sftp step  private key authentication can be used through the mid server.

Refer: KB0858701 SFTP data source connection fails - com.glide.db.impex.datasource.DataSourceException: jav... 

Also refer:

https://www.servicenow.com/community/servicenow-ai-platform-forum/ssh-authentication-or-connection-f...

[Ravish Shetty]

Hello,

We are using username and password for SFTP here. It works in Development servicenow and not in QA using the same credentials.

We do not have SFTP in integration hub so unfortunately cannot use it.

[Ravish Shetty]

bump