i:0#.w|Ali.Mazaheri

SharePoint, Office 365 and Azure!

Troubleshooting SharePoint Server 2010 User Profile Synchronization service (RTM)

Troubleshooting SharePoint Server 2010 User Profile Synchronization service (RTM)

  • Comments 1

As part of configuring your SharePoint Server 2010 farm you need to start the User Profile Synchronization service so you can import user profiles from AD or other applicable sources, one of the issues you may face is that after starting the service you see a series of event logs such as :

error1

and

error2

And eventually service fails to start the related FIM services and provisioning the sync database.

In that case following steps may resolve the issue and help starting the UPA sync service:

1) $syncdb=Get-SPDatabase -Id <GUID of User Profile Sync DB>
2) $syncdb.Unprovision()
3) $syncdb.Status='Offline'
4) $upa=Get-SPServiceApplication -Id <GUID of User Profile Service>
5) $upa.ResetSynchronizationMachine()
6) $upa.ResetSynchronizationDatabase()
7) $syncdb.Provision()
8) Add the User Profile Synchronization service account as dbo on the Sync DB
9) Restart the sptimerv4
10) Start the UPA using Central Administration site and iisreset

[UPDATE]

This issue came up when I tried to start the sync service against UPA that was provisioned either by upgrading a MOSS 2007 SSP database or in Partition mode for multi-tenant configuration.

  • That did the trick! Thanks so much, Ali!  Had this problem in SP2013 as part of an upgrade from SP2010.

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 2 and 8 and type the answer here:
  • Post