itaysk

Great post! It works like a charm on InfoPath 2007.

BUT when you publish this form on a SharePoint (MOSS 2007) server and tries to use it, it gives you an error. The same form worked without any issues before.

1. Go to my Expenses Form Library on MOSS.

2. Click on New -> New Document. The InfoPath Forms Services load (Loading Form...) and then a dialog box appears on the browser that says:

Warning

There has been an error while processing the form.

Click Continue to resume filling out the form. You may want to check your form data for errors.

Click Start Over to load a new copy of the form.

Show error details

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

3. I have two options to click: CONTINUE or START OVER. Clicking on CONTINUE will loop from point 1 to point 3 (this point). That is, the error doesn't go away. By clicking on continue, the form loads, but the field where the employee name should be is empty.

Any Ideas?

Thank you,

Pedro

Thank you for this nice guide that provided exactly what I was looking for. Unfortunately I experienced exactly the same problems as described by Pedro (pmdci) in the first comment. I could'nt figure out how to fix it by now. Seems to be a permission problem - but why?

Andreas

Hi Itaysk,

Thanks for ur posting. It is indeed very useful.

I was trying this out to get the user details and Manager details.

I could only see the Current user ID and not any other details.

What may be the issue.

Is it also possible to get the manager's email id.

Kindly help. It is urgent.

Thanks in advance.

Itay has blogged the exact steps and screenshots on how to display current user info (email, full name,

Thanx for ur comment Jingmel.

I am aware of his blog and following the same.

Let me chk again, if I am missing on anything.

middle school study skills lesson plans

When I don't specify a parameter for the GetUserProfileByName method, InfoPath returns an error when attempting to preview or open the form. It says that null or void is not a valid parameter for that method. When I specify an account name as the parameter it works and InfoPath will pull the FirstName value from the array and display it. But that does me no good as I need the information for the current user who is logged in. Is there a parameter that will get the current user? The assumption that a null or empty parameter will get the current user is not working for me. I am also using SharePoint 2003 and not MOSS 2007 if that makes a difference.

I do appreciate this great post and hopefully this will solve a lot of headaches for me.

Pedro,

Regarding your post regarding log id 5566. I was having the same issue. I was able to fix it from my end by turning of anonymous access.

Once I turned off anonymous access I no longer received the error and the connection worked beautifully.

Any idea how to get custom AD attributes (extensionAttribute1 - 10) for the MOSS 2007 user profile? Is it possible using MOSS 2007's web services?

For those getting the 5556 error accessing data source, take a look at this post.  It seems to indicate a priv issue at the root level.  This may be helpful.  For me, I don't get the error, but another of the system does.  When I check his privs, they all look the same as mine.  Here's the post:

blogs.msdn.com/.../how-to-display-current-user-s-full-name-email-and-other-info-in-infopath.aspx

Hi.. i need some help in my infopath form. i have followed all the methods provided online.. but the form i created.. keep retrieving only the administrator profile. even when i signed in as other user.. the form still retrieve only the admin profile... do anyone out there know how to solve this problem?

Thanks for the info.  I'm a newbie and wanting to do something very similiar but am lost.  How would I configure a field in Infopath to submit a different AccountName to the method for query rather than leaving the query field 'null'?  Any help  would be much appreciated.  thanks

Thank you!

i did everything but it's not working why

I installed the infopath template in MOSS so I can use it as a content type.

But when I create a new form using that template, I don't get the current user data, the fields are always filled with the System Account data.

Any idea?

Thanks in advance.

Hi, this is great. It works :)

But I do have a question.

I can eg get the Manager and WorkEmail of the logged on User.

But how can I get the WorkEmail of the Manager ?

It's working wonderfully for me, but now I need to know how to send a parameter so that I can get info for other people in AD who are associated with the form originator.  I can easily get the Manager details, but the info it returns is in the form of domain\name.  This is fine for some of my purposes, but I need the full name of the manager in order to do some filtering in the SharePoint list, since [ME] looks for a full name.  

So, I basically want to setup another Data Connection just like this one but that passes the control in my form named "ManagerUserName."  I want to send that dynamically and return the PreferredName of the manager, but when I go to set that parameter in the Web Service Data Connection setup, it only asks for text, not a control or function.  Is that my only option, or can I set it up where I send the Manager's user name as the AccountName query value associated with this web service?  I mean, I know it's passing the current user by default, so there must be a way to pass another user specified by a control in the form itself, yah?  

Sorry, I may have answered my own question as well as Nick's above me.  I started experimenting with the myriad of other Web Services available from the same place as GetUserProfileByName, and I got lucky when trying GetCommonManager.  Like the Profile one, it passes the current user by default, but then it returns details about just the Manager, such as Account Name (domain\name), Name (full name), Email, etc.  This was exactly what I needed, although I still need to test it in order to ensure it works for all users.

Clayton did you do anything special to get the getcommonmanager working?  I receive an error when I use that web service.  It states that object reference is not set to an instance of an object.  I am able to pull the user profile information just fine but not the manager info.

Has there been a resolution found to this error:

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

The annonymous access thing didn't work for me.

I am stumped. I don't see anything in the logs. Could this have to do with SP1? It was working yesterday. They applied SP1 this morning, and now I am getting this error when trying to access this Web Service from a browser based form. (It works when opened in the client.)

Seth, I was getting this error because we were using a alternate access map to access our sharepoint site, when I removed this then setup the URL we wanted as its own web application it worked fine.

Thank you so much for the post. I have it working, in preview mode. However when i post it to MOSS using form services I get the "Warning - There has been an error while processing the form". Any ideas? The only two options i get are "Try Again" and "Exit Form"

Anybody know how to get the Sharepoint groups of a logged in user?

Jason, in response to your question about GetCommonManager, this is what I do:

1) First, I create a new data field for Manager, and I set the default value to the Manager element coming from GetUserProfileByName.  

2) That data comes in as <domain>\<account name>, so I do a substring-after...

substring-after(Value[Name = "Manager"],"<domain>\")

...to strip the <domain>\ portion off so that I only have the account name remaining, which is what the GetCommonManager query requires.

3) I then have a rule set on the Manager field that sets the GetCommonManager query field (AccountName) to the Manager's account name, and then it queries the WS

I've been using this religiously on my browser-enabled forms to increase efficiency and reduce the amount of required user interaction (reduce errors, too).  However, one thing I can't figure out is how to display results that have multiple values (i.e. interests, schools, responsibilities, etc.).  I started out by doing a repeating table hoping it would add a new row for each piece of data for a given element, but it only ever shows the first piece of data.  This makes me think it's something simple, but right now I can only retrieve the first piece of data, whether it's a repeating field or not.

I too was trying to pass the AccountName to the GetUserProfileByName field.  The GetCommonManager get's me most of what I need, but I also need the WorkPhone which is not in GetCommonManager.

I can pass the AccountName during the DataConnection, but that is text and I can't do this codeless in the field.  

I want to pass the AccountName to GetUserProfileByName from the GetCommonManager information so I can get to WorkPhone.

Any suggestions for someone trying to do this in InfoPath 2003 without using code?

This is how: This graph shows the overall traffic in my blog. Notice the steep rise in blog traffic on

In part one I created an InfoPath form that employees could use to create a work schedule. Now I&#39;m

Requirement: Submit schedule change requests to SharePoint so supervisors can approve them through workflow

I followed this exactly but it failed with:

"Infopath contacted a data source but failed to recieve data. The form will load without the requested data.

Details: 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:

Unable to read in användarprofilhanterarobjektet. ---> Value cannot be null.

Parameter name: serverContext"

Anyone got any ideas on this??

Well , wonderful document. Thanks.

But i'm still getting only administrator's account instead of the longon account.

Any idea ?

Thanks

This post has been snatched from the headlines of Premier Support. The names have been changed to protect

I was reading Clayton's post in hope of getting the Manager Details:

"3) I then have a rule set on the Manager field that sets the GetCommonManager query field (AccountName) to the Manager's account name, and then it queries the WS"

I have created the rule, but am unsure how to get the query going after the Manager Field is populated...

