Hi,
We are trying to use SQL Loader connector for provisioning to a CSV file located in the SFTP server. But test connection is getting failed with the error :-
[ ConnectorException ] [ Error details ] Error occurred during test configuration operation. Please check the logs. Error: Failure trying to get a pooled connection to [jdbc:csv:sftp://40.91.222.201/import] java.sql.SQLException: 4: at com.jcraft.jsch.ChannelSftp._lstat(ChannelSftp.java:2346) at com.jcraft.jsch.ChannelSftp.lstat(ChannelSftp.java:2312) at com.hxtt.e.bf.i(Unknown Source) at com.hxtt.e.bf.ch(Unknown Source) at com.hxtt.e.m.ck(Unknown Source) at com.hxtt.sql.b5.a(Unknown Source) at com.hxtt.sql.text.h.(Unknown Source) at com.hxtt.sql.text.EmbeddedDriver.connect(Unknown Source) at com.caigen.sql.b.a(Unknown Source) at com.hxtt.sql.HxttDriver.if(Unknown Source) at com.hxtt.sql.HxttDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:92) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:883) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:436) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at sailpoint.connector.util.DBCPPoolVersion2.getPooledConnection(DBCPPoolVersion2.java:154) at sailpoint.connector.util.JDBCUtilFactory.getJDBCImpl(JDBCUtilFactory.java:24) at sailpoint.connector.util.JDBCUtil.getConnection(JDBCUtil.java:287) at sailpoint.connector.JDBCConnector.getConnection(JDBCConnector.java:2188) at sailpoint.connector.JDBCConnector.testConfiguration(JDBCConnector.java:320) at sailpoint.connector.ConnectorProxy.testConfiguration(ConnectorProxy.java:399) at com.sailpoint.ccg.cloud.container.Container.testConnection(Container.java:312) at com.sailpoint.ccg.cloud.container.ContainerIntegration.ping(ContainerIntegration.java:73) at com.sailpoint.ccg.handler.TestConnectionHandler.invoke(TestConnectionHandler.java:29) at sailpoint.gateway.accessiq.CcgPipelineMessageHandler.handleMessage(CcgPipelineMessageHandler.java:26) at com.sailpoint.pipeline.server.PipelineServer$InboundQueueListener$MessageHandler.run(PipelineServer.java:369) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.io.IOException: Pipe closed at java.io.PipedInputStream.read(PipedInputStream.java:307) at java.io.PipedInputStream.read(PipedInputStream.java:377) at com.jcraft.jsch.ChannelSftp.fill(ChannelSftp.java:2909) at com.jcraft.jsch.ChannelSftp.header(ChannelSftp.java:2935) at com.jcraft.jsch.ChannelSftp._lstat(ChannelSftp.java:2327) … 34 more
We are able to connect to SFTP server from Virtual appliance using putty. Please let us know what is the issue here.
Thanks,
Mahesh