- Missing Webpart
Use sql command for found it :
SELECT * FROM [WebParts] where tp_WebPartTypeId = '25603dac-dee4-e4b0-5518-e9ac034dba57' -- search for the invalid webpart id & use the tp_SiteID & tp_PageUrlId values below
SELECT * FROM [Sites] where Id = '58B834C9-5682-4FA5-92EB-4D1F6CEB4CDC' -- tp_SiteID
SELECT * FROM [AllDocs] where Id = '0C22E0E5-CF32-4096-9869-26657162A23F' -- tp_PageUrlId
And use this for delete :
First, I chose Add a Web Part

Then I chose "Advanced Web Part Gallery and Options"

Then I chose to list all "Closed Web Parts" and added them all to my dashboard

I then simply edited the web part and "deleted" them, instead of closing them (click on the X)

- Missing Feature
Use Sql command for found it :
select * from AllDocs with (nolock)
where SetupPath like 'Features\ReportServer%'
And delete it with Wss command :
http://wikipinfo.blogspot.com/2011/03/delete-feature-sharepoint-2007-2010.html
- Invalid DataBaseSchema
For me, it's a table added by customer since many years ago...and visual filter. delet all for win !^^
or try it : To resolve the issue and return the database schema back to the original state I user SSMS and opened up the System Tables section of my content database and deleted the sysdiagrams table. I went back and ran the PreUpgradeCheck and this time I got a clean report.
Aucun commentaire:
Enregistrer un commentaire