Please advise....Thanks

HELP PLEASE!!!

I have been using this method successfully for the past few weeks, and it works great to get the user in Sharepoint for filling a web enabled Infopath form.  

But now I need to work out a solution for the next step in my scenario:

On initiation of the form, (process 1)I get the current logged in user account details in text box 'a', on submit I write the current user account to text box 'b' which shows who completed Process 1 and clear text box 'a'.  

Now here is where the problem occurs.  The next user who opens the form for Process 2, but the same text box 'a' does not retrieve the next users credentials.

How can I resolve the reuse of a retrival of the next users login to the same control?

Jenny

For Clayton: You can create a second instance of GetUserProfileByName data connection but this time dont set it to query when the form is opened. I called mine GetUserProfileByNameMGR.

Go ahead and get the Manager accountname (I applied it to a Manager field) using the techniques shown in this blog but don't place it on the form.

Add a rule to the Manager field with two actions:

1. Set a field's value: Accountname = .

2. Query using a data connection: GetUserProfileByNameMGR

This will set the Accountname for data connection GetUserProfileByNameMGR to the Manager Account and then query GetUserProfileByNameMGR for that account. You can then populate a Manager section similar to how you populated the User section but this time using the GetUserProfileByNameMGR data connection.

Now the challenge is to only do all of this when the form is initiated (new) since you don't want to do it again if someone else opens it. Can this be done without code?

Regarding error 5566, if you use a Load Balancer it may cause this error. Change the URL to point directly at the MOSS server to resolve issue.

Siamac

I followed the instructions, but I get following error in the error logs of SharePoint:

Data adapter failed during OnLoad

The following query failed: GetUserProfileByName

It seems to have something to do with the fact that my Domain Controllor and my SharePoint web server site are on a different machine, though in the same domain.

I needed to set up basic authentication only on the webserver, as else the Active Directory users were not accessible for users outside the domain trying to log in. I needed to uncheck integrated windows authentication on the web server to be able to let them access the SharePoint site.

What else should I check why the Active Directory values cannot be queried with the web service?

I am having issues with it if I use this in a form which is needed to be deployed from Central Admin (as its mobile enabled).

Please suggest what can be done to get this working. Thanks in advance for the suggesions.

Regards,

Preet

Dear all,

I have few infopath forms and diffrent wf. In those form there is a search button that it is been used for searching users. So that i can find a user i'm using UserGroup.asmx?WSDL and GetUserCollectionFromSite. It is working fine but my problem is that it bring one the user that have allready login . the same problem i have also with spweb.siteusers.

Could you please give an idea how i can

1) Find all users that are in profile database

2) Use an spusercollection object that can take any login name that exist in profile database without the need to have first login

Thanks for your post. It's work fine for me.

However I have another requirement.

I want to populate a list of users based on value of a profile property. I am strugling for several days, still can't make it yet.

Could anyone give some idea on how to go through this problem.

Thanks.

hi;

Thanks alooot for this post.

but i have this error"An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566"

as the rest.

another thing when i opened in client application, it gives me always the name of the system admin.

appreciate your help

Dreal all i have found the solution.

You can use Microsoft.Office.Workflow.Tasks.dll which is installed with sharepoint sdk. There is a library called Microsoft.Office.Workflow.Utitlites.

Get the login name of the user  and user the code below

string userLogin;

                       Contact usr;

                       userLogin =  this.ReviewerName; (domain name)

                      // item["ManagerPerson"] = currentWeb.SiteUsers[userLogin];

                       usr = Contact.FromName(userLogin, this.workflowProperties.Web); //load contact object

                       item["ManagerPerson"] = usr.GetPrincipal(workflowProperties.Web); //Get principal people group type

hi ,

I am facing a problem, i always got 5337 error and it always display admin data not the current user data . please help me.

hi you

I did everything  but it not run when i pressed Preview button.

It shows "Failed connection to data source" that:

"One or more data sources that are required to open this form are not available. They may be temporarily offline or your computer may not be connected to the network"

I use Info Path 2007 and I installed MOSS 2007 in a local computer.

Anyone get the same issue??? Help me!!!

This is a great post and worked for me on a single server environment but when published to a Load balanced multi-server environment I keep getting datasoure- 401 errors. I think this is because the web service call is being served by another server. Does anyone know how to get around this? UDC won't work right? - as I need to use the credential of the current user, not an admin account.

When I remote into the servers themselves and open a browser to access the form, it works great, but from a client machine it works 20% of the time

Can anyone tell me how to use this approch when loading a drop-down list box?  Basically, I want to initialize a drop-down list to contain all entries from GetUserProfileByName where the Name (the default profile property) is set to 'PreferredName' and the Value field contains 'somename' like 'Rob'.  Instead of returning a single entry, I want it to return all entries where the Value contains Rob, but I am just getting back the first entry following the instruction at the top of this blog. Currently, the drop-load shows a single entry (not all possible entries).  Thanks!

Hi all,

Excuse me if this question is so basic. But I can not understand how this web service matches some terms with the specific of AD.

For example, the WS uses FirstName but when I browse into the AD the value is in givenName attribute and I can not find the FirstName one. I'm quite confused because the value is finally obtained.......is there some alias stuff involved? I have a lot of AD attributes to use but I can't not get the value using this web service.

Could someone explain me how it works?...and being specific....why do I have to use FirstName instead of givenName?

Thanks a lot in advanced.

Martin.-

Great article.

Itay, why are you sick? :)

I did what you told me about using User Profiles and using a permanant query for a department. works well.

Is there any way to make a contact list in InfoPath to get all the users from the User Profiles?

After following the steps outlined, my error is pasted below. Any help would be appreciated.....

The following DataObject either cannot be created or cannot be initialized: GetUserProfileByName

The query cannot be run for the following DataObject: GetUserProfileByName

InfoPath cannot run the specified query.

The SOAP response indicates that an error occurred:

Invalid input for account name, cannot be empty or null.

I am facing the same infopath issue with Error ID :5566,I get the following

There has been an error while processing the form.

Click Continue to resume filling out the form. You may want to check your form data for errors.

Click Start Over to load a new copy of the form.

Show error details

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

Please share the solution ,

appreciate your help :)

Has anyone got an answer on Esther's problem from April 9th.

"This is a great post and worked for me on a single server environment but when published to a Load balanced multi-server environment I keep getting datasoure- 401 errors. I think this is because the web service call is being served by another server. Does anyone know how to get around this? UDC won't work right? - as I need to use the credential of the current user, not an admin account.

When I remote into the servers themselves and open a browser to access the form, it works great, but from a client machine it works 20% of the time"

I am having exactly the same problem and wondering if this a farm configuration issue or an udcx limitation?

Thanks, Helgi

Pingback from  While I&#8217;m here&#8230;&#8230;. &laquo; Lights on a Stick

Hey Itay

Beautiful article and it works perfectly. Is there any way to get / request the same properties on a different user? It needs to work with InfoPath Forms Services.

Best regards

Iver

A very good link to g et the current user without writing code in an InfoPath form.

AWESOME BLOG

This information is exactly what we need, however we are using SharePoint 2003 and InfoPath 2003.  Is there any way to retrieve user info using the 2003 products?

This information is exactly what we need, however we are using SharePoint 2003 and InfoPath 2003.  Is there any way to retrieve user info using the 2003 products?

i am geting the following error, does any one now how to solve it.

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

Instead of tieing the rules to the textbox, try going to tools->form options->Open and Save-> Rules

Put all the same code in there.

It will read the user upon opening the form, this post only reads the current user on the original form load.

This works great for AD properties but

I have no idea what to expect from SPS profile properties.  Are they actually part of AD also?   Can you can me an example of how to use SPS-Dotted-line?

Great post, worked first time, and saved me a lot og time, thanks!

Hi there.

Im trying to capture the current user details. I have tried your above steps and get the following error:

The following DataObject either cannot be created or cannot be initialized: GetUserProfileByName

The query cannot be run for the following DataObject: GetUserProfileByName

InfoPath cannot run the specified query.

