User missing from all site collections but present in User Profile (Central Admin)

I have a user who does not show up in "People and Groups" (or if I search for this user) in any of the site collections but does show up when I look up his user profile on Central Admin. I've tried to add this user to the site collection using the following command, but I get an error: " The specified user domain\accountname could not be found."

Get-SPWeb 'http://site' | New-SPUser -UserAlias 'domain\accountname'

Idk if this is related, but on this user's profile, "Personal Site" field shows up as "SPSSITEERROR".

Any help would be greatly appreciated.

Thanks.

February 12th, 2015 11:10pm

Hi,

I recommend to check if the user exists in Active Directory firstly.

If yes, then the error will occur. And for the user profile of the user, it may due to the user profiles have not been synced with Active Directory yet.

That "Personal Site" field shows up as "SPSSITEERROR" means that the MySite of that user has not been created successfully.

I recommend to run User Profile Synchronization timer job and then check the results.

Thanks,

Victoria

Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Free Windows Admin Tool Kit Click here and download it now
February 16th, 2015 5:25am

OK I have been trying to look for a resolution to the issue and while no solution seems to be fixing this, I finally discovered it was rather a simple fix.
Scenario: Users could not create new mysites in production, while existing mysites worked without issues. 
To isolate the issue, I had the users create a mysite on UAT\Dev environment to isolate the issue with the Active Directory Account (The dev\UAT\production uses the same AD). Mysite was successfully created on the UAT, which rules out issues with the Active directory. The issue should be with the production farm only.

Solution: While the logs do not suggest much, I stumbled on the my site database and noticed that the mysite database currently has 5000 sites which is the default max limit of the databases. That was the actual issue. I increased the max sites in a database to 8000 and the issue was immediately resolved.
To check the database settings you should go to central admin> Application management> Manage content databases. Choose the appropriate web application to get a list of databases and once you have the mysite database, check for the "current number of site collections" which should be less than the "Max number of site collections". Also make sure the database status is "started".

Please mark as an answer if it helps you

Regards
Faisal 
August 24th, 2015 11:53am

Another possibility is to add another content database to the web application via the manage content database menus
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 7:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics