Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Getting error in tMicrosoftCRMInput component

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:-
0683p000009MDWr.png
2011:-
0683p000009MD7X.png
The job screen shot is :- 
0683p000009MDFb.png
Below is error I am getting when executing the talend job when version is 2015.
0683p000009MDRc.png
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.
Labels (3)
4 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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

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