Wesley Bakker

Interesting things I encounter doing my job...

Sponsors

News

Wesley Bakker
motion10
Rivium Quadrant 151
2909 LC Capelle aan den IJssel
Region of Rotterdam
The Netherlands
Phone: +31 10 2351035

(feel free to chat with me)
 

Add to Technorati Favorites

November 2010 - Posts

Missing server reference in SharePoint 2010

Unfortunately the "missing server references" health rule in Central Admin Health Monitoring does not display the URL were these uninstalled web parts reside. So to get these pages you'll have to execute some SQL against the mentioned content database. Because this is something that tents to come back regularly on development machines I've created a little SQL script to speed up the process of finding the url's you'll need to delete the web parts.

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.


USE 

DECLARE @className nvarchar = ''
DECLARE @assemblyName nvarchar = ''


SELECT DISTINCT pages.DirName + '/' + pages.LeafName + '?contents=1' as Page
FROM
	dbo.AllWebParts wp
	JOIN dbo.AllDocs pages on pages.SiteId = wp.tp_SiteId
						AND pages.Id = wp.tp_PageUrlID
WHERE
	wp.tp_Assembly like '%' + @assemblyName + '%' AND
	wp.tp_Class	 like '%' + @className + '%'

 

Cheers,

Wes

Amazing world we live in...

Did you ever noticed that there are a lot of articles(265,000 results) out there that talk about linearized / 'Fast Web View' pdf files? These articles talk about the purpose of it, or about software that is capable of creating these kind of PDF files.  As a SharePoint developer, I was really interested in testing this with SharePoint and Bit Rate Throttling so I started looking for a sample file. Some large(around 5mb) linearized pdf sample file.

According to the amount of articles you might think that this should be no problem at all. Well, gues again! Not a single one of the authors of these articles ever bothered to attach an example of a linearized file! None! 0 out of 265.000! (<=I did not check all of them. I gave up after 1.5 hours of searching)

Sigh... what an amazing world we live in. Stupid *&$^#!

Cheers,

Wes

More Posts