topic Re: Issue encountered while calling Sharepoint Webservice using tSoap in Talend Studio

Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 02:45:06 GMT

Hello,
I am trying to call a Sharepoint 2010 webservice from TOS5.2 using tSoap. I think I setup tSoap correctly and I was able to access the sharepoint using the same credentials from a web browser.
My problem is that I am getting java.io.IOException: Authentication failure whenever I run this job.
I hope someone can help me on this as I'm finding it hard to google for anything related to this topic. The resources that I found are not helpful at all and most of them are still open.
Thanks,
Josephine

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 03:19:00 GMT

Hi,
I cannot navigate to the link you provided in screenshot. Do I make something wrong with that? There is a technology article on Talend Help centerhttps://help.talend.com/search/all?query=tSOAP&content-lang=en.
Hope it will help you.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 03:41:26 GMT

Hi Sabrina,
That link only works within the company. But I was able to access it from my computer..
I'll read the link that you sent.
Can you do me a favor please.. will you be able to edit out the sharepoint link from your reply? I forgot to remove it from the screenshot.
Thanks!

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 03:48:29 GMT

Hi,
I have edited out the link. Sorry for the disclosure, i don't mean that. We need have a discussion with our component colleagues about your issue and give you the response asap.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 03:57:43 GMT

Thanks Sabrina..
I think the issue is something to do with NTLM authentication. All my parameters are correct (domain,username,password) but the ntlm class that Talend is generating seems to fail..
Looking forward to your colleague's reply..

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Wed, 16 Jan 2013 07:34:44 GMT

Hi, JOSEPHINE
How about unchecked the option of "Use NTLM" to see if the issue still repro. So far, there is no response given to me.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Thu, 17 Jan 2013 01:24:04 GMT

Hi Sabrina,
I unchecked "Use NTLM" but encountered the same 'Authentication' error:

Jan 17, 2013 11:50:48 AM com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Exception in component tSOAP_1
com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
	at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(Unknown Source)
	at org.talend.soap.SOAPUtil.invokeSOAP(SOAPUtil.java:110)
	at comp.soap_0_1.soap.tSOAP_1Process(soap.java:481)
	at comp.soap_0_1.soap.runJobInTOS(soap.java:793)
	at comp.soap_0_1.soap.main(soap.java:658)
Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
	at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(Unknown Source)
	... 5 more
Caused by: java.io.IOException: Authentication failure
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection$6.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.net.www.protocol.http.HttpURLConnection.getChainedException(Unknown Source)
	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.net.HttpURLConnection.getResponseCode(Unknown Source)
	... 6 more
Caused by: java.io.IOException: Authentication failure
	... 8 more

I hope someone can help on this..
Thanks!

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Fri, 18 Jan 2013 07:54:40 GMT

Hi, JOSEPHINE
I got a response from our Component team. Something wrong with your "Use NTLM" , and it is a protocol which protect your message from interruption and disclosure. What' more, it must be used with "user name and password".
It would be IP address or the client name. Would you mind checking your NTLM again? Sorry for the delay.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Mon, 21 Jan 2013 00:04:41 GMT

Hi Sabrina,
I changed the "Use NTLM -> Domain" to my domain's IP address and also provided my username and password. But I still get the same error -> Authentication failure. Attached is the setting of my tSoap component using the IP address.
Do you have a screenshot of the 'correct' settings that I should use?
Thanks,
Josephine

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Mon, 21 Jan 2013 02:17:09 GMT

Hi,
All the tSoap scenarios have been kept in tSOAP which i have given to you. BTW, i have search it by Mr.goole http://en.wikipedia.org/wiki/NTLM. Hope it will help you.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Mon, 21 Jan 2013 22:30:55 GMT

Hi Sabrina,
The link for tSoap documentation has no scenario that's using NTLM authentication:
https://help.talend.com/search/all?query=tSOAP&content-lang=en
Just out of interest, was the component creator/developer ever been able to use this feature ('Use NTLM with authentication')? I am leaning to the conclusion that I've just hit a bug.
Thanks!

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Tue, 22 Jan 2013 03:01:46 GMT

Hi,

was the component creator/developer ever been able to use this feature ('Use NTLM with authentication')

They have used the feature before but everything is OK without documentation.
Two issues need to be confirmed
1. Make sure your certification is NTML, there is anther certification kerberos provided by Microsoft .
2. Attention that endpoint is not the WSDL location, but should be the location of the server defined in the wsdl.
Very Sorry for wasting your long time on this issue.
Best regards
Sabrina

Re: Issue encountered while calling Sharepoint Webservice using tSoap

c0utta — Tue, 05 Feb 2013 04:08:56 GMT

Hi Josephine,
I spent a long time struggling with a similar issue with our Sharepoint installation, but NTLM authentication does work.
My main problem was that I didn't actually have access to the objects on Sharepoint itself, thus I was receiving authentication errors.
I used Soap 1.2, but here's my code:

<soap12:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap12='http://www.w3.org/2003/05/soap-envelope'>
  <soap12:Body>
    <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>
	<listName>Contracts</listName>
	<viewFields><ViewFields><FieldRef Name='EncodedAbsUrl' /></ViewFields></viewFields>
	<rowLimit>0</rowLimit>
	<query>
		<Query>
			<Where><Eq><FieldRef Name='Modified' /><Value Type='DateTime'><Today /></Value></Eq></Where>
			<OrderBy><FieldRef Name='Title' /></OrderBy>
		</Query>
	</query>
	<QueryOptions>
   		<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>
   		<DateInUtc>TRUE</DateInUtc>
	</QueryOptions>
    </GetListItems>
  </soap12:Body>
</soap12:Envelope>

Cheers

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Tue, 04 Mar 2014 13:14:20 GMT

hello,
I am trying to call a webservice from TOS5.3 using tSoap. I setup tSoap correctly and I was able able to send soap message but when i send soap message body greater than 45000 lines then it generate exception.
my Talend job is similar to above one but athentication failure is already solved
My problem is that I am getting Caused by: java.io.IOException: Error writing to server whenever I run this job.
I hope someone can help me on this as I'm finding it hard to google for anything related to this topic. The resources that I found are not helpful.
code
connecting to socket on port 3477
connected
mrt 04, 2014 11:32:44 AM com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Exception in component tSOAP_1
com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed at com.su

To see the whole post, download it here
OriginalPost.pdf

Re: Issue encountered while calling Sharepoint Webservice using tSoap

Anonymous — Thu, 11 Jun 2015 17:33:13 GMT

Hi,
was the component creator/developer ever been able to use this feature ('Use NTLM with authentication')

They have used the feature before but everything is OK without documentation.
Two issues need to be confirmed
1. Make sure your certification is NTML, there is anther certification kerberos provided by Microsoft .
2. Attention that endpoint is not the WSDL location, but should be the location of the server defined in the wsdl.
Very Sorry for wasting your long time on this issue.
Best regards
Sabrina

Hi Sabrina!
Just tried the 5.6.2 version --- NTLM auth still no work.
Can you please give me a link to the bug in the bugtracker?