Access is denied.

Anyideas?

Excellent post!

It works but I have a small issue. What I would like to get as default value in my field is both 'Last name' and 'First Name' of the current user. The closest property to that I believe is the 'PreferredName' which returns 'Last name' comma 'First Name' (Doe, John). However, because of the 'comma' the control picker considers this as two values (and returns a recipient list to choose form for each name).

Is there a way to remove the comma or use some kind of formula? Or another name property without the comma? Thank you in advance.

awesome post! Works perfectly on 2003.  Many thanks!

This is a great entry, I used this but I want to use repeating tables so that when the a user presses the button on the screen it gets their information. I have that down packed the problem comes when they press the button another table comes down but, we cant put any information in the field once the button is pressed How do I make this work with the repeating tables

baigadil.blogspot.com/.../get-current-user-for-infopath-and-set.html

InfoPath Resources URL

i end up with the following error, does any one now how to solve it.

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

had anybody over come this?

www.ceapet.com InfoPath-Getthecurrentuserwithoutwritingcode

I'vejust

This solution works great when a new form is created. However, when someone opens up an existing form  for editing it does not refresh the name in the textbox. It still has the name of the person who initially created the form. I have my data connection to refresh upon opening the form but that isnt working. Any ideas?

I answered my own question.

If anyone else has the same issue where the data connection is not being refreshed everytime the form is being opened, create a rule to refresh the data connection everytime the form is opened. To do this:

1. Click on tools, then form options.

2. under the Open and Save section, add a rule to the open behavior section.

3. Set the action to Query using a data connection and select your data connection

This will cause your data connection to refresh everytime the user opens the form.

Please, all of you who are having an error accessing the data source, make sure your IIS site is not set to allow anonymous.  I have used this web service for a long time now without any issues until yesterday when I suddenly couldn't get anything to work.  It was hard for me to believe, but it actually just came down to the fact that my IIS site was set to allow anonymous after some anonymous user testing I had been doing.

Hey Helgi,

sorry to take so long but if you are interested, I finally figured out why my form was working 20% of the time and always on the server-

Its a question of load balancing! When a request to the web service went out from the form, our LB server recieved the request and assigned it to 1 of the 3 MOSS servers. If it happened to be the same server serving the form, it worked, if not we saw an unauthorised exception. What worked for me was to ensure our servers included the farm host header mapped to 127.0.0.1 in the host files. So now, the web service request is always served by the same server serving the form.

Pingback from  Intermittent InfoPath Forms Services Error  &laquo; All the Goss about MOSS

To get the User Name in the  Web Browser form

we need to add the shared services providers  in the server and add our web application to that SSP

that way after doing the above process we dont get any error.

thanks

I followed this exactly but it failed with:

"Infopath contacted a data source but failed to recieve data. The form will load without the requested data.

Details: 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:

Unable to read in användarprofilhanterarobjektet. ---> Value cannot be null.

Parameter name: serverContext"

Anyone got any ideas on this??

To get the User Name in the  Web Browser form

we need to add the shared services providers  in the server and add our web application to that SSP

that way after doing the above process we dont get any error.

thanks

Is it possible to retrieve user infomation (Email, Phone, Department, etc) by manually entering a user name or selecting a user name from a drop down field?

UNBELIEVABLE, after a month+ of everything working great, I suddenly got a bunch of emails and calls saying people were getting this dang error again.  I checked a bunch of stuff and determined it was my User Profile web service again.  After trying lots of other things, I decided to check ISS again, and sure enough, the stinkin Anonymous access had reset itself somehow.  No one else works on this server or does any IIS changes, so I have no idea how anonymous access got re-checked on this web app.  I know I had been doing some testing with extending the web app and trying different zones, but I don't know which part of that could reset anonymous.

Anyway, I unchecked it, recycled the app pool, and then it all worked again.  Dumb!!

Dennis, to get info from this web service, you need to pass the username (i.e. ccobb for me) so that it can return the relevant info.  to have a drop down field of actual names, you'd need some SharePoint list somewhere that matched real names with usernames, and then display those usernames in the dropdown while applying the username as the value.  You could then pass that value back to the webservice as a rule when someone selects the name.  I don't know if that's worth your while, though, and I don't know of any automatica way to pull in all those names associated with username.

Pingback from  MindBusiness Blog &raquo; Rollen in InfoPath &uuml;ber SharePoint-Liste festlegen

This is a great start, but what I am trying to achieve is:

1. When user opens the form, a combo-list displays the current users name (from a list of MOSS Users)

