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 http://mysite” in SharePoint PowerShell
• Then backup all three databases and restore with different name
• Now try again to upgrade on 2013 environment


Comments (20)

  1. Anonymous says:

    i have tried these steps several times, but i continue to get the error message above. i am restoring the user profile db to test domain that is a clone of production, but may be missing some users from AD. i get the error regardless of the inclusion or exclusion of the social and sync dbs in the command. any suggestions??

  2. Anonymous says:

    i have tried these steps several times, but i continue to get the error message above. i am restoring the user profile db to test domain that is a clone of production, but may be missing some users from AD. i get the error regardless of the inclusion or exclusion of the social and sync dbs in the command. any suggestions??
    Maxine (maxinejunk@gmail.com)

  3. lkhbkjh says:

    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D9%83%D8%B4%D9%81-%D8%AA%D8%B3%D8%B1%D8%A8%D8%A7%D8%AA-%D8%A7%D9%84%D9%85%D9%8A%D8%A7%D9%87-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/689097207779289
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D8%AE%D8%B2%D9%8A%D9%86-%D8%A7%D8%AB%D8%A7%D8%AB-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/1445044082381413
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D9%86%D9%82%D9%84-%D8%A7%D8%AB%D8%A7%D8%AB-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/681979721833683
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D8%AE%D8%B2%D9%8A%D9%86-%D8%B9%D9%81%D8%B4-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/449379651829818
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D9%86%D9%82%D9%84-%D8%B9%D9%81%D8%B4-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/626286970743145
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D9%85%D9%88%D9%83%D9%8A%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/683322578367802
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D9%85%D8%AC%D8%A7%D9%84%D8%B3-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/239948852832803
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D8%B4%D9%82%D9%82-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/454482277991520

  4. bvbv says:

    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D8%A8%D9%8A%D9%88%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/582072298532499
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D9%85%D9%86%D8%A7%D8%B2%D9%84-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/1383616101892598
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D8%A8%D9%8A%D8%A7%D8%B1%D8%A7%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/660035150715637
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D9%85%D9%83%D8%A7%D9%81%D8%AD%D8%A9-%D8%AD%D8%B4%D8%B1%D8%A7%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/197730377082521
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D8%B1%D9%85%D9%8A%D9%85%D8%A7%D8%AA-%D8%B9%D8%A7%D9%85%D8%A9-%D8%A8%D8%A7%D9%84%D8%B1%D9%8A%D8%A7%D8%B6-0540736424-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/634981213226909
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%B9%D8%B2%D9%84-%D8%AE%D8%B2%D8%A7%D9%86%D8%A7%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/556904561070344
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%B9%D8%B2%D9%84-%D8%A7%D8%B3%D8%B7%D8%AD-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/686664478040168
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D9%86%D8%B8%D9%8A%D9%81-%D8%AE%D8%B2%D8%A7%D9%86%D8%A7%D8%AA-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/602063616527949
    https://www.facebook.com/pages/%D8%B4%D8%B1%D9%83%D8%A9-%D8%AA%D8%B3%D9%84%D9%8A%D9%83-%D9%85%D8%AC%D8%A7%D8%B1%D9%8A-%D8%A8%D8%A7%D9%84%D8%AE%D8%B1%D8%AC-0566406517-%D9%82%D9%85%D8%A9-%D8%A7%D9%84%D8%A7%D9%86%D8%AC%D8%A7%D8%B2/1429300213969249

  5. dodo says:

    شات صوتي [www.f6h6.com] دردشة صوتية [http://www.f6h6.com] شات [http://www.f6h6.com] دردشة [http://www.f6h6.com] الشات صوتي [http://www.f6h6.com]
    الدردشة الصوتية [http://www.f6h6.com] الفاتن [http://www.f6h6.com] صوتي [http://www.f6h6.com] صوتية [http://www.f6h6.com]
    شات صوتي كام [http://www.f6h6.com] شات صوتي سعودي [http://www.f6h6.com] شات صوتي بنات [http://www.f6h6.com] شات [http://www.f6h6.com]
    دردشة [http://www.f6h6.com] صوتي الشات [http://www.f6h6.com]

    شات الخليج [http://www.khaaleg.com] دردشة الخليج [http://www.khaaleg.com] الخليج [http://www.khaaleg.com] شات [http://www.khaaleg.com]
    خليجي [http://www.khaaleg.com] الخليج [http://www.khaaleg.com] دردش الخليج [http://www.khaaleg.com] شات الخليج [http://www.khaaleg.com]
    دردشه الخليج [http://www.khaaleg.com]
    العاب طبخ [http://tabkhjeux.com] لعبة طبخ [http://tabkhjeux.com] العب طبخ [http://tabkhjeux.com] طبخ [http://tabkhjeux.com]
    طبخ العاب [http://tabkhjeux.com] العاب طبخ بنات [http://tabkhjeux.com]

    http://tabkhjeux.com العاب طبخ
    http://tabkhjeux.com لعبة طبخ
    http://tabkhjeux.com طبخ
    http://tabkhjeux.com العاب
    http://www.f6h6.com شات
    http://www.f6h6.com دردشة
    http://www.f6h6.com شات صوتي
    http://www.f6h6.com دردشة صوتية
    http://www.f6h6.com شات صوتي كام
    http://www.f6h6.com شات صوتي سعودي
    http://www.f6h6.com صوتية
    http://www.khaaleg.com شات الخليج
    http://www.khaaleg.com دردشة الخليج
    http://www.khaaleg.com الخليج
    http://www.khaaleg.com الخليج شات

  6. hairlosscure says:

    is very interesting;
    http://hairlosscuree.com/

  7. grr7e says:

    Thanks for the

    http://ksadlaa3.com" rel="nofollow">Click here

    http://www.3ssli.com" rel="nofollow">Click here

    http://www.ksato2p.com" rel="nofollow">Click here

    http://www.ksadlaa3.com" rel="dofollow">Click here

    http://www.3ssli.com" rel="dofollow">Click here

    http://www.ksato2p.com" rel="dofollow">Click here

    http://ksadlaa3.com" rel="nofollow">سعودي انحراف

    http://www.3ssli.com" rel="nofollow">شات عسلي

    http://www.ksato2p.com" rel="nofollow">سعودي كول

    http://www.grr7e.com" rel="nofollow">شات صوتي

  8. 3ssli.com says:

    Thanks for the

    http://ksadlaa3.com" rel="nofollow">Click here

    http://www.3ssli.com" rel="nofollow">Click here

    http://www.ksato2p.com" rel="nofollow">Click here

    http://www.ksadlaa3.com" rel="dofollow">Click here

    http://www.3ssli.com" rel="dofollow">Click here

    http://www.ksato2p.com" rel="dofollow">Click here

    http://ksadlaa3.com" rel="nofollow">سعودي انحراف

    http://www.3ssli.com" rel="nofollow">شات عسلي

    http://www.ksato2p.com" rel="nofollow">سعودي كول

    http://www.grr7e.com" rel="nofollow">شات صوتي

  9. grr7e says:

    Thanks for the

    http://ksadlaa3.com" rel="nofollow">Click here
    http://www.ksato2p.com" rel="nofollow">Click here
    http://www.3ssli.com" rel="nofollow">Click here

    http://www.grr7e.com" rel="nofollow">شات صوتي
    http://www.ksadlaa3.com" rel="nofollow">سعودي انحراف 180
    http://www.ksato2p.com" rel="nofollow">سعودي كول
    http://www.3ssli.com" rel="nofollow">شات عسلي

Skip to main content