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.
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
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.