Skip to main content

Hi ,

I am creating a new Connection  with SFTP protocol and trying to connect to the SFTP server using a private key .

I inputted these while creating the Connection:

Authentication as Private Key ,

Private Key provider as plain text 

Private Key as the text that i copied from the ppk file 

Username the correct one 

there was no Passphrase

and when i hit Test Connection I get the below error

Stage 'com_streamsets_pipeline_lib_remote_RemoteConnectionVerifier_01' initialization error: java.lang.NullPointerException: Cannot invoke "net.schmizz.sshj.userauth.keyprovider.KeyProvider.getPublic()" because "this.kProv" is null (CONTAINER_0701)

 

But alternatively if i input the same in the credentials tab of the pipeline and preview ,I am able to successfully connect to the sftp server and read the file there .

 

Problem is when i create the same via a connection 

Kindly help me to resolve this issue .

​@Sri25, can you please verify:

  1. that you are not including the header and footer information?
  2. That any carriage returns in the file are removed from the value entered in the connection?

Beyond these simple foundational troubleshooting steps we would require a lot more information than what you provided. For example, what are examples of the values (not the real values, mind you), what technology are you trying to connect to (e.g., Snowflake, JDBC connection, etc.), and the value for the intended connection target (e.g., say a JDBC URL is what you are using you could post something for us like jdbc❄//<intentionally-removed>.snowflakecomputing.com/ so that we can look up any requirements the target might have that are unusual.

Best of luck!

Reply


Terms & Conditions