SP 2013 Error when upgrading the User Profile service application

 

 

 

While upgrading UPA from SharePoint 2010 to SharePoint 2013 we got error in PowerShell.

 

New-SPProfileServiceApplication : Action 15.0.95.0 of
Microsoft.Office.Server.Upgrade.ProfileDatabaseSequence failed.
At line:1 char:8
+ $upa = New-SPProfileServiceApplication -Name 'User Profile Service
Application'  ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
    + CategoryInfo          : InvalidData: (Microsoft.Offic...viceApplication:
   SPCmdletNewProfileServiceApplication) [New-SPProfileServiceApplication], S
  PUpgradeException
    + FullyQualifiedErrorId : Microsoft.Office.Server.UserProfiles.PowerShell.
   SPCmdletNewProfileServiceApplication

 

03/04/2013 12:29:28.71 PowerShell.exe (0x1248) 0x128C SharePoint Foundation Upgrade ajywk Unexpected 03/04/2013 12:29:28.71 powershell (0x1248) 0x128C SharePoint Foundation Upgrade ProfileDatabaseSequence ajywk ERROR Action 15.0.95.0 of Microsoft.Office.Server.Upgrade.ProfileDatabaseSequence failed. xxxxxx-87ee-4328-b0a3-01ee9d97a3b2 c6d11cc1-87ee-4328-b0a3-01ee9d97a3b2
03/04/2013 12:29:28.71 PowerShell.exe (0x1248) 0x128C SharePoint Foundation Upgrade ajywk Unexpected 03/04/2013 12:29:28.71 powershell (0x1248) 0x128C SharePoint Foundation Upgrade ProfileDatabaseSequence ajywk ERROR Exception: Incorrect syntax near 'xxxx_MThumb'.  The label 'http' has already been declared. Label names must be unique within a query batch or stored procedure.  The label 'http' has already been declared. Label names must be unique within a query batch or stored procedure.  The label 'http' has already been declared. Label names must be unique within a query batch or stored procedure.  Unclosed quotation mark after the character string ' AND RecordID=1361;  '. c6d11cc1-87ee-4328-b0a3-01ee9d97a3b2 c6d11cc1-87ee-4328-b0a3-01ee9d97a3b2
03/04/2013 12:29:28.71 PowerShell.exe (0x1248) 0x128C SharePoint Foundation Upgrade ajywk Unexpected 03/04/2013 12:29:28.71 powershell (0x1248) 0x128C SharePoint Foundation Upgrade ProfileDatabaseSequence ajywk ERROR    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.Office.Server.Upgrade.RemoveQueryStringFromPictureUrls.ExecuteUpgradeQuery(String upgradeQuery)     at Microsoft.Office.Server.Upgrade.RemoveQueryStringFromPictureUrls.Upgrade()     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() c6d11cc1-87ee-4328-b0a3-01ee9d97a3b2 c6d11cc1-87ee-4328-b0a3-01ee9d97a3b2

Solution:-

• Run full profile import and make sure it is finished.
• Then run “Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation <https://mysite”> in SharePoint PowerShell
• Then backup all three databases and restore with different name
• Now try again to upgrade on 2013 environment