Solved

SharePoint 2007 to 2010 Upgrade - Orphaned Site Collection

Posted on 2012-04-02
5
408 Views
Last Modified: 2012-06-27
The pre-upgrade check discovered one orphaned site collection that I cannot resolve…

/personal/site_name (Data Source=PR-DB-004;Initial Catalog=MySite_Content;Integrated Security=True;Enlist=False;Connect Timeout=45)

We have successfully deleted the SiteID using the stsadm -o deletesite method making the enumallwebs report clean without any InSiteMap="False” records.  The pre-upgrade check still has the orphaned site collection so we executed the databaserepair command but the results are zero orphaned records.  The only discrepancy that I can find is the pre-upgrade check message references one content database “MySite_Content” and central admin site collection list references another content “MySiteContent”.

Any ideas?

Thanks in advance.
0
Comment
Question by:libertytax
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37797388
You could look at the objects table in the config database, and remove it from there.  This isn't supported by Microsoft though.
0
 
LVL 1

Author Comment

by:libertytax
ID: 37798026
I queried the object table in the Config database and the only reference to the site was a valid reference.  Used the below query…

SELECT [Id]
      ,[ClassId]
      ,[ParentId]
      ,[Name]
      ,[Status]
      ,[Version]
      ,[Properties]
  FROM [SharePointSites_Config].[dbo].[Objects] (NOLOCK)
  WHERE [Name] LIKE '%/personal/<site_name>%'
      OR [Properties] LIKE '%/personal/<site_name>%'

I still do not understand why the site collection list would display a different content database then the pre-check upgrade message.   Both the content databases are valid and tied to the web application.

Any other thoughts?

Thanks again.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37798876
I would look for an object in the config db with the name of the bogus content db.

Either way, this won't stop your upgrade.
0
 
LVL 1

Accepted Solution

by:
libertytax earned 0 total points
ID: 37807453
We resolved the issue by emptying the recycle bin on all the web applications and rerunning the pre-upgrade checker.
0
 
LVL 1

Author Closing Comment

by:libertytax
ID: 37822738
Average
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question