Infopath call to GetUserProfileByName

Question

The following is being generated when we call the GetUserProfileByName form a secondary datasource. We generated the problem with a machine with the 3.5 service pack 1.

04/29/2009 14:08:10.84 w3wp.exe (0x0568)                       0x0DAC                Forms Server                     Forms Services Runtime - Data C   82fy       Warning               The following query failed: GetUserProfileByName (User: XXXXX\user, Form Name: PurchaseOrderRequisition, IP: , Request: http://vm-xxx64bi/_layouts/FormServer.aspx?XsnLocation=http://vm-xxx64bi/FormServerTemplates/PurchaseOrderRequisition.xsn&SaveLocation=http://vm-xxx64bi/PurchaseOrder/Form&Source=http://vm-xxx64bi/PurchaseOrder/Form/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:PurchaseOrderRequisition:-myXSD-2008-11-13T08-34-00, Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized.) 294902df-118d-432b-8da3-e58fdc7c9370

Answer 1

It's a permissions issue (401).  Does the call work in Preview mode?

Answer 2

Hi,

I just tried to preview the form using the InfoPath editor and it is still giving the error.

What permissions should be fixed?

The query cannot be run for the following DataObject: GetUserProfileByName
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

The User Profile Manager object could not be loaded. ---> Value cannot be null.
Parameter name: serverContext


Thanks in Advance

Answer 3

Take the path for the web service and paste it into a browser to see if the web methods show up.  If you get an error here, then you know right away that you have an issue with accessing the web service on the web server.  It may be permissions-related, or it may be that you are using the wrong root path (i.e. host header vs server name).

Also, in InfoPath, make sure the data connection has no default data specified for the string:name parameter.  It should automatically send the current user's username by default.

Answer 4

I tried to preview the web methods that are available for the web service in a browser using the url that is available in the shared data source.  At this stage no errors have occured.  Also, the user I am using has Full Trust on the sharepoint website.

I checked the data connection in the InfoPath form to see if it has no default data specified, and this parameter is blank.

Answer 5

I am actually hitting this exact error right now.  PBen, did you solve it?

If not and I do figure it out, I will add a note here.

My case is a little odd... In this situation, there are two web front ends.  It works fine on one WFE but not on the other.

A few weeks ago, someone installed some software on the (now) broken WFE and it's been out of rotation ever since (as other things broke at the time).

---

--Paul Galvin, Arcovis
  Microsoft MVP - SharePoint
  Blogging @ http://feeds.feedburner.com/PaulGalvinsSharePointSpace
  Twitter @ http://www.twitter.com/pagalvin

Answer 6

You could use  userName() function if you are using infopath 2007

Answer 7

You could use  userName() function if you are using infopath 2007

Huh?  I don't think that's relevant to the topic.  The information returned by userName() is simply the information sent to the GetUserProfileByName method when querying.  It is not a replacement for the entire dataset returned by that method.

---

SharePoint Architect - Planet Technologies - 4-Year Microsoft Federal Partner of the Year (2005-2008)

Answer 8

it may help

I read somewhere that if you allow anonymous access you can't use this method without parameter.

when this method is called with no parameter, it replys data of the person who called it

Answer 9

Anytime you make a call to the same server from an InfoPath form, you should think about loopback protection issues.  See the following KB for information:

http://support.microsoft.com/kb/896861 

Following the steps in this article often resolves issues with calling the UserProfile web service from an InfoPath browser form.

 

-N

Answer 10

Hello all,

I am having this same problem. The call to the web service works in Preview but not when published to the site.

The web methods show up when I paste the path in the browser, and there is no default data specified for the string:name parameter. 

I don't know if it could be related but when this didn't work I changed the data source to the SQL database we are using on the currently published .NET form, both setting the connection in the form and by creating a connection library on the site and this works the same way - in Preview but not when published. Also, the error message - Log ID:5566 - doesn't appear anywhere in the server log.

Answer 11

emdodd, did you disable the loopback check on your server like Nick mentioned?

---

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

Answer 12

I got the same problem as Emdodd, disable the loopback ( method 2)  mentioned by Nick works for me, though I didn't restart the server. Thanks

Answer 13

Paul,

did you ever find the solution to the problem? I have the same issue. Works on one WFE not on the other. I´ve disabled the loopback check....

Thanks,

 

David

Answer 14

I have exact same issue as emdodd.  it works fine with preview but error with the published. i have also disabled loop back check. pls somebody shed some  light why this is happening. 

---

Aniket

Answer 15

I had the same issue except it work in one farm and not another. For me it had nothing to do with loopback (it's not disabled on either farm). Its NTLM vs Keberos auth on the webapps. With Kerberos setup it works just fine.

Answer 16

Did you try  setting  form Security Level to "Full Trust" and deploying your form template as administrator approved form ?

Try and see.