Hard Knocks - Ben Sufit’s Technical Blog

SharePoint 2010 User Profile Applicaion Error.  Log on to the server and make sure the following services are running: Forefront Identity Manager Service. Forefront Identity Manager Synchronization.

BEGIN TRANSACTION BEGIN TRY --ETL Stuff --If no errors the transaction will commit --If there are errors the transaction will be rolled back and display error END TRY BEGIN CATCH       SELECT ERROR_MESSAGE () AS ErrorMessage ;       IF @@TRANCOUNT > 0             ROLLBACK TRANSACTION ; END CATCH IF @@TRANCOUNT > 0       COMMIT TRANSACTION GO

If you get this error in a search when you know your account has access to the site, and you are running the index service and web on a single server the issue could be resolved by disabling the loop back check.   Note: This does open your sever certain security threats.   1) Click Start, click Run, type regedit, and then click OK. 2) In Registry Editor, locate and then click the following registry key: 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) Quit Registry Editor, and then restart your computer.

SELECT [Login] = upf . NTName , Name = upf . PreferredName , Email = upf . Email , Modified = upf . LastUserUpdate , Property = pl . PropertyName , Value = upv . PropertyVal FROM UserProfile_Full upf left join UserProfileValue upv on upv . RecordID = upf . RecordID left join PropertyList pl on pl . PropertyID = upv . PropertyID order by PreferredName The query that will return users who don’t have their About Me section complete… SELECT Name = [UserProfile_Full] . PreferredName , Email = [UserProfile_Full] . Email , Link  = 'http://yoursite/Person.aspx?accountname=' + NTName , NTName FROM [User Profile Service Application_ProfileDB_22d7956d794a4d9a8e898fd8700a866d] . [dbo] . [UserProfile_Full] where RecordID not in ( select upf . RecordID from UserProfile_Full upf left join UserProfileValue upv on upv . RecordID = upf . RecordID left join PropertyList pl on pl . PropertyID = upv . PropertyID where   PropertyName = 'AboutMe' and D

Run this Query on your UPSA DB. SELECT Name = [UserProfile_Full] . PreferredName , Email = [UserProfile_Full] . Email , Link   = 'http://yoursite/Person.aspx?accountname=' + NTName FROM [User Profile Service Application_ProfileDB] . [dbo] . [UserProfile_Full] where RecordID not in ( select upf . RecordID from UserProfile_Full upf left join UserProfileValue upv on upv . RecordID = upf . RecordID left join PropertyList pl on pl . PropertyID = upv . PropertyID where   PropertyName = 'AboutMe' and DATALENGTH ( upv . PropertyVal ) > 8 ) ) and Email is not null order by Name

This means the break down is between the farm SSP and the Web application.  Make sure the Sync profile jobs are running in central admin.  If they are running logon to the web front end and run the following commands. Run stsadm commnads: stsadm -o sync -listolddatabases 1 stsadm -o sync -deleteolddatabases 1 then removed user from site collection and then added user.