Getting error in tMicrosoftCRMInput component

Anonymous — Fri, 11 Mar 2016 09:50:42 GMT

Hi All,
I want to extract and insert data from Microsoft Dynamics CRM (current version 2011) by using components available in the Talend, i.e tMicrosoftCRMInput and tMicrosoftCRMOutput components.
The setting in the components is given below in screen shot:-
CRM version is selected as 2015 instead of 2011 (I am not sure about this.Is it okay to select 2015 instead of 2011?? Depending upon the version the fields gets changed.)

I will provide screen shot for both version respectively.

2015:-

2011:-

The job screen shot is :-

Below is error I am getting when executing the talend job when version is 2015.

and for version is 2011 :-

connecting to socket on port 3805
connected
Exception in component tMicrosoftCrmInput_1
org.apache.axis2.AxisFault: Read timed out
at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:389)
at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:222)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:435)
at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:402)
at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at com.microsoft.crm4.webserviceTest.CrmServiceStub.execute(CrmServiceStub.java:2268)
at garnet_to_crm.demo_0_1.Demo.tMicrosoftCrmInput_1Process(Demo.java:6290)
at garnet_to_crm.demo_0_1.Demo.runJobInTOS(Demo.java:8325)
at garnet_to_crm.demo_0_1.Demo.main(Demo.java:8182)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
at sun.security.ssl.InputRecord.read(InputRecord.java:503)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973)
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930)
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346)
at org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:550)
at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:189)
... 11 more
disconnected

Can anyone who have worked on Microsoft CRM please provide me any possible solution or approach for the issue??
Talend team please guide me for configuring the component??
Awaiting for your response as soon as possible.

Re: Getting error in tMicrosoftCRMInput component

Anonymous — Mon, 14 Mar 2016 01:51:27 GMT

Hi,
From your screenshots, we see that you leave "Trust Certificate" fileld as empty. Is there any Trust Certificate on your end? Does Microsoft Dynamics CRM 2011 work well for you?
Best regards
Sabrina

Re: Getting error in tMicrosoftCRMInput component

Anonymous — Mon, 14 Mar 2016 09:31:38 GMT

Hi Sabrina,
Thanks for your reply.
I am not sure about any Trust certificate?? Microsoft Dynamics CRM 2011 is working well at my end.
I will consult with my network team about the same and let you know.

Re: Getting error in tMicrosoftCRMInput component

Anonymous — Mon, 14 Mar 2016 09:39:13 GMT

Hi Sabrina,
I would like to mention that the "Organization Wdsl URL" is working fine. I am able to access the URL manually .

Re: Getting error in tMicrosoftCRMInput component

Anonymous — Mon, 14 Mar 2016 13:58:58 GMT

Hi Sabrina,
Trust certificate is not needed. It is used to connect securely.

topic Re: Getting error in tMicrosoftCRMInput component in Talend Studio

Getting error in tMicrosoftCRMInput component

Re: Getting error in tMicrosoftCRMInput component

Re: Getting error in tMicrosoftCRMInput component

Re: Getting error in tMicrosoftCRMInput component

Re: Getting error in tMicrosoftCRMInput component