SharePoint User Profile Service Application Provisioning Issues
Quick Fix:
$sync_db = "Sync DB"
$ups_service_app_name = "User Profile Service Application"
net stop sptimerv4
$syncdb=Get-SPDatabase | where {$_.Name -eq $sync_db}
$syncdb.Unprovision()
$syncdb.Status='Offline'
$ups = Get-SPServiceApplication | where {$_.Displayname -eq $ups_service_app_name }
$ups.ResetSynchronizationMachine()
$ups.ResetSynchronizationDatabase()
$syncdb.Provision()
net start sptimerv4
------------------------------------------------------------------------------------------------------------------------------
Get-SPServiceInstance | where {$_.TypeName -eq "User Profile Synchronization Service"}
User Profile Synchronization ... Online ID of the service instance 1
User Profile Synchronization ... Online ID of the service instance 1
User Profile Synchronization ... Provi... ID of the service instance 2
$abc=Get-SPServiceInstance | where {$_.Id -eq "ID of the service instance 2"}
Stop-SPServiceInstance | where {$_.Id -eq "ID of the service instance 2"}
$abc=Get-SPServiceInstance | where {$_.Id -eq "ID of the service instance 2"}
Stop-SPServiceInstance | where {$_.Id -eq "ID of the service instance 2"}
and the lifesaver Reset SharePoint Cache: reference: (http://saadiyadad.blogspot.com/2014/03/reset-SharePoint-config-cache.html) did the magic
