Friday, 19 December 2008

Problem upgrading MOSS to the December cumulative updates

I installed the December cumulative update today and the configuration wizard failed with “The B2B upgrader timer job failed.” in the diagnostics log file.

Tried loads of things, including running the configuration routine from the command line using psconfig and also stopping the upgrade job and restarting using stsadm -o setproperty -pn command-line-upgrade-running -pv No (this worked for me in the past when the configuration job failed).

In the end, it was a comment at the bottom of the following page that solved the issue: http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/e3a38087-944b-46aa-b6fa-37482144545b/#page:2

It suggests to remove the WSS Help service from Operations in Central Administration before running the configuration wizard. I decided to ignore the bit about not needing to run psconfig because it tends to log better results during a problem, so ran the following command after stopping the Help service: psconfig -cmd upgrade -inplace b2b -force

I then ran the normal config wizard to make sure and restarted the WSS Help service in Central Admin....

Tuesday, 2 September 2008

Preventing Personalisation Links from appending MySiteView=1

Just add a # symbol to the end of your link:

e.g., https://www.portal.com/# or https://www.portal.com/sites/sitecollection/#

Monday, 16 June 2008

Problem using Created By and Last Modified By drop-down options in Advanced Search

There appears to be a bug in MOSS where the Created By and Last Modified By options do not return any results in the Advanced Search page. It appears that these fields only show results when indexing SPS 2003 content! Please have a look at the link below:

Unraveling the mysteries of SharePoint Search: Created By and Last Modified By - http://www.networkworld.com/community/node/19021

There is a "workaround" to fix the Last Modified By issue at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1937319&SiteID=1, but I have not found anything yet on Created By. Basically, you need to map the 'Office:8' and 'ows_Last_x0020_Modified(text)' crawled property to the 'ModifiedBy' managed property.

More info on the behaviour of the Author search can be found here: http://www.networkworld.com/community/node/17708

It appears that when you do a search on the Author column, it takes the 'Author' document property from the Office application first - and if it's blank (or is not an office document like a PDF or SharePoint list item) - it takes the Created By property in SharePoint.

Friday, 13 June 2008

Setting default option in ISA logon form to Private Computer

Now, obviously I would not recommend this as best practice, but I was asked if I could configure the default security option in the ISA 2006 logon form to Private Computer instead of Public (despite venting reluctance) to make it easier for users to logon and use persistent cookies to gain access to Office applications from SharePoint without being prompted to sign in again.

So, if you also want to implement this, this is how you do it:

1. Create a new set of forms in the C:\Program Files\Microsoft ISA Server\CookieAuthTemplates folder on the ISA server and change your rules to use these forms instead of the default (see http://technet.microsoft.com/en-us/library/bb794733.aspx for details).

2. Edit each of these files in notepad:

usr_pwd.htm
usr_pwd_pcode.htm
pwd_pcode.htm
pwd_pcode_nxt.htm

3. Find and remove checked="checked" from this line: <td><input id="rdoPblc" type="radio" name="trusted" value="0" class="rdo" onclick="clkSec()" checked="checked" /></td>

It should now read: <td><input id="rdoPblc" type="radio" name="trusted" value="0" class="rdo" onclick="clkSec()" /></td>

4. Find and add the checked="checked" option to the following line: <td><input id="rdoPrvt" type="radio" name="trusted" value="4" class="rdo" onclick="clkSec()" /></td>

It should now read: <td><input id="rdoPrvt" type="radio" name="trusted" value="4" class="rdo" onclick="clkSec()" checked="checked" /></td>

5. Perform this for all four files listed in step 2.

6. Restart the Microsoft Firewall service.

Thursday, 15 May 2008

SharePoint Backup Script

This isn't the most advanced backup script you will ever see, but a) it works as a batch file so it is easy to modify and deploy, and b) it backs up more than the OOB tools do on their own, as follows:

- Deletes and recreates the folder structure for the backup target share
- Backs up site collections using stsadm (you will need to add the site collections that you wish to backup)
- Performs a farm backup using stsadm
- Copies the 12 hive across
- Performs an IIS metabase backup and copies the inetpub folder across
- Copies the Global Assembly Cache

For it to work, you will need to create a share on your backup server called "Backup" with the following permissions:

- SharePoint setup/administrator account - Full Control
- SQL Service Account - Full Control
- SharePoint Service/Server Farm Account - Full Control

Run the following command line on the backup server to do this for you:

NET SHARE Backup=D:\Backup /GRANT:DOMAIN\SPAdmin,FULL /GRANT:DOMAIN\SQLSVC,FULL /GRANT:DOMAIN\SPSVC,FULL

And here is the backup script:

@echo off
echo =================================================
echo Backup SharePoint Farm
echo =================================================
c:
CD\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
@echo off

rd \\BACKUPSERVER\Backup\SharePoint /s /q
md \\BACKUPSERVER\Backup\SharePoint
md \\BACKUPSERVER\Backup\SharePoint\12
md \\BACKUPSERVER\Backup\SharePoint\IIS
md \\BACKUPSERVER\Backup\SharePoint\GAC

echo Backing up site collections
stsadm -o backup -url http://portal.domain.com -filename \\BACKUPSERVER\Backup\SharePoint\Portal.dat -overwrite

echo Backing up farm
stsadm.exe -o backup -directory \\BACKUPSERVER\Backup\SharePoint\ -backupmethod full

echo Backing up 12 hive
xcopy "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12" \\BACKUPSERVER\Backup\SharePoint\12 /s /e /c /h /f /r /k

echo Backing up IIS
c:
cd\windows\system32\inetsrv\MetaBack
del metabasebackup.*
cscript c:\windows\system32\iisback.vbs /backup /b MetabaseBackup /overwrite
xcopy metabasebackup.* \\BACKUPSERVER\Backup\SharePoint\IIS /s /e /c /h /f /r /k
xcopy c:\inetpub\*.* \\BACKUPSERVER\Backup\SharePoint\IIS /s /e /c /h /f /r /k

echo Backing up GAC
xcopy c:\windows\assembly\*.* \\BACKUPSERVER\Backup\SharePoint\GAC /s /e /c /h /f /r /k

echo Backup operation finished

Friday, 9 May 2008

Post-SP1 hotfix for UK My Sites released

The hotfix to enable new My Sites to be created with English (United Kingdom) regional settings has been published from KB article 942819 (http://support.microsoft.com/kb/942819).

Install the fix and set the regional settings of the My Site Host site collection (i.e., the root site of your My Site Web Application) to UK. Any new personal site created will inherit these regional settings.

Monday, 7 April 2008

Event ID's 7076, 6398 and 6432

I have seen these errors a few times, where the Application Event log shows ID's 7076, 6398 and 6432 with the message "Attempted to read or write to protected memory". Microsoft has located the problem to be related to IIS and have issued a fix at http://support.microsoft.com/?id=946517. It can be installed regardless of MOSS/WSS service pack installed. Also see the following article for further details - http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=47

Update (courtesy of my colleague Virinder Aulakh): You get an unspecified SMTP error when you try changing SMTP settings in IIS after applying the hotfix (KB946517) to resolve Event ID 6398 errors. The problem is described in detail here http://blogs.msdn.com/vijaysk/archive/2008/04/14/issue-smtp-configuration-unspecified-error.aspx and the subsequent Microsoft Knowledgebase article is here http://support.microsoft.com/default.aspx/KB/950426.