SharePoint User Profile Service Application Provisioning Issues

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 ... 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"} 

and the lifesaver Reset SharePoint Cache: reference:  (http://saadiyadad.blogspot.com/2014/03/reset-SharePoint-config-cache.html) did the magic