locked
Error message when migrating user profile RRS feed

  • Question

  • I receive the following error when using stsadm -o migrateuser -oldlogin olddomain\username -newlogin  newdomain\username  -ignoresidhistoryNone of our sitew collections are above their storage quotas - they are all below the warning threshold set for them.

    Error:

    Your changes could not be saved because this SharePoint Web site has exceeded th
    e storage quota limit.
    You must save your work to another location.  Contact your administrator to chan
    ge the quota limits for the Web site.


    Albert Buswell
    • Moved by Mike Walsh FIN Saturday, August 27, 2011 6:07 AM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Friday, August 26, 2011 4:38 PM

Answers

  • Abuswell,

    Try executing SQL select command on content db. Sql does the job to find sites that exceed the quotas. This should give more clear picture. Come with understanding that you perform read-only command.

    replace "ContentDB" with the name of the content db you want to check. If you want to check multiple DB's just paste it multiple times to you query editor.

    use ContentDBGo
    select distinct a.fullurl as ContentDB,b.tp_login as [SiteAdmin],sum(cast(c.size as decimal))/1024/1024 as [recyclebin],cast(d.diskused as decimal)/1024/1024 as [SiteSize],cast(d.diskquota as decimal)/1024/1024 as [SiteMaxQuota]from webs as ainner join sites as d on a.siteid=d.idinner join userinfo as b on a.siteid=b.tp_siteidleft join recyclebin as c on a.siteid=c.siteidwhereb.tp_login like '%Login%' and d.diskused > d.diskquotaand a.parentwebid is nullgroup by a.fullurl, b.tp_login, d.diskused, d.id, d.diskquota, d.lastcontentchangeOrder by a.fullurl


    Solution is complement of : http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/12ea9537-49e1-45ff-a1c9-e802ade070dd


    Leonid Lyublinski Wizard of MOSS
    • Marked as answer by Pengyu Zhao Tuesday, September 6, 2011 6:17 AM
    Monday, August 29, 2011 7:46 PM

All replies

  • Hi Albert,

     

    You can try to reset the personal site quota to unrestricted to see if the error still exist.

     

    Thanks,

    Pengyu Zhao

    Monday, August 29, 2011 4:54 AM
  • Hi,

    Server administrators are able to set limits on the amount of storage space that sites can use on the server. Contact your server administrator to request that the storage quota for the Web site be increased.

    check this link

    http://techtrainingnotes.blogspot.com/2008/02/sharepoint-site-collection-quotas.html

     

    hope this helps you


    Warm Regards, Bhushan http://www.passionatetechie.blogspot.com
    Monday, August 29, 2011 8:10 AM
  • Thanks for your response. The personal site quota is 100 MB and the user's personal site is only using 1 MB. The site collection quota is set at 10000 MB and it's only using 913 MB.  i'm not sure what else to try.

    Thanks,

    Albert


    Albert Buswell
    Monday, August 29, 2011 5:47 PM
  • HI,

    Try executing this command under verbose mode of logging to check if anything else gets captured.

    How many site collections are in your farm where user has access?

    I suggest you to write up a small console application and find out the places where this user has permissions and check the quota for them.

    Do let me know if you require code for it.

    I hope this will help you out.


    Thanks, Rahul Rashu
    Monday, August 29, 2011 6:20 PM
  • Abuswell,

    Try executing SQL select command on content db. Sql does the job to find sites that exceed the quotas. This should give more clear picture. Come with understanding that you perform read-only command.

    replace "ContentDB" with the name of the content db you want to check. If you want to check multiple DB's just paste it multiple times to you query editor.

    use ContentDBGo
    select distinct a.fullurl as ContentDB,b.tp_login as [SiteAdmin],sum(cast(c.size as decimal))/1024/1024 as [recyclebin],cast(d.diskused as decimal)/1024/1024 as [SiteSize],cast(d.diskquota as decimal)/1024/1024 as [SiteMaxQuota]from webs as ainner join sites as d on a.siteid=d.idinner join userinfo as b on a.siteid=b.tp_siteidleft join recyclebin as c on a.siteid=c.siteidwhereb.tp_login like '%Login%' and d.diskused > d.diskquotaand a.parentwebid is nullgroup by a.fullurl, b.tp_login, d.diskused, d.id, d.diskquota, d.lastcontentchangeOrder by a.fullurl


    Solution is complement of : http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/12ea9537-49e1-45ff-a1c9-e802ade070dd


    Leonid Lyublinski Wizard of MOSS
    • Marked as answer by Pengyu Zhao Tuesday, September 6, 2011 6:17 AM
    Monday, August 29, 2011 7:46 PM