Skip to main content

I used NTLM authentication in FME Desktop back in 2018/2019 with no problem. Now with FME 2020, it no longer works.

 

I am able to set up the reader fine:

Capture0-SharePoint-Reader-Setup

and select my List(s) with no authorization issues:

Capture1-selecting List

However, at run time, or when trying to inspect the data, it fails!

 

Microsoft SharePoint List Reader: Client-side error: '404 Client Error: Not Found for url: https://ecollab.ncr.int.ec.gc.ca/theme/OPG-1A1-1A2/priv/SAR_Recovery/_api/web/Lists(guid'2b88722b-bee9-40ff-8520-2321259e8a20')/Items?%24select=Title%2CChild%2CParent_x0020_not_x0020_to_x0020_%2CParent_x0020_COSEWIC_x0020_ID%2CParent_x0020_2_x0020_COSEWIC_x00%2CChild_x0020_1_x0020_COSEWIC_x002%2CChild_x0020_2_x0020_COSEWIC........................'

returned from SharePoint. Error message was: ''

A fatal error has occurred. Check the logfile above for details

Failed to specify the feature index as constraints on the reader.

 

As mentioned, I am using the very latest version of FME (just upgraded to try an fix this)..

FME(R) 2020.1.3.0 (20201001 - Build 20632 - WIN64)

 

Regards,

 

Dave

Update: I am able to access all the other Lists. Just not this one. I read some documentation that mention a calculated field which causes access issues. But it does not say which field. Any guidance on this would be appreciated. I cannot find any information on this anywhere..


Hi @david.benoit​ 

I'm not sure if you saw @danatsafe​  response on this post. It would be useful to raise a support case so that we can investigate further. On the other thread it mentioned that it could be due to url length so you could check/compare that to other lists that you can read.


Hi @david.benoit​ 

I'm not sure if you saw @danatsafe​  response on this post. It would be useful to raise a support case so that we can investigate further. On the other thread it mentioned that it could be due to url length so you could check/compare that to other lists that you can read.

Hi @jlutherthomas​ .

 

This is a different issue then the one explained in the post where, when selecting only 2 attributes out of the large list of user attributes:

 

capture3 - Select 2 User attributes

it still makes no difference and throws a 401 error. Unlike the other user who got a 404 error and was able to resolve by selecting fewer attributes to shorten the URL.

 

capture 4 - result of clicking Inspect

 

I will look into submitting a support case.

 

Thanks.

 

 


Hi @jlutherthomas​ .

 

This is a different issue then the one explained in the post where, when selecting only 2 attributes out of the large list of user attributes:

 

capture3 - Select 2 User attributes

it still makes no difference and throws a 401 error. Unlike the other user who got a 404 error and was able to resolve by selecting fewer attributes to shorten the URL.

 

capture 4 - result of clicking Inspect

 

I will look into submitting a support case.

 

Thanks.

 

 

Thanks for the info. If it's a 401 my first recommendation would be to verify the permissions in Sharepoint. A 401 means unauthorized so this means your user doesn't have permissions to access that list.


Hi @jlutherthomas​ .

 

This is a different issue then the one explained in the post where, when selecting only 2 attributes out of the large list of user attributes:

 

capture3 - Select 2 User attributes

it still makes no difference and throws a 401 error. Unlike the other user who got a 404 error and was able to resolve by selecting fewer attributes to shorten the URL.

 

capture 4 - result of clicking Inspect

 

I will look into submitting a support case.

 

Thanks.

 

 

Yes it is a strange error since I am able to get data from other Lists in the same site using the SharePoint reader in fme.

Also, I am able to access the list in question through a browser.

 

Others with similar issues:

 

https://community.safe.com/s/question/0D54Q000080haFhSAI/sharepoint-issues-401

 

http://webcache.googleusercontent.com/search?q=cache:chrBXnkyzh8J:54.148.242.17/questions/51787/sharepoint-ntlm-authentication-401-client-error-un.html+&cd=4&hl=en&ct=clnk&gl=ca

 

Doesn't make any sense. Especially since its only that one particular List.

 

I have submitted a ticket so I guess we will see. The issue has gone unresolved for about 6 months.


Reply