InfoPath Dev

I am having this problem and can't pin point the error!

Everything was working fine with people using browser based forms using resolveprincipals to get their display name, manager name, department etc from sharepoint profiles then Friday or Saturday it stopped working.

The only two thing that has happened since then was some hotfixes /.net 3.5 service packs were installed on Saturday night. The machine was rebooted early hours of Sunday morning and it's been broken since then.

I can't uninstall any of the hotfixes / .net3.5 install unless I know it is specifically which is causing the problem as it will require kicking everyone off the system to do it. In the mean time we have no timesheets, expenses, holiday requests etc. as they all use resolve principals to work.

I tried using fiddler to snoop the webservice to see why it was failing to talk to the webservices but didn't get any obvious answers (never used it before)

The error I get on the form is

An error occurred accessing a data source.

An error occurred accessing a data source.

An error occurred accessing a data source.

Some rules were not applied.

The \LOGS\ folder says something slightly more useful

02/02/2009 11:14:43.30  w3wp.exe (0x1428)                        0x0810 Forms Server                   Forms Services Data Objects    13zh Exception  System.Net.WebException: The remote server returned an error: (401) Unauthorized.     at System.Net.HttpWebRequest.GetResponse()     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, Solution solution, Document document, String name, Boolean isQuery, DataAdapterTimer dataAdapterTimer, DataAd... 91903a1a-8b2b-4702-88ac-d94bdea0f396
02/02/2009 11:14:43.30* w3wp.exe (0x1428)                        0x0810 Forms Server                   Forms Services Data Objects    13zh Exception ...apterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf) 91903a1a-8b2b-4702-88ac-d94bdea0f396
02/02/2009 11:14:43.30  w3wp.exe (0x1428)                        0x0810 Forms Server                   Forms Services Runtime - Data C 82fy Warning  The following query failed: GetUserProfileByName (User: DOMAIN\user, Form Name: Timesheet, IP: , Request: http://server/_layouts/FormServer.aspx?XmlLocation=/Intranet/HR/Timesheets/Development+Timesheet-2009-01-26-User+Name.xml&Source=http://server/Intranet/HR/default.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:Timesheet:-myXSD-2007-10-22T10-46-46, Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized.) 91903a1a-8b2b-4702-88ac-d94bdea0f396

The event viewer on the server doesn't show anything at all.

It looks like permissions problem but suggestions on the net that I've tried such as turning off anonymous access are moot points because they aren't already on, authentication type is set to NTLM (we are authenticating against AD) and switching to Kerboros just breaks any access to the server at all.

I am really stumped and just need ideas on which way to focus with this. Anyone installed last week's hotfixes/updates and had this problem? Did they switch on some obscure security option that is breaking the permissions to browser based webservice data connection calls ?

Many thanks for any advice you can offer!

For anyone else who has this problem the cause was .net 3.5 sp1 - the fix for me was to add a key to the registry to disable authentication double lookup, haven't got the link to hand but resolved it on the 2 servers I tested it on... good old microsoft patches... nice day wasted there.

 [edit]

Use fiddlertool or any other http analyzer and check if you see   UserGroup.asmx made from the client
If you dont see UserGroup.asmx request on the client Follow this KB http://support.microsoft.com/kb/926642

Method 1: Disable the authentication loopback check

Re-enable the behavior that exists in Windows Server 2003 by setting the DisableLoopbackCheck registry entry in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa registry subkey to 1. To set the DisableLoopbackCheck registry entry to 1, follow these steps on the client computer:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Exit Registry Editor.
8. Restart the computer.

Thanks so much for posting this! Thanks to you and The Google I only lost about an hour :).

This was driving me crazy - I have two environments going, identical code in both, one worked fine, one got the 401 error for the call to GetUserProfileByName from my InfoPath from. Guess which environment I try to keep up to date with security patches...

 YMMV, but I didn't even have to reboot after making the change - I just enabled the DisableLoopbackCheck flag in the registry and my call to the webservice worked fine.

 Thanks again.

 - Andy

 Glad it helped, that service pack screwed up so many systems - not just SharePoint related, can't believe MS let it out of their door! If anyone knows a solution that doesn't involve a reghack, can they post it please? (i.e. perhaps a better technique for pulling this info into infopath browser based form)

Thank you for posting this.  We were behind on Microsoft patches so our server admin group installed about 18 patches at once.  Our search stopped working and the forms with the XML connections quit working.  Luckily I had some older versions that didn't use the XML data connection so we were able to get by.  After a couple of weeks of troubleshooting, this has fixed the connection error and also has cleared up some of the errors showing up in our event logs.

Thanks again,

E

Hello, I googled and found this thread and tried this solution.  Thanks for posting this -- it works fine.

**However, once I had added this registry key in my development farm and got my form to work (without error 5566), the fix seems to be permanent -- i.e., I subsequently removed the registry key, rebooted the farm servers, and my form continued to work. 

If anyone knows why, can they post additional info?  Thanks. 

 Hi all

this error occurred when info path form can't connect with users profile (XML web service doesn't work) to prevent this you should add a new URL path in the alternate access mapping.

you should set your computer name as default Zone and in the internet zone use the ip address.

EX

URL http://sharePointServerName/    Zone Default

URL  http://192.168.1.1(Server IP)/    Zone Internet

 Hi all,

My form works fine in preview mode but got this error after published to sharepoint (open in browser):

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:5566

I made all the suggestion in here but still my infopath is showing this error

Check your dataconnections on infopath, i had the same problem and one dataconecction wich recived data from sharepoint was broken, so i deleted it and my problems ended.

Regards.

Hi,

I am facing the same issue. I have checked all the required settings as mentioned here. Inspite of all the setting it gives me this error.

Can anyone please help me to resolve this issue.

thanks

Madhura

Pls go to the gropup which one your are trying to check the user.

group setting and make the who can view the membership of the group. Make every one..

Don't try other option.. it is working for me..

we are using custom workflow which internally using infopath form in sharepoint site.

i tired all the ways mentioned in this article but still getting 401 unathorized exception. when tired to open infopath form by using custom link http:servername:port i was able to open,but when i tried to open infopath form using intranet link https://sitename it is giving unauthorized exception. disabled authentication loopback check also but no use.

this is the error we are facing

Runtime - Data Connections     eq8l Warning  The following query failed: GetUserCollectionFromGroup (User: CTS\251388, Form Name: OmegaRegistrationApprovalFormPublishV2New, IP: , Connection Target: https://codenizant/codenizant/CodenizantDataConnectionLib/GetUserCollectionFromGroup.udcx, Request: https://codenizant/_layouts/WrkTaskIP.aspx?List=9117def0-c23d-4059-bacd-dfd63f4443dd&ID=13941&Source=https://codenizant/codenizant/Lists/Tasks/BFS_ParentAccount_AMEX_APPROVERS_VIEW.aspx&ContentTypeId=0x01080100C9C9515DE4E24001905074F980F9316000D0D4B6B291B4254EB578BA89B68EBF6F&IsDlg=1, Form ID: urn:schemas-microsoft-com:office:infopath:OmegaRegistrationApprovalFormPublishV2New:-myXSD-2011-11-21T09-54-33 Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server returned an error: ... f14bba80-68c9-426f-b0e5-e98aef12cdf0

could you please help me on this.