InfoPath uses Getuserprofilebyname error 5566 solution in SharePoint 2013

Firstly. Recently tortured for a long time SharePoint about InfoPath table monotone with Getuserprofilebyname data in the database always error 5566. For at least 2 months. Now write the configuration method for SharePoint 203 again. Share to everyone.

1: Install InfoPath, locate Office 2013 in the Start menu, select InfoPath Designer 2013.

First step: Create a new InfoPath form with a SharePoint form library Template

Step two: Establish A data connection for Userprofileservice

Select the data connection in the Ribbon:

In the Data Connection dialog box, click the Add button:

On the first page of the Data Connection Wizard, select New connection to receive data:

On the second page of the Data Connection Wizard, select the SOAP Web service:

On the third page of the Data Connection Wizard, enter the Userprofileservice URL: http://ServerName/_vti_bin/UserProfileService.asmx

On page Fourth of the Data Connection Wizard, select Getuserprofilebyname:

On page fifth of the Data Connection wizard, without setting up, point directly to the next step:

On page sixth of the Data Connection Wizard, leave the check box non-selectable:

On the last page of the Data Connection Wizard, leave the default options and complete the wizard:

After you add the data connection, the Data Connection dialog box becomes as follows, closing this dialog box:

Step three: Establish a domain to hold the current user's LoginName

In the domain panel:

Add a String field Createrloginname:

Then open the domain properties:

Set the default value, click the default value after the button FX:

In the Insert Formula, click Insert Field or group. In the Domain drop-down box, select Getuserprofilebyname, and then select Myfields\datafields\tns:getuserprofilepynameresponse\ Getuserprofilebynameresult\propertydata\values\valuedata\value. As shown in the following:

Then click Filter Data:

Click the Add button:

Select Select a field or group in the first drop-down box, select Getuserprofilebyname in the Domain drop-down box, and then select Myfields\datafields\tns:getuserprofilepynameresponse\ Getuserprofilebynameresult\propertydata\name. As shown in the following:

In the second drop-down box, select Equals, in the third drop-down box, select Type Text ..., and enter "AccountName":

Click OK to close the dialog box and go back to the field or Group Properties dialog box and remove the hook before the refresh value when recalculating formula:

Fourth step: Using LoginName

Just see what you need to do with loginname, I'll simply show the createrloginname in the form and see what the preview looks like:

Written at the end :

If you need to obtain the profile of another user, you can obtain the profile of another user by setting the value of AccountName in Getuserprofilebyname before fetching the data, and then obtaining the data:

If you need to get the value of another profile, just change the AccountName to another property value. The available property values are:

Userprofile_guid accountname FirstName LastName preferredname workphone Office Department Title Manager aboutme personals Pace Pictureurl UserName quicklinks WebSite publicsiteredirect sps-dotted-line sps-peers sps-responsibility SPS-Skills Sps-pastprojects sps-interests sps-school sps-sipaddress sps-birthday sps-mysiteupgrade SPS-DontSuggestList Sps-proxyaddresses sps-hiredate sps-lastcolleagueadded sps-owaurl sps-resourceaccountname SPS-MasterAccountName Assistant workemail CellPhone Fax homephone

Secondly: Although the above already set the value, but in SharePoint inside the post will be error, report what is wrong: 5566

1: Point release

2: Select Server

3: Enter the address of the server you want to publish:

Look, the cute 5566 came out.

How to solve it!

Firstly SharePoint server above found sharepoint2013 Admin Center

2 general application settings found

Configuration: InfoPath Forms Services

3: Tick all the places inside and make sure. Do not move the number part, do not modify. Just tick it all.

Then configure the Infopath Forms Services Web Proxy

Same as above, tick all, press OK

Configure and then configure the secure data connection.

Open the Management Services application

Check to see if this service has a startup, and start the service without booting. Click on the Secure Store service to start the direct mouse

In the future, create a new target program ID

Click New, enter an ID name. and display name. There is also a mailbox point next.

Then point directly to the next step. No need to hide user names,

Then enter the permissions. I gave administrator and another farm and SQL administrator permissions. Members are given to you who need access. I gave it to everyone.

then click Finish.

Be sure to set the voucher when you're done. It's very important here. An account with administrator privileges is preferred.

The permission I gave is administrator. I have used other brand new. Causes an error in the Access Web. It was also 5566, so I changed it to a field administrator.

After setting these parameters, don't worry. And also.

Go back to the InfoPath form here, open the SharePoint home page, locate the subsite that just hosted the form library, and then create a new data connection library named Test5 on this site.

3 After you have created the Data Connection library, locate the InfoPath form that you just saved. Right-click the mouse button design to open the form. Point data connection

Enter an address that is the newly created data Connection Library address. Take a name and pick it up. I know it is.

Just do what you have to do.

It's good to have the conversion done. Then use the path to open the data connection library where the file was just stored. How to open it. Locate the new TEST5 data Connection library that you just created, and then create a new project. Open from within the resource manager.

Look, this is the path. Copy the Windows path directly inside to open it.

Then there is the abc.udcx file just done. Open Notepad with Notepad or Notepad + + software. Sometimes the changes are saved and then commented out. Let's change these places.

That AppID is the ID of the newly created security database in the server farm. Appid= ' Infopathwebservice ' credentialtype= ' NTLM is changed and saved is OK. Hope to help everyone. Deal with the problem well.

I do not know why the image upload is blurred. Need the original version can leave the mailbox. I can send you an e-mail. You can also write me an email

[Email protected]

InfoPath uses Getuserprofilebyname error 5566 solution in SharePoint 2013