Data Insight Fails to add SharePoint Web Application with "ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized."

Article: 100007693
Last Published: 2023-08-30
Ratings: 0 1
Product(s): Data Insight

Problem

Data Insight GUI fails to add SharePoint Web Application with "ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized."

Error Message

2011-11-01 02:00:32 INFO: Discover all sitecollections from webapp http://foo-shareweb/sites/FOO/SiteDirectory/RM
2011-11-01 02:00:35 INFO: It took 2.921875 secs to complete the last operation
2011-11-01 02:00:35 INFO: Exitcode : 0
2011-11-01 10:22:41 INFO: Discover all sitecollections from webapp foo-shareweb:16765
2011-11-01 10:22:41 ERROR: Unable to get sitecollections for webapp foo-shareweb:16765
2011-11-01 10:22:41 ERROR: System.NotSupportedException: The URI prefix is not recognized.
   at System.Net.WebRequest.Create(Uri requestUri, Boolean useUriBase)
   at System.Web.Services.Protocols.WebClientProtocol.GetWebRequest(Uri uri)
   at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebRequest(Uri uri)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.GetWebRequest(Uri uri)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at sharepoint_utilclient.SDIWebSvc.SDIWebService.getSiteCollections(String url)
   at sharepoint_utilclient.sharepoint_utilclient.discoverSiteCollections(Cmdline cmd)
2011-11-01 10:22:42 INFO: It took 0.421875 secs to complete the last operation
2011-11-01 10:22:42 ERROR: Exitcode : 200
2011-11-01 10:22:56 INFO: Discover all sitecollections from webapp http://foo-shareweb:16765
2011-11-01 10:22:59 ERROR: Unable to get sitecollections for webapp http://foo-shareweb:16765
2011-11-01 10:22:59 ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at sharepoint_utilclient.SDIWebSvc.SDIWebService.getSiteCollections(String url)
   at sharepoint_utilclient.sharepoint_utilclient.discoverSiteCollections(Cmdline cmd)
2011-11-01 10:23:00 INFO: It took 3.5 secs to complete the last operation
2011-11-01 10:23:00 ERROR: Exitcode : 200

Cause

The user configured for Data Insight to access the SharePoint, in this case FOO\foosharepoint, was not granted FULL CONTROL permissions. Data Insight will then successfully discover SharePoint Web Application.

Solution

The user configured for DI to access the SharePoint, in this case FOO\foosharepoint, needs to be granted FULL CONTROL permissions.

 

 

Was this content helpful?