다음을 통해 공유

UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException

  • 아티클

RUN AS FARMADMIN!!!!!

 

$sync_db = "PROD_SA_UPS_Sync"

$ups_service_app_name = "User Profile Service"

 

 

 

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

 

Start the UserProfileSyncService again

Comments

  • Anonymous
    January 01, 2003
    In my case (SharePoint 2013 SP1, Windows Server 2012, SQL Server 2014) it was helpful to install KB2878240.
  • Anonymous
    April 17, 2014
    Thank you! :)
  • Anonymous
    June 10, 2014
    Thanks, this saved our day. :-) It seems this happens when you provision the User Profile Service Application through PowerShell, rather than through the CA UI.
  • Anonymous
    June 12, 2014
    Perfect.
  • Anonymous
    July 10, 2014
    Awesome, life saving.....thanks
  • Anonymous
    September 26, 2014
    You my friend are awesome, this was a perfect solution. Thank you so much! I was having this issued with a scripted install and a 2 web 3 app 1 SQL Farm.
  • Anonymous
    October 01, 2015
    Dude you are a superstar! above is better than following http://www.harbar.net/archive/2010/10/30/avoiding-the-default-schema-issue-when-creating-the-user-profile.aspx
  • Anonymous
    June 22, 2016
    The comment has been removed