Link to home
Start Free TrialLog in
Avatar of OCSDTech
OCSDTech

asked on

Missing server files error from pre-upgrade checker

I ran the pre-upgrade checker in preparation for our SharePoint 2010 upgrade.  It reports files and features that were installed at one time but are no longer there.  

The farm was moved from 32 bit servers to 64 bit servers and those items were not reinstalled.

One option is to remove the references to the missing items from the content.  Is there a way to query the system or database and figure out which files are referencing those missing files?  

Thanks!
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

you can query the DB via SQL ... but MS does not support this, and says you should never make changes directly to the DB.

sharepoint DB structure is not at all intuitive, so you would likely be hunting & pecking around to trying to find the problem.

i have seen instances where people are able to unreference orphaned items.

safer approach:
http://blogs.technet.com/b/corybu/archive/2007/05/31/sharepoint-orphans-explained.aspx

not so safe approach:
http://blogs.technet.com/b/nishants/archive/2010/04/14/how-to-delete-orphan-configuration-objects-from-sharepoint-farm.aspx

i am not 100% sure missing sites & features are in the orphan category.  but the sites above should help in locating them if they are.
Avatar of OCSDTech
OCSDTech

ASKER

The sql script in http://blogs.technet.com/b/corybu/archive/2007/05/31/sharepoint-orphans-explained.aspx shows how to get information needed to run a stsadm -o deletesite to get rid of Orphaned site collections (in my case I had two orphaned personal MySites) but it doesn't show what content is referencing missing server files (such as web part files, aspx files, etc.
ASKER CERTIFIED SOLUTION
Avatar of OCSDTech
OCSDTech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
FYI: The first two links in my last comment should be switched.
upgrade still has issues