com.glide.db.impex.datasource.DataSourceException: com.sshtools.j2ssh.transport.TransportProtocolException: The connection did not complete

[jamieliao]

I am trying to setup a data source using sftp as file retrieval method, and got "com.glide.db.impex.datasource.DataSourceException: com.sshtools.j2ssh.transport.TransportProtocolException: The connection did not complete" error immediately when I "load first xx records"

the same user and authentication password works fine under SSH client, but gets above error when execute from ServiceNow.

Anyone experienced the same error, and is there anyone has attempted SFTP data source with successful experience?

[Dan Hinrichs · Accepted solution]

Hi- I had the same problem.  Setting system property "com.glide.sftp.use_snc" to TRUE corrected the problem for me.

[jamieliao]

Thanks, it works !!!

[saikrishnag3019]

I dont see that system property

[VaranAwesomenow]

It depends on type of data source load type while in this case its sftp it can also be other type such as REST (Integration hub) in which case if below error occurs it means that following fields are not setup correctly and the action to fetch REST JSON response is not working as configured.

com.glide.processors.ImportProcessorWorker: com.glide.db.impex.datasource.DataSourceException: com.glide.db.impex.datasource.stream.StreamDataSourceException: No stream loader support for :: com.glide.processors.ImportProcessorWorker.loadDataSource(ImportProcessorWorker.java:203)
com.glide.processors.ImportProcessorWorker.startWork(ImportProcessorWorker.java:110)
com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126)
com.glide.worker.HierarchicalProgressWorker.startAndWait(HierarchicalProgressWorker.java:26)
com.glide.worker.BackgroundProgressJob.execute(BackgroundProgressJob.java:59)
com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:129)
com.snc.db.data_replicate.replicator.DataReplicationAdvisors.runInOriginatorContext(DataReplicationAdvisors.java:73)
com.glide.schedule.JobExecutor.lambda$inDataReplicationContext$2(JobExecutor.java:159)
com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:132)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:116)
com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:338)
com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:220)
com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:220)
com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:101)