topic Re: Netsuite connector - Password must not be null in Talend Studio

Netsuite connector - Password must not be null

Anonymous — Wed, 24 Oct 2018 18:21:59 GMT

Hi - I am using Talend DI 7.0.1. Trying to connect to Netsuite and I am getting the following error.

With Talend 6.3 all works fine but I want to use a more recent version of Talend. Any idea what that "Password must not be null" means? Thank you!

[statistics] connecting to socket on port 3857
[statistics] connected
[WARN ]: org.apache.cxf.transport.https.SSLUtils - Default key managers cannot be initialized: Password must not be null
java.security.UnrecoverableKeyException: Password must not be null
at sun.security.provider.JavaKeyStore.engineGetKey(Unknown Source)
at sun.security.provider.JavaKeyStore$JKS.engineGetKey(Unknown Source)
at sun.security.provider.KeyStoreDelegator.engineGetKey(Unknown Source)
at sun.security.provider.JavaKeyStore$DualFormatJKS.engineGetKey(Unknown Source)
at java.security.KeyStore.getKey(Unknown Source)
at sun.security.ssl.SunX509KeyManagerImpl.<init>(Unknown Source)
at sun.security.ssl.KeyManagerFactoryImpl$SunX509.engineInit(Unknown Source)
at javax.net.ssl.KeyManagerFactory.init(Unknown Source)
at org.apache.cxf.configuration.jsse.SSLUtils.loadDefaultKeyManagers(SSLUtils.java:110)
at org.apache.cxf.configuration.jsse.SSLUtils.getDefaultKeyStoreManagers(SSLUtils.java:83)
at org.apache.cxf.transport.https.SSLUtils.getSSLContext(SSLUtils.java:77)
at org.apache.cxf.transport.https.HttpsURLConnectionFactory.decorateWithTLS(HttpsURLConnectionFactory.java:143)
at org.apache.cxf.transport.https.HttpsURLConnectionFactory.createConnection(HttpsURLConnectionFactory.java:99)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit.createConnection(URLConnectionHTTPConduit.java:122)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit.setupConnection(URLConnectionHTTPConduit.java:126)
at org.apache.cxf.transport.http.HTTPConduit.prepare(HTTPConduit.java:505)
at org.apache.cxf.interceptor.MessageSenderInterceptor.handleMessage(MessageSenderInterceptor.java:47)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:533)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:442)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:343)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:296)
at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:96)
at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:139)
at com.sun.proxy.$Proxy39.getDataCenterUrls(Unknown Source)
at org.talend.components.netsuite.v2014_2.client.NetSuiteClientServiceImpl.getNetSuitePort(NetSuiteClientServiceImpl.java:252)
at org.talend.components.netsuite.v2014_2.client.NetSuiteClientServiceImpl.doLogin(NetSuiteClientServiceImpl.java:131)
at org.talend.components.netsuite.client.NetSuiteClientService.login(NetSuiteClientService.java:783)
at org.talend.components.netsuite.client.NetSuiteClientService.relogin(NetSuiteClientService.java:759)
at org.talend.components.netsuite.client.NetSuiteClientService.login(NetSuiteClientService.java:197)
at org.talend.components.netsuite.NetSuiteEndpoint.connect(NetSuiteEndpoint.java:199)
at org.talend.components.netsuite.NetSuiteEndpoint.connect(NetSuiteEndpoint.java:157)
at org.talend.components.netsuite.NetSuiteSourceOrSink.validate(NetSuiteSourceOrSink.java:71)
at testnetsuite.testnetsuiteconnection_0_1.TestNetsuiteConnection.tNetsuiteConnection_1Process(TestNetsuiteConnection.java:451)
at testnetsuite.testnetsuiteconnection_0_1.TestNetsuiteConnection.runJobInTOS(TestNetsuiteConnection.java:762)
at testnetsuite.testnetsuiteconnection_0_1.TestNetsuiteConnection.main(TestNetsuiteConnection.java:611)
[statistics] disconnected

Re: Netsuite connector - Password must not be null

Anonymous — Sat, 27 Oct 2018 19:43:25 GMT

Hi,

From the error log, I could see that the error is getting generated from the component tNetsuiteConnection_1.

Are you getting connection error for any new job created in 7.0.1 or whether the error is limited to existing jobs which were migrated from 6.3 version?

Could you please share the screen shot of the job and the Netsuite component after masking the confidential details for further analysis?

Warm Regards,

Nikhil Thampi

Re: Netsuite connector - Password must not be null

Anonymous — Wed, 31 Oct 2018 18:21:35 GMT

Hi - This is a brand new job, created from scratch. I have tried different API versions with the same results.

See image attached. Thanks!

2018-10-31_1118.png

Re: Netsuite connector - Password must not be null

Anonymous — Thu, 01 Nov 2018 05:42:07 GMT

Hi,

Could you please pass the value of password into a context variable first and pass the context variable as the value for Netsuite password (as shown below)?

If this also did not help you, could you please raise a support ticket so that they can remotely assist you?

Warm Regards,

Nikhil Thampi

Re: Netsuite connector - Password must not be null

Anonymous — Tue, 06 Nov 2018 15:27:35 GMT

Thanks for the suggestion but that didn't work.

How do I raise a support ticket?

Re: Netsuite connector - Password must not be null

Anonymous — Wed, 07 Nov 2018 00:33:23 GMT

What version of NetSuite are you connecting to? Please check if your component supports that version.

Re: Netsuite connector - Password must not be null

Anonymous — Wed, 07 Nov 2018 02:05:54 GMT

Hi,

With Talend DI 7.0.1, I am having the issue.

With Talend DI 6.4.1, I am not having the issue.

I am using the same API version against the same Netsuite version.

Jocsan

Re: Netsuite connector - Password must not be null

Anonymous — Thu, 08 Nov 2018 08:56:17 GMT

Hi Jocsan,

Apologies for the delay as I was away from office for sometime.

Could you please contact your Customer Success Manager for your Talend account and he will be able to guide you about support case creation process.

Warm Regards,

Nikhil Thampi

Re: Netsuite connector - Password must not be null

Anonymous — Tue, 27 Nov 2018 11:47:56 GMT

Hello @jd-talend from your stacktrace it seems you haven't specified KeyStore for your secure connection to NetSuite.

Please see the similar errors described here:

https://stackoverflow.com/questions/26720402/wsdl2java-warning-default-key-managers-cannot-be-initialized

https://stackoverflow.com/questions/5871279/java-ssl-and-cert-keystore

Regards,

Maksym.