2. The user can select another user from the combo-list (e.g. they are completing the form on behalf of another user.

Anyone have any ideas on how this can be done?

Michael - Sydney

Pingback from  Get the current user without writing code in InfoPath 2007 &laquo; Benoit808&#8217;s Weblog

Ok, I found a solution for the constant display of the administrator account problem. When a rule is assigned to a textbox, which retrieves the current user via the web service, the rule is executed exactly once (during the creation of the form). So if you create a form as an administrator and open the form as user X afterwards, the form still shows administrator. However when you alter the Tools/Form Options/ Open/Save settings and assign a rule to a textbox during form opening, the rule gets applied each time the form is opened resulting in a display of the "current" user.

Hello everybody,

For the 5566 log error, please change the proxy settings on the server's web config file, so that it will look like this.

 <system.net>

   <defaultProxy>

     <proxy autoDetect="false" />

   </defaultProxy>

 </system.net>

I had tried several things but none of them seemed to work, until I changed this.

I hope it helps.

Adrian

I am performing a lookup. I use the web service's parameter AccountName to lookup another user. If the user exists, everything is fine. If I try to look up a non existing account, then a Soap Exception is thrown. Is there a way to handle the exception without writing code? I would like the users of the form not to get en error message.

can i get all information of my Manager data with only using that "Manager" property ?

for example : my AccountName is "Alf", and my direct manager is "Bianca Margareth" (define on AD), so how can i get all property of the manager "Bianca" like i did for "Alf" ? thanks..

notes :

i can only get "CONTOSO\b.margareth" for that "Manager" property, can i get all of the manager property ?

thanks God, finally i found the answer and now i want to share..

so, here it is.. (maybe its helpful, thanks..)

first, i go to Tools->Form Options->Open & Save->Rules, below the "Init Form Status and Author" rules (where i used it get the "Manager" property), i add a new rule where the value of the "ManagerAccount" (CONTOSO\.b.margareth) i used as a new parameter to query the webservice "GetUserProfileByName", and then.. voila, i get all of the information i need.. (notes : with this "way", i can get all information that related to the first person i get from this webservice)

best regards,

-- alf --

Ok. this works great for inserting manager details into a form - but what about the reverse?

I'm building a form for Managers, and I need to query their direct reports. I looks like GetUserProfileByName doesn't have Direct Reports. The Organisation Hierarchy in MOSS will show them but I can't see anywhere in the web service where I can query them.

Any ideas?

Can someone help ?

There is infopath from published on SharePoint portal, but the prolem is DropDown List Box control of the infopath form retrive text field value from SharePoint list not in sorted order i.e."Alphabatically" when the form opened in browser. Infact it is taking the values by "itemid" property value of sharepoint list.

But when i open it in InfoPath installed on local machine it shows in "Alphabatical" order i.e. sorted.

Great Article. How can I use this MOSS Form based authentication?

AJIT:

I've had a couple of situations where my SharePoint list does not display in Alpha order in a drop-down list box when the form is being viewed in the browser.  It displays correctly in the client.  I did a work-around to get this working.  I think this happens when you have a long list, not sure at what number this happens at but I'm sure it has to do with the amount of items.  

I created a data connection to the SharePoint list as XML:  Refer to this post:

www.sharepoint-tips.com/.../infopath-form-services-implementing.html

Set up your connection as:

server/.../owssvr.dll{ListGUID}&XMLDATA=TRUE

Then use that data connection to apply to your drop down and your items will display in Alpha order when you view it in the browser.  Hope that helps!

Why does the manager value return as "domain\user" instead of preferred name for example?

Is this an issue with our profile import on SharePoint or active directory? Other parts of SharePoint show the manager correctly, so it makes me think its something in this test form.

Thanks,

Brian

This article is really nice but to make sure that you come up with the current loged-In user in SharePoint   , You need to publish the form in some form's library of SharePoint and open this published-form through the create menu of that libaray.

other wise if you preview it via InfoPath then you keep on viewing the log-in machine user.

Hope this helps someone!

absolutely outstanding! works great.....

Great Article, the only thing is that it works for me only with Administrator. If I try to use the prepared form with another user I'm getting Server was unable to process the request - Attempt to perform un unauthorized operation ...

Any Ideas ?

How can i get the other details of user by just manually putting the user's name???

That is, i just want to put the manager's name and rest information about that particular user should come automatically.

Here is the solution that worked for me in addressing error 5566.

Our environment:  Medium farm behind Cisco Load Balancer.  We are also using host headers in our configuration.

Suggested solutions attempted:  

*  Pointing to the web service at the site collection scope instead of the top of the server.

*  Updating the web config to say Proxy AutoDetect = false

*  Confirmed we were not allowing anonymous access to the web app.

Our scenario:  Intermittent success or partial success of SharePoint web service calls when form was rendered in web browser.  A 5566 application event was logged in on the application server and review of the IIS logs indicated the GET calls used to render the form were being logged to a different WFE then the POST statements used to query the web service.

Pre-solution IIS Log:

2008-12-16 21:26:38 W3SVC1723786348 [WFE IP] POST /sites/test01/_vti_bin/UserProfileService.asmx - 80 – [NLB IP] InfoPathDA 401 1 0

Post-solution IIS Log: 2008-12-16 21:27:27 W3SVC1723786348 127.0.0.1 POST /sites/test01/_vti_bin/UserProfileService.asmx - 80 DOMAIN\TestUser 127.0.0.1 InfoPathDA 200 0 0

Solution:

*  On each front end node add an entry in IIS for the web application allowing traffic on 127.0.0.1 when the host header contains the name associated with the Public URL AAM mapping used for the zone you are configuring.  (e.g.  "INTRANET"

*  In the hosts file for each node add a line pointing the name referenced above to 127.0.0.1 (e.g. "INTRANET"

With these changes in play the POST web service calls initiated by InfoPath Forms Web Services resolve to the same WFE node as the GET and you are back in action... assuming this is the particular 5566 Infopath web service error you were attempting to solve.

thanks....Great Post.

works like a charm..

If you are getting error 5566 Try to modify Registry as mentioned in Following Article that worked for me.

support.microsoft.com/.../926642

Works perfect and solved a problem I was having with the code in onload.  

For those that are having the following error:

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

This problem occurs because Windows Server 2003 SP1 includes a new security feature named loopback check functionality. By default, loopback check functionality is turned on in Windows Server 2003 SP1, and the value of the DisableLoopbackCheck registry entry is set to 0 (zero).

Solution:

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.

InfoPath will pull the FirstName value from the array and display it. But that does me no good as I need the information for the current user who is logged in. It works perfect and solved a problem I was having with the code in onload.  

www.torontowebservices.com

These were great instructions!  I wish all data connections were as simple as this inside infopath - I'm starting to see how powerful a tool this can be when paired with Sharepoint.

Thanks Itay.

This works perfectly for me. However, I'm curious to know if anyone has a solution for expanding on this.

Once I've retrieved my user's ID, how to I compare this to a SharePoint list? Here's the scenario. Think of it as a sort of "Advanced Conditional Formatting."

1. User opens form and ID is retrieved (using above instructions).

2. InfoPath needs to determine whether to show an approve button by comparing this ID to a SharePoint list and answering two questions: Is this ID in the SharePoint list? Is the Approver column marked "Yes"?

3. If this ID is in the SharePoint list AND if the ID is marked as an "Approver" then InfoPath should show the Approve button.

I'm going at it this way to avoid User Roles. I have many users who serve multiple roles - Infopath only will assign to the first role it finds them in, even if that particular role has no bearing on the role they're playing at a particular time or phase of our internal approval process.

Any suggestions? A step-by-step guide to something like this would be perfect, however I'll take what I can get!

Thanks,

Mike

Pingback from  Display the Current User on a Browser-Enabled Form | keyongtech

Pingback from  Error 5566 | keyongtech

This method is working only for the accounts who have permitions to access the web service. How can I grant access to all users to the a/m web service?

There's an article on support.microsoft.com/.../896861 that describes one of the possible reasons for getting the 'error accessing datasource' as described in several comments. We user this solution to solve a similar problem in InfoPath forms. Click on my name for further details.

Does this method work on Windows Sharepoint Services (WSS) installs?  I can't find a UserProfileService.asmx  anywhere on the WSS box.

Thanks.

Should I configure this form with such web service as a "full trust" for publishing ? Thanks

Infopath developer

Thank you Itay, it works ! Great article.

I am not able to get my Type, Managers name as Mentioned here. can you give with detailed data

Works like a dream!

Thanks Itak.

I would also like to bring back a full list of AD users (depending on country) then be able to select one and bring back their details (phone number)

This would work like a simple way to get a phone number.

Is this possible?  could you point me in the right direction please?

Thanks

Stu

I was getting the 5566 error too after I published to my server and found this out

it worked fine in the InfoPath app, but through forms services on the server I got the  5566 error.

The problem was that I was calling a web service on my production server but had deployed my form on a dev server.

Since I am using NTLM, I was getting that multiple hop issue.  I changed the data connection to call the web service on the dev machine and all was fine.  I suppose that switching to Kerberos would work too, but that isnt the way the client has the authentication set up.

Pingback from  Save Username in InfoPath form | keyongtech

I'm new to InfoPath.  I tryied the above steps, but I keep receiving an error.

"4) Now you will have to point the wizard to the WS. Type an address similar to this: servername/.../UserProfileService.asmx  and click next."

The message I'm receiving is

"InfoPath cannot find or access the specified Web service description."

Is there a way to very if my sharepoint UserProfileService file exist or if i have access to it?

Thanks.

Wow, man. Thank you so much!

I was able to get access to the _Vti_Bin.  When i followed the steps above I get a message:

"InfoPath Cannot create a New, Blank Form. The Form Template is not Valid"

I removed the default value, and rec'd the message again.

I removed the Dataconnection and the Message dissapears.

The Form works without the _Vti_Bin link.

Is there a security setting that I need to change?  I'm using InfoPath 2003.  My company has not made the transition yet to 2007.

This is the Help File Detail:

"The following DataObject either cannot be created or cannot be initialized: GetUserProfileByName

The query cannot be run for the following DataObject: GetUserProfileByName

InfoPath cannot run the specified query.

The SOAP response indicates that an error occurred:

Invalid input for account name, cannot be empty or null."

Thanks for your help.

To any others that have been getting the error 5566, this was what happened in my case.

I did all of the suggested steps of others such as clear the Anonymous checkbox, mess with the data connection settings, etc.  None of it worked in my case.

So before taking a bat to my server, I decided to just create a test web application and site collection from scratch since all I had been doing is wrestling with an existing site.

I went into Central Administration and just created a new web application with a new database.  In creating the web application, I made sure to use my designated SharePoint Service account (rather than using a network service).

Then created a new site collection associated with that web application.  I left the Anonymous off (for now).  Jumped into InfoPath and followed Itay's VERY helpful instructions and simply created a genric form with a first name, last name, and email textboxes.

Worked like a charm.  So I apparently have some underlying issue with my existing sites that are getting the Error 5566.  I double-checked that the underlying web applications for those "faulting sites" were using the SharePoint Service account but there's still an issue somewhere.  I also made sure they all had the correct SQL database permissions, etc.  Still no luck.

So for those having the Error 5566 no matter what you've tried, perhaps just create a fresh test web application and site collection to ensure that your SharePoint & SQL are at least working in that capacity?

In my case I'll just be dumping the "faulty" sites and web applications and starting afresh because I have the source InfoPath forms stored and can easily re-create our SharePoint sites since we don't have too much defined as of yet.

Thanks to all who've contributed to this and other blogs.  It's helped me to at least eventually narrow down my problem.  Hoping my feedback here will be of help to someone else having the same grief as I went through with Error 5566.  And thanks Itay for your article!

***Update***

After further testing, I was able to re-create the Error 5566.  It has to do with using Basic Authentication vs. Integrated Windows (or otherwise) methods.  With Integrated Windows (NTLM) on, form worked fine and filled in data correctly from user's profile (first name, last name, email address, etc.)  I then started adjusting options one by one to find out when it would break.

I then tested flipping on Anonymous access.  Still worked.  Then I tried adding Basic Authentication along with Integrated Windows (NTLM).  Still worked, however, the site was only accepting Integrated Windows logins and wouldn't accept a Basic Authentication attempt.  By this, I mean that I'd have to enter a login using "Domain Name\Account Name" method.  My goal is to not have to force the user to enter in the "domain name\" part.

So I tried turning off Integrated Windows and using just Basic Authentication.  In IIS Manager, for the website I'm working on, I also added in the default domin name under Basic Authentication.  After having done that, I went to test the site.  I can get to the site as Anonymous, I can login using just an account name and password without "domain name\".  But when I go to open the InfoPath form...  BOOM!  Error 5566 again.

So it appears I'll have to use Forms based authentication or SSO unless there's another way of being able to allow an Integrated Windows style login without having to include the domin name.  Our target client audience will be people outside of our domain and I'm hoping to have their logins be their email address and then whatever password we assign.  I had been creating their logins on our domain which means their login name would be something like JDoe@Acme.Com@Jay.Org (because the ending @Jay.Org would be our domain name).  Using Basic Authentication and a default domain name in IIS set to @Jay.Org, I was able to get users to login with their email address and the password we issued to them.

But apparently Basic Authenication won't work with the GetUserProfile method because the domain name isn't passed in the authentication which is why Error 5566 is nagging about failing to connect to a data source.

If anyone has advice for me on a better method, I'd appreciate it.  Otherwise, I'm venturing in to Forms Based/SSO waters.  Thanks!

I was wondering if anyone knows how to remove the [Submitted by ...] information that InfoPath Forms automatically generates?

I need a form that is Anonymous.  

I was wondering if anyone knows how to remove the 'submitted by' information that is automatically generated by InfoPath forms, when forms are submitted.

I need to generate an anonymous form for fraud alerts.

Sin duda, una de las ventajas de realizar formaci&oacute;n tecnol&oacute;gica especializada es que aprenden

Pingback from  WSS 3.0 &amp; MOSS: Preguntas &amp; Respuestas (I)! &laquo; Pasi??n por la tecnolog??a&#8230;

You rock!  This was so easy to follow.  Thank you :)  Bookmarked it for when I have to do this again!!

Thanks great post - it works in preview mode for me, but when i upload form template to MOSS, i get an unknown error.  Anyone one know why this may be?

Get current user information in Infopath form

Itay,

I've followed the steps you have above.  When I do preview mode within in InfoPath, and test my form, the username does pull through.  However I am using my form integrated with SharePoint.  So when I try to upload the form it gives me an unknown error.  When I remove the changes I made using your steps, the form uploads correctly.  So am not sure why SharePoint is not liking this?

Hi Itay.

Thank you for this post, helps a lot.

Do you know how to connect a self created attribute using this method (i need to get the employee number filed which we created in AD)?

Thanks!

Pingback from  DevTechBlog  &raquo; InfoPath aktueller Benutzer

Hi Itay,

Thanks!

I Have created the custom property on SSP (and import it), and tried to use it on the form, but it is not working. The properties has different names GivenName=FirstName, and i couldn't find the FirstName in the property properties. So where is it?  where do i connect this property as FirstName is givenname?

Never mind..I did a full import instead of incremental and it is working now.

Thanks anyway :)

Excellent post and the basis is well formed.  I also found the questions and answers helpful as I have encountered most of the problems identified.

The InfoPathh form is working now but when I try to open it up to the user community I discovered that only users within the site collection administrators group can access their data.  The others get a message stating that one of the connections failed.

Any ideas as to why this level of access would be required to get your user profile data?

Thanks

Pingback from  Get current user information in Infopath form

Itay,

Publishing the form to a SharePoint Site, get the unknown error when uploading the form in Upload templates.

Any ideas?

BS

Pingback from  The GetCommonManager webservice in Infopath 2007

Tried it and now my form won't work. Test this on a small form first, don't do what I did and wait till your form is all completed. Now I can't get it to open no matter what I do.

Hey Itay and all,

Your blog on getting user name info worked wonders for me.

You being an expert on this, can I ask you one question:

I am trying to get group name of a SHarePoint site in InfoPath 2007 form. Can you suggest which web service to use and which method.

Please help.

Thanks in advance!

Amod

{{QUOTE}}# re: InfoPath - Get the current user without writing code

Sunday, October 12, 2008 9:38 PM by alf

thanks God, finally i found the answer and now i want to share..

so, here it is.. (maybe its helpful, thanks..)

first, i go to Tools->Form Options->Open & Save->Rules, below the "Init Form Status and Author" rules (where i used it get the "Manager" property), i add a new rule where the value of the "ManagerAccount" (CONTOSO\.b.margareth) i used as a new parameter to query the webservice "GetUserProfileByName", and then.. voila, i get all of the information i need.. (notes : with this "way", i can get all information that related to the first person i get from this webservice)

best regards,

-- alf --{{QUOTE}}

Hi Alf, Are you able to give a more detailed step by step guide on what you actually did, I'm confusing myself im sure and can't get it to work.

Of if anyone else who has done it able to detail step by step how they do it.

I simply can't figure out how to tell that text box to use the Managers details. I have a 'hidden' textbox that gets the manager by the logged in users Getprofilebyname "manager" parameter but then I am stuck.

Thank You!

Pingback from  User Roles in Browser-Enabled Forms &laquo; Clayton&#039;s SharePoint Madness

Its an excellent example. Thank you very much.

Pingback from  Inforpath &#8211; Get current userdetails with no coding - PeteStilgoe.com

Hi Itay,

This is superb - thank you once again my friend.

Is it possible to get the current user's, Country, Company, Site and Department from Active Directory?

Thanks in advance.

Stu

Hi Itay,

I followed your suggested approach portal/.../_vti_bin... and still getting this issue. Its works fine o issue if I preview it or test on browser.

Is there stil any hope to solve this issue.

Appreciate your help.

forgot to mention issue

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

Iab, did you verify that the IIS site for your respective SharePoint site does not have Anonymous Access enabled?

Itay and others, I am currently creating a new blog post that is an extension of this one so that everyone can learn exactly how to leverage the Manager node to get manager information as well as information about any other user besides the current user.  I will post the link here when I'm done, but you can already see my blog URL here:  claytoncobb.wordpress.com.  I have 3 codeless programming blog entries so far, and this new one will be my 4th.

Pingback from  InfoPath &#8211; Get the current user without writing code (extended) &laquo; Clayton&#039;s SharePoint Madness

Ok, I just finished it, and it's HUGE.  Hopefully, people can spend the time to follow it through, because it's worth it:

claytoncobb.wordpress.com/.../userprofileservice-extended

This is how you take Itay's great blog entry and extend it...

Hi Itay,

In regard to my question on June 11 about SharePoint Group.

I want to check (conditional formatting for certain buttons in InfoPath )if the current user is added to a certain Group.

Hence I was trying to get a webservice and a web-method to retrieve the group name. How is that possible?

Thanks for the help.

If you are getting the Log Id:5566 error, make sure the logged in user has the "Personal Features" right in the Shared Service Provider. This right is required to access the User Profile web service.  To manage Share Service Rights:

Browse to http://[your Shared Services Administration site]/ssp/admin/_layouts/ManageServicePermissions.aspx

   OR

Click on the name of your Shared Services provider from left (Quick Launch) menu on the SharePoint Central Administration home page and then click on Personalization services permissions under the User Profiles and My Sites section.  

Amod, if you want to check to see if the current user (or any user) is a member of a specific group (AD or SharePoint), then you can use the GetCommonMemberships method to see all the groups a user is a member of, and then you can use that info to restrict/hide/disable controls/sections using conditional formatting.  I will be writing this up as a fix to my User Roles in Browser Forms blog entry.  I took my previous method down until I include this new method.

Hi Itay,

I tried this on my development server - worked first time :-)

I tried this on my production server - and got a security error.

The error I got was...

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:

Server was unable to process request. ---> Access Denied: To create a user profile, you must be an administrator, or create your own profile and have personal features rights.

Do you know how or where I would fix this?

many thanks in advance!

regards

David

Pingback from  InfoPath &#8211; User Roles in Browser-Enabled Forms using GetCommonMemberships &laquo; Clayton&#039;s SharePoint Madness

Perfect!!!

Thanks A million

Pingback from  InfoPath &#8211; User Roles in Browser-Enabled Forms Using Groups &laquo; Clayton&#039;s SharePoint Madness

Hey Itay,

Thanks for the post. This seems to work the first time the form is opened, but when the form is submitted and saved in a library, and opened by a different person from the one who initially opened the form; how do I refresh the data connection so that I can retrieve the information of the current viewer of the form.

Thanks

NLD

ddddddddddddddddddddddddd

how can i get Initials of User from AD

Great article - I use it all the time!

Great Post - very helpful. We are using this method in almost any of our forms. THX for the outstanding work and explanation.

Brillilent Stuff... I also had the error

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

Turned off Anonymous Access.. and converted the datasource for the webservice to UDCX.

Thanks ,

I was able to get the Manager details.Now how can I get my Manager Managers E-mail,name?

For KIP...

RE: your reply to Clayton dated, Tuesday, February 26, 2008 7:48 PM

Simple but Brilliant!!!

Pingback from  Twitter Trackbacks for                 InfoPath - Get the current user without writing code - itaysk         [microsoft.co.il]        on Topsy.com

Hey this is a great post!

Works great when the form is opened the first time, however does anyone know how to update "AccountName" when the same form, not a new form, is opened by someone other than the person who initially filled out the form?

Any suggestions or help is appreciated. Thank you.

can we find in infopath wheather the current user is present in a sharepoint group or not without writing code.

This is great post and works fine, do you have any idea how to get Manager's full name instead of "Username" of manger that we get from "Manager" Property Name.

Great post! helped me a lot. thanks

fillzephyr.wordpress.com/.../an-error-occurred-accessing-a-data-source-an-entry-has-been-added-to-the-windows-event-log-of-the-server-log-id5566

this does away with the 5566 error very easily

Pingback from  Things I&rsquo;ve Found Out About InfoPath and Forms Services &laquo;  The WorkerThread Blog

Pingback from  Things I&rsquo;ve Learned About InfoPath and Forms Services &laquo;  The WorkerThread Blog

Pingback from  Things I&rsquo;ve Learnt About InfoPath and Forms Services &laquo;  The WorkerThread Blog

Pingback from  SharePoint Blog  &raquo; Blog Archive   &raquo; WebService &#8211; GetUSerProfileByName

Pingback from  SharePoint: Things I???ve Learnt About InfoPath and Forms Services | End User SharePoint

Pingback from  SharePoint List &ndash; using [Me] filter on a column with AD user information populated from InfoPath (without code) &laquo; Gareth M Davies

Pingback from  sharepointblog  &raquo; Blog Archive   &raquo; GetUserProfileByName

All people find this post great. However this posted neglected a very important aspect which is "multi-valued" properties. Use this approach and you are going to fail miserably in getting a multi-valued property

This is awesome! Thank you - I added it to my infopath form and it works great setting the default value.

I would like to use a similar method on the same form which would be a listbox to select from of ALL users

I was going to go through the same steps using this

GetUserCollectionFromSite but I receive this alert [you must select a repeating group or field].

How can I populate a listbox of all users? Will it be sorted?

hello itay,

(i posted the same on clayton cobbs blog and than i realized that the walkthrough comes from here)

first thank you for your blog i tried to realize this solution but an error comes up on my application. so i want to ask for help. i'm not the administrator of the server the application runs on and i have no acces to the central administration but maybe after that i can give the administrators of the server some hints so this solution could run.

thank you in advance and greetings from germany (and please excuse my english)

markus

The error-message is:

This query can not be performed on the object "GetUserProfileByName" of type "Data Object".

The specified query can not be run from InfoPath.

The SOAP response indicates that a server error has occurred:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.

  at Microsoft.Office.Server.UserProfiles.PublishedLinksService.EnsureUserProfileReadPermissions()

  at Microsoft.Office.Server.UserProfiles.UserProfileService..ctor()

  --- End of inner exception stack trace ---

I tested the instructions on this post and it worked fine, however it was always getting the current user of InfoPath (which always happens to be the current windows user) not the current user logged onto SharePoint.

I tested this in a non web enabed form. maybe that's why?

please clarify what do you mean by the "current user"...

Thanks and it's a great post

As quoted from above #4: Now you will have to point the wizard to the WS. Type an address similar to this: servername/.../UserProfileService.asmx  and click next.

Where or how can I get the URL which is simillar to this?

He means you should replace the "servername" with the name of your sharepoint portal server.

Thanks a lot for this..............

Don't stop posting such articles. I love to read blogs like that. By the way add some pics :)

Pingback from  Sites &laquo; Dot Net Solutions

Thank you Itay.  

I also wrote about also pulling in full Manager details with a how to video and easy to follow steps.  

http://www.spjeff.com/?p=422

It seems to work well on my environment and maybe other readers here would find it useful.

First of all thank you for poasting such a wonderful article.

I have followed all the steps but nothing is being shown in my textboxwhen i preview the form.

Please let me know if there are any settings that I need to take care of at the SharePoint end.

Thanks,

Sudeep

Great great post!

Works fine when the form is opened the first time, however does anyone know how to update "PreferredName" when the same form, not a new form, is opened by someone other than the person who initially filled out the form?

Any suggestions or help is appreciated. Thank you.

hello there

 i want to auto populate managers manager name on form loading i like to know whether it is possible .if,yes could you show me how its done .please i need to finish this project ASAP,So please help me

thanks

During the instruction where you tell people to type 'FirstName' you might consider including direction to not include the quotes. When I followed your instructions, I included those, which of course caused the function to not work correctly.

Thank you for the tutorial. This helped me achieve the exact form I needed!

Cant get this to work even though i follow steps exactly.

Text field is empty on preview.

Any ideas why this isnt working as your example?

Pingback from  InfoPath current username | SharePointed

Pingback from  MOSS Infopath &laquo; Dot Net Solutions

Great job!! I get it works.

Thanks a lot

I am trying to do this in infopath beta 2010 and standard version of SP 2010. The information for a particular user is displayed in search but on adding the action to display the data in the form field, apart from name and id no other data is shown though the same is there and is displayed in the search form and there is no error while executing the code as well.

I just tried this in Sharepoint 2010 too. I have it working in a list where I have modified the list form in InfoPath and it is filling the username, department and manager from the logged in user correctly.

BUT doing this in an InfoPath form library displaying as a web form returns "Administrator" in the username field. I am logged into SharePoint as me not as administrator.  When I preview that same form in InfoPath on my PC it shows my name.

In my case the string:

Value[Name = "workEmail"]

returns: uht@jndata.dk

I need a string who returns everything before the "@" sign. So in my case it should return: uht

does anyone know how to do this?

Hi Everyone,

For those of you curious how to "refresh" the User currently signed in. Try adding a rule to query your data connection. This will in effect refresh your data connection and pull in that latest GetProfileByName information.

Hope that helps!

I have tried this in Infopath 2010 an it is not working, I am new at this,what is the pingback?

Will that solve this?

I need to figure this out, why can you not use parameteres with the username() function?

The example works.

But what is, if I would to Get two Informations (First and LasName) into a Textbox (not just one of them) with this method?

I tried to concat the Two Informations in One Textfield - it doesn't Work.

A second way to concat the data is, that you write out First and LastName in two different Textboxes and than Concat in a Third. But this is inconvenient I think.

How can I get more than one Information into a Textbox?

Great post, I have been using it in a development environment for some time now.

Unfortunately, when trying it in a live environment I am unable to get it to work correctly.

I have created a dataconnection and converted it into a udcx file which is relative to the form. when accessing it with an admin account everything works fine.

when trying to access it with a normal account it doesnt work.

i receive the famous:

Hide error details

"An error occurred accessing a data source. "

when checking the ULS logs i can see the following:

System.Net.WebException: The remote server returned an error: (500) Internal Server Error.     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 dataAdapterTime... 1954f4fb-d5d9-41e1-8b89-571d8f196297

06/24/2010 16:11:34.14* w3wp.exe (0x0B7C)                       0x0C64 Forms Server                   Forms Services Data Objects   13zh Exception ...r, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf) 1954f4fb-d5d9-41e1-8b89-571d8f196297

Any sugestions?

Many times when you have a user filling out an InfoPath form, you would like to auto-populate some of

@jones

Value formula

concat(Value[Name = "FirstName"], " ", Value[Name = "LastName"])

This gives first and last names separated by a space.

@Ulrik Holm Tiemroth

Value formula is

substring-before(Value[Name = "WorkEmail"], "@")

Great post...keep it up!

Hi , thx for the post  i am looking for the same post but im  more looking for Active directory Group ( Member Of ). thank you for your help

Pingback from  InfoPath ??? get User information with NO CODE using SP UserProfileService &laquo; skySPoint

this works great when in the infopath client but no matter what I do I cannot get it to work in browser forms.  It works but it will only return the application pool identity account.  

Because I am using this app pool account to solve the double hop issue in the BCS with external lists connected to SQL.  

I dont understand why its using this account when accessing a list that is already in sharepoint.

Any help???

I used the example for populating a document information panel for some templates (content types) in SharePoint.

Question:

Do you need to install InfoPath on the client in order to make the PID work?

Thanks in advance

Todah Rabbah! Shana Tovah lecha.

I had this bookmarked and now we are on to Office 2010 - I love that this method still works in InfoPath 2010 :)  Glad I saved it!!

Thanks so much!!

BTW - it works for my Browser forms just fine.

I bookmarked this when I did it a long time ago, and I love that it still works now that we have moved on to SP 2010 and Office 2010.  

Thanks so much!

BTW - to previous posters, mine works fine in Browser forms.

Also, your google Ads are taking over the page so the only way to see the info was if I hit STOP real fast before the google ads loaded.

Pingback from  VB Code to get information from Active Direcoty

What exactly do we use for the servername/.../UserProfileService.asmx  url?

Sharepoint site? or something else?

It wont find any site that i put in...I cant pass step 4!

This blog rocks. The above seems to be a standard thing in SP, but dang if it ain't much better to find it on the web at our fingertips.   Mighty fine up here Itay.

i found the services at my company at the following spot:

personal.collaborationtools.consumer.companyname.net/.../UserProfileService.asmx

where COMPANYNAME is obviously going to differ by your environment.  Also, no guarantees that the path will be the same as yours.... - obviously !!

Hi

I would like to thanks in advance.

I stuck in between in some problem in between Info path forms.

I have a Info path forms in which we have a fields called DO which refereed to some user name.So we filled that name.

We want that when that DO user name open that form it will be he only able to see the form in submission mode else any other user will see the form in read only mode.

But we want this condition to be follow as

I don't what to compare with the share point users group but to check whether the logged in user has “Full Control”,”Design”,”Contribute”,”Read only rights”.

Pingback from  InfoPath using WebService &laquo; Emmett&#039;s SharePoint 2010 Blog

Hello,

This blog is good, but according to my requirement i need to display Department name, Telephone Number, Location, etc in my Infopath form.

I can fetch the username in my infopath form but can you help me to fetch other details from active directory to infopath forms.

Thanks and Regards,

ANIL

Great post, thank you very much.

I have solved "Log ID:5566" issue as well.

1. Open the Central Administration site.

2. Application Management - Manage web applications.

3. Click on the web application you are using.

4. Authentication Providers

5. On the Authentication Provider page, click the "Default" Zone link.

6. On the Edit Authentication page, uncheck the box labeled "Enable Anonymous Access"

7. Click the Save button

8. Try to open your form again

Hi, great post. Is there anyway of using the people picker form to send data to fields and then use this method to extract data about that user rather than the logged on user

This is absolutely fabulous!!!!  I have been looking for a simple explanation of how to do this!  Steps were super easy to follow and worked like a charm.

Thank you so much for sharing this!

Great post.  I tried to use "Manager" but it returns the "Domain\UserName" instead of the display name. It doesn't appear to be able to show this properly "without code".  Any ideas?

Thanks for shareing your work.

Hi,

I posted a comment sometime ago but it was not published. So now i am wondering what went wrong.

Please explain.

Thanks

Great article !!! saved my day.

Thanks

It's a great article. I learned a lot from it. But I still have an issue of populating a text field on the form when it's loaded. I used web service you suggested, went through all the steps, but the field is still empty.

I'm not sure what is the problem. Help from anybody will be truly appreciated.

Thanks.

Pingback from  ?????????? ???? ???????? ????  infopath ???????? domain ?????????????? ??????

This almost works in Infopath 2010/SP 2010. It returns with no errors but only the UserName,PreferredName and AccountName are populated. All other fields are blank. Anyone know why?

Is it possible to redact this document and advise us how to do this only in Infopath 2010.

I use user name to lookup the user, then I want to lookup the manager of that user, then I want the email of that user, then I want to send that user this form.

I also want to digitally sign the document by the user, and then by the manager.

How do I do this ?

Thanks for this article

I needed the domain as well whereas the username() function does not, but this seems to work.

many thanks for this posting, it's save me a lot of time to research or making code to do that. Just try it and it's work. :)

Hi everyone,

I can not get the real answer to the following question, even after reading all above postes...

that, how someone can get the Manager Proper Name instead Manger ID with Domain name.

As example is given on the above posts (CONTOSO\.b.margareth)

Thank you in anticipation

Regards,

Muzammil Hussain

Very good post.. It works exactly the same way as mentioned.. I appreciate your time and for the tips..

ok so i have things set up and working correctly except for one thing...

I can open the gui to select a person and search from the list fine.  I select the user, select add, then select ok.  instead of the name being displayed in the box it become greyed out and unselectable.  

Any ideas on what could be wrong?

Almost 4 years later, this works great!  Thank you so much!!

Great Article, Itay!. You saved my job :)

Hello

This blog is informative with all necassary details. I could add a web service reference in my infopath form with no issues, however no data shows up when i preview the  form. Can you please help with this issue? I need to resolve it as soon as possible.

Great post, but never did see an answer for displaying repeating information like SPS-Skills or SPS-Responsibilities. Can you share how you would add those?

Any ideas as to how to fetch the user current location??

Any ideas as to how to fetch the user current location??

..its very urgent..pls reply..

Great article.

Tried to implement this with Infopath 2010 against MOSS 2010. I am receiving the accountname but firstname and lastname returns blank. Does anyone have an idea why?

TIA.

It doesnot work in case of FBA, does it require some other settings?

Please help if any.

That really rocks.

Just have a question. I am (using SP2010 and IP2010) trying to work with that on a SP List. I am able to retrieve the current user and able to store the Infos in the SP List. However, everytime I open an existing List entry it shows the current user and not the list entry, although the list entry is stored correctly.

I tried to work around with different views but no solution.

Is my idea of combining this with a SharePoint List possible?

Any help really appreciated. Many thanks

Thanks a lot ...... it was helpful to me

Greetings from Moldova!

Pingback from  A Simple Vacation Management System ??? no development required! &laquo; Mindenman32&#039;s Blog

Pingback from  User Profiles ??? Driving Business Process  |  Mike Oryszak (@Next_Connect) - SharePoint Server MVP

Thank you very much for providing the useful info..

My issue has been resolved by following the above mentioned info...

A very detailed article along with the screenshots...Thanks again..

Itaysk,

Thank you so much!  I really appreciate your insight and solution!

j

Thanks for this post !! Great work

Thanks for great post, i have anonymous infopath form & i get error 5566 for anonymous form but it works fine for internaly. so can you please suggest for anonymous infopath form.

Hello,

I followed all the steps still I'm not getting anything in TextBox.

I'm using SP 2010 & Infopath 2007.

Any guess why I'm not getting any data???

Thanks for great post, i have anonymous infopath form & i get error 5566 for anonymous infopath form

but it works fine for Internaly. so can you please suggest for why web server is not able to connect to datasource in anonymous infopath form.

GREAT information! I have been able to get this to work and pull the user's manager information. Is there then a way to pull the manager's manager information? I tried the GetCommonManager just for fun but it didn't work.

Basically trying to use this for a PO Process needing approvals.

Normally, you would have to add the

webservice as follows:

https or servername.com/.../UserProfileService.asmx

that should get you to the data elements

you are looking for...

Absolutely fantastic - this has saved me some hair. Thanks.

Pingback from  InfoPath &#8211; Get the current user from Sharepoint -  Microsoft .NET & Business Intelligence Development in Sydney

My question is… how do I work this if I don’t have access to the server and I am only admin on my page?

I have followed the exact steps and I was successful in creating “GetUserProfileByName” on external1.collaboration.hp.com/.../UserProfileService.asmx

But… the problem is when I click Preview (I am using InfoPath 20010 and SharePoint 2007), I get the following message Box:

” Some external data was not retrieved. The form will load without the requested data.”

When I click on Show Details button, I get the following message:

“The SOAP response indicates that an error occurred on the server:

Server was unable to process request. ---> Access Denied: To create a user profile, you must be an administrator, or create your own profile and have personal features rights.”

Can anyone help, it is urgent

hi good post

i tried it thank you so much man

keep it upp

Every time iam getting account name as administrator only,when i changed user login as other person also its not reflecting in the infopath form

plz find the solution

I am using SharePoint online office 365. I want to do the same thing in my SharePoint site as this is for SharePoint 2010. I am unable to create the connection. Can any one help? How can I create a connection to access the user profile or GetUserbyProfileName?

Thanks in advance.

M. A. Khan

Thx a lot for this great description...works very well!

MS InfoPath2003

Thanks,

Spooky

I've been using this for years and I never had any problems. I never thanked you either. Thank you very much.

I created a data connection from my InfoPath form this morning and in another form template this afternoon I'm getting 'access denied' even though I can browse to the URL of the web service and see all the methods.

Any ideas what the hell's going on?

I've tried a number of accounts and checked my account in AD but...

Nothing's changed since this morning; as far as I'm aware (I'm the only developer)

Thanks.

N03L.

Pingback from  Open Abstracts: A Few InfoPath Tips  &mdash;  Log

Bravo, este pensamiento magnГ­fico tiene que justamente a propГіsito  

http://eru1.myftp.biz/  

yellow

Pingback from  Tena Matta  &raquo; Blog Archive   &raquo; InfoPath User Permissions from UserID with NO CODE!! &raquo; Tena Matta

cannot get the for to work in sharepoint. Always displays the "Sharepont Login" for the PreferredName. Works correctly in InfoPath... I see a lot of talk on this, but no resolution...

Pingback from  InfoPath &#8211; Get the current user without writing code &laquo; sharepointworks

Pingback from  InfoPath Gotcha: User Profile Displaying Admin User | Bobby&#039;s SharePoint World

Pingback from  Tena Matta  &raquo; Blog Archive   &raquo; InfoPath &#8211; Get the current user without writing code &raquo; Tena Matta

Thank you for posting the list of default profile properties  returned by the userprofileservice. I do not have access to CA and it saved me a lot of time!

Pingback from  InfoPath om MOSS 2007 Current User Profile | Jack Tingzon&#039;s Blog

Pingback from  InfoPath 2010  migration with user profile and sharepoint user group services &laquo; shloksharepoint

can anyone tell,how the cascading drop down box in infopath form can be dependent by using sharepoint2010 and should not use filters and SQL.

as the infopath form is browser enabled

     anyone help on this issue.please........

good one

Hi

A colleague and I followed the initiators instructions to the letter and had no issues at all - neither on the InfoPath 2007 form nor when we published to our Sharepoint 2007 Library

I have been working on a SharePoint 2010 site and the site owner wanted a form that would auto populate

Hi all,

I followed the instructions 1by1 but cant get it to work. First I thought the WebService isnt returning anything but if I insert just this "Value[Name = "WorkPhone"]" into the fields default value I do get a result (although it's just my own). So the connection is there.

As I said, using the above descibed way the field remains empty. I'm loosing my hair on this so please give me some hints. Thanks alot.

kkedbcmpht, <a href="http://valiumuse.com/">Bibliophile">valiumuse.com/">Bibliophile valium comments e-mail name comment [b][/b] - [i][/i] - [u][/u]- [quote][/</a>, sABaRWE, [url=http://valiumuse.com/]Valium herbal[/url], VsksQSo, http://valiumuse.com/ Valium cat, cUAatiO.

Excelent. This information is so useful.

Thanks

Pingback from  Nilesh Rathod

hello everyone!  

where can I find top adultreviews?  

This only have I found <a href=www.hqpornspots.com/.../>Matt's Models</a>  

thanks

There has been a desire to escape from participating in a circus of gossip that have contributed to the fall in the situation where it is today.

That was a truly amazing piece of writing!

You'll be able to seriously make a superior very first impression on all people whenever you are getting into a room, in case you have on some seriously wonderful items of jewelry. It is best to pay out shut focus to these handy strategies and rely on them, so that you'll  explore the best way to decide on jewelry.              

When operating with harsh chemicals like cleaning merchandise, performing laundry, or taking a shower you should generally remove your jewelry. To scrub your jewelry you need to use heat water which has a delicate soap, rinse it off, then polish your jewelry that has a jewellery polish and dry before placing it back into storage.              

With regards to   exhibiting off your temperament by means of jewelry, most of the time it is possible to make a bigger assertion with significantly less. Pick out daring, extraordinary pieces, but limit on your own to putting on one particular or two at a time. A sophisticated pair of chandelier earrings can set off an outfit on it truly is <a href=www.cheapuggtall.com/>uggs on sale</a>

own, and often a flashy cocktail ring is definitely the only glitz you'll need to draw consideration.              

You shouldn't have on your jewellery in the event you program on likely for the swim or when you plan on heading in any other physique of water that could have harsh substances. These types of details can cause your jewelry to age considerably a lot more speedily. Guard your jewelry and be conscientious.              

In case you have <a href=www.uggssnowboot.com/>ugg boots</a>

 fantastic jewellery or heirloom jewelry whose price you must protect by way of insurance policy, it's a good idea to just take superb images of those pieces also to have an appraisal completed by knowledgeable. Ensure which the pictures you are taking are superior, quality kinds. Applying a flash when using these pictures will never lead to superior footage of one's jewellery. It is best to seize a picture of your respective cherished jewellery less than comfortable, diffused fluorescent bulbs.              

To create the proper volume of flair to any outfit basically add one particular statement bit of jewelry. Irrespective of whether it be a major ring, some daring earrings, a thick bracelet, or perhaps a chunky necklace, including a press release piece to any outfit is not going to only bring it out of the regular but will also allow it to be much more 'you'. In addition, a statement piece is absolutely sure to create a fantastic conversation starter in any event.

hello everyone,

How can I get the user's manager name from a field X on the form?

thanks,

Ofra

Pingback from  Problem with getting UserName using webservices in InfoPath | Q&amp;A System

Pingback from  Wat kan InfoPath voor mij betekenen ??? Deel 7 &laquo;  SPC NL

Pingback from  Implementing Workflow using InfoPath 2010 and SharePoint designer 2010 | Jamil Haddadin

Can I get the current list (which the form is connected to)

by lists.asmx, like you got the current user?

I tried with no success.

Thanks ahead!