Musings of a PC

Thoughts about Windows, TV and technology in general

SharePoint Portal Server: troubleshooting the gatherer

Great though the search and indexing feature is in SPPS, it can be a pain to troubleshoot, particularly since the error log refers to sts2 URLs with cryptic strings that don’t work if you click on the URL.

As a result of trying to troubleshoot a problem with MS PSS, I thought I’d share one of the tips they gave me. If you’ve got a URL like this:

Sts2://spps/sites/fooble/webid=009/listid={3919FF0B-1028-483F-895E-E6020EB9FF7A}/itemid=472

you can use the listid GUID to help you locate the document library that is giving you the grief. To do this, open Query Analyzer and set it to look at the SITE database for your portal. Then, run this query:

Select dirname, leafname from docs where listid = ‘<LIST GUID>’ and DoclibRowID = ‘<DOC ID>’

where the LIST GUID is the listid string (less the curly brackets) and DOC ID is the item id number.

If you don’t get any results returned, it is likely that you’ve configured Portal Server to use multiple content databases. If this is the case, you need to select each of those databases in turn and re-run the query.

The results back from the query will be the document library and the actual document that is causing the problem.

Maybe the next release of SharePoint Portal Server will make all of these low-level tricks unnecessary …

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: