We have more than 90K users in our SharePoint 2010 env., however a particular user details are unavailable in the People search though the user profile is active since last 5yrs. Seems that User profile is ignored while Crawling the people content...Not sure, what to check as it works for the remaining all those users...What could be the issue?
Have used the below SQL query to verify the crawl log however it does not have any entry for that specific user alone(though the user profile is still exists in the UPA also verified the UPA & SSA association)
SELECT top 100 u.crawlid, u.accessurl, u.ContentSourceID, u.LastModifiedTime, u.LastTouchStart, u.DisplayURL, u.errorid, e.errormsg FROM [CrawlStoreDB_39e84a89127c493c896b9296fdb51f5d].[dbo].[MSSCrawlURL] u join [CrawlStoreDB_39e84a89127c493c896b9296fdb51f5d].[dbo].[MSSCrawlErrorList] e on u.errorid=e.errorid where u.DisplayURL like '%userId%' and u.ContentSourceID = 3
I do not think, we may need to check the FIM as the user profile is already exist in the UPA...any clue?