This fixes 2 errors
Error 1) The migration upgrade error below[PortalSiteUpgradeAreaAndListingData] [12.0.1.0] [INFO]: Upgrade encountered an unexpected error.
Halting upgrade... Microsoft.SharePoint.SPException: User cannot be found. at Microsoft.SharePoint.SPUserCollection.GetByID(Int32 id) at Microsoft.SharePoint.SPSite.get_Owner() [SiteSequence] [ERROR]: User cannot be found.
Error 2) Manage Site Collection Owners User cannot be found
I've found a way to fix this but please try at your own risk and backup the database first! I think what is happening is that when SharePoint checks to see who the author (owner) of the site is, if the author doesn't exist Upgrade/migration fails.
The Owner of the site is stored in the Sites database table. The author of the site is stored in the Webs database table.
Step 1
Select * from Webs where FullUrl = ''
Here the full url is the one you are having problems with Copy the siteID it should look like this 3893DC55-756E-430C-8975-6214A531CAE1
Step 2
SELECT * FROM [FortBenn4_SITE].[dbo].[UserInfo] where tp_SiteId='3893DC59-756E-430C-8975-6214A531CAE1'
In here you get lots of records returned look for any valid user just copy the tp_ID for our example we make it 44
Step 3
The author and OwnerID bellow are the one you picked in step 2 (44) UPDATE [Sites] SET [OwnerID] = '44' WHERE [FullUrl]=’ '
Update Webs set Author='44' where FullUrl = ''
Step 4
Finally, go give ownership to the right user Go Windows SharePoint Services Manage Site Collection Owners Give the desired user ownership to the site
Let me know how it works make sure you test it on a backup environment
Subscribe to:
Post Comments (Atom)
9 comments:
buy cheap viagra soft cialis v s viagra suppliers of viagra viagra over the counter viagra blood pressure free sample prescription for viagra viagra and hearing loss viagra suppliers viagra lawyers free viagra without prescription instructions for viagra use viagra alternative homemade viagra can women take viagra
Good post and this enter helped me alot in my college assignement. Gratefulness you as your information.
Your blog is outrageous! I mean, Ive never been so entertained by anything in my life! Your vids are perfect for this. I mean, how did you manage to find something that matches your style of writing so well? Im really happy I started reading this today. Youve got a follower in me for sure!
[url=http://onlinemedistore.com/products/bactrim.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
cvs pharmacy millbury ma http://onlinemedistore.com/products/indinavir.htm pharmacy licensure ohio [url=http://onlinemedistore.com/products/fml-forte.htm]cvs pharmacy extra bucks[/url]
fox army health center pharmacy formulary http://onlinemedistore.com/products/ditropan.htm us prescription pharmacy [url=http://onlinemedistore.com/products/cordarone.htm]cordarone[/url]
mirra pharmacy corp new york http://onlinemedistore.com/products/effexor-xr.htm resent events in pharmacy [url=http://onlinemedistore.com/categories/women-s-health.htm]hyvee pharmacy[/url]
llyods pharmacy http://onlinemedistore.com/products/luvox.htm viagra pharmacy [url=http://onlinemedistore.com/products/diabecon.htm]diabecon[/url]
[url=http://certifiedpharmacy.co.uk/categories/healthy-bones.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
vicoden and online pharmacy http://certifiedpharmacy.co.uk/products/zovirax.htm arabindo pharmacy [url=http://certifiedpharmacy.co.uk/products/xenical.htm]phentermine without a prescription at a us pharmacy[/url]
online pharmacy apo shipping http://certifiedpharmacy.co.uk/products/torsemide.htm walgreens pharmacy hampstead nh [url=http://certifiedpharmacy.co.uk/products/zyvox.htm]zyvox[/url]
biopharmaceutics for pharmacy technicians http://certifiedpharmacy.co.uk/products/accupril.htm tshwane univesity of technology school of pharmacy [url=http://certifiedpharmacy.co.uk/products/rocaltrol.htm]hartzell pharmacy pa[/url]
safeserv pharmacy combo http://certifiedpharmacy.co.uk/products/zocor.htm upjohn pharmacy [url=http://certifiedpharmacy.co.uk/products/septilin.htm]septilin[/url]
[url=http://englandpharmacy.co.uk/products/rhinocort.htm][img]http://onlinemedistore.com/11.jpg[/img][/url]
pharmacy news on chemotherpy iv prep http://englandpharmacy.co.uk/products/lukol.htm pharmacy licinse in british [url=http://englandpharmacy.co.uk/products/bupropion.htm]westwood pharmacy[/url]
canadian pharmacy prescriptions http://englandpharmacy.co.uk/products/entocort.htm what is a pharmacy benefit manager [url=http://englandpharmacy.co.uk/products/nolvadex.htm]nolvadex[/url]
old pharmacy ipana toothpaste http://englandpharmacy.co.uk/testimonials.htm lake erie college of pharmacy [url=http://englandpharmacy.co.uk/products/flagyl-er.htm]thiland pharmacy[/url]
deer park pharmacy cincinnati ohio http://englandpharmacy.co.uk/products/arava.htm walmart pharmacy milwaukee [url=http://englandpharmacy.co.uk/categories/men-s-health.htm]men s health[/url]
[url=http://englandpharmacy.co.uk/products/noroxin.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
lynn lafferty post haste pharmacy http://englandpharmacy.co.uk/products/parlodel.htm pharmacy university in portugal [url=http://englandpharmacy.co.uk/products/prinivil.htm]san diego pharmacy[/url]
total care pharmacy http://englandpharmacy.co.uk/products/kamagra-oral-jelly.htm canadian pharmacy muscle relaxant [url=http://englandpharmacy.co.uk/products/actonel.htm]actonel[/url]
naval hospital jacksonville pharmacy http://englandpharmacy.co.uk/products/tulasi.htm hartmann pharmacy [url=http://englandpharmacy.co.uk/products/zithromax.htm]laynes pharmacy eden nc[/url]
best pharmacy for you http://englandpharmacy.co.uk/products/nolvadex.htm sun city pharmacy [url=http://englandpharmacy.co.uk/products/cleocin-gel.htm]cleocin gel[/url]
[url=http://fdaapproved.co.uk/products/cialis-super-active-plus.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
pharmacy canberra http://fdaapproved.co.uk/products/erectalis.htm chapel hill pharmacy middletown [url=http://fdaapproved.co.uk/products/sublingual-viagra.htm]fort worth texas pharmacy aircast ankle stirrup[/url]
beaverton pharmacy http://fdaapproved.co.uk/products/tegretol.htm investigational pharmacy [url=http://fdaapproved.co.uk/products/femara.htm]femara[/url]
pharmacy on pokemon pearl http://fdaapproved.co.uk/products/prinivil.htm kindersley extra foods pharmacy [url=http://fdaapproved.co.uk/products/apcalis-sx.htm]liggett pharmacy west hartford[/url]
sun pharmacy http://fdaapproved.co.uk/products/zebeta.htm pennsylvania board of pharmacy [url=http://fdaapproved.co.uk/products/minocin.htm]minocin[/url]
israeli dating meet and fuck layla harley davidson dating
beyonce and jay z dating http://freeinternetdating.info/dating/daniel-garson-dating dating service rich professional
dating articles who is gabriel byrne dating problems dating younger boyfriend
Post a Comment