Microsoft SharePoint 2007 - Fixing a failed WSS v3 and/or MOSS 2007 SP1/Infrastructure Patch Upgrade

The Upgrade Process
I was upgrading an environment (MOSS version 12.0.0.4815) in the following manner:

1. Check all Timer jobs have run to completion in the existing environment
2. Check no errors with WSP
3. Install WSS v3 SP1 Patch (Skip Configuration wizard)
4. Install MOSS 2007 SP1 Patch (Skip Configuration wizard)
5. Install WSS v3 infrastructure Patch (Skip Configuration wizard)
6. Install MOSS 2007 infrastructure Patch
7. Following the prompts for the Configuration Wizard (PSconfigUI).

Okay, so far so good.

The Problems
In the middle of the configuration wizard, it seemed to have stayed on Step 5 for hours. Looking at the Event Viewer, errors with messages:

“Content index on Search could not be initialized. Error The content index is corrupt. 0xc0041800.Component: bd72df39-396a-472f-8a1a-db6c3241e922”



Checking Upgrade.log (in 12\Logs\), unveiled some Exception errors.

The Solution
So then I cancelled out of the setup (which took a while to cancel – actually it didn’t cancel until I ran the following command), and ran the following command to force the upgrade of the SharePoint environment:

psconfig -cmd upgrade -force



Checked the version numbers and the existing sites I had - That seemed to have fixed my issues


Alternative
Alternatively, the stsadm utility can be used (though I didn't have to use it):

stsadm -o upgrade -forceupgrade

For more details on this command:
Upgrade: Stsadm operation (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc288073.aspx

Upgrade: Stsadm operation (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc263413.aspx



References
Command-line reference for the SharePoint Products and Technologies Configuration Wizard (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc263093.aspx

Install Windows SharePoint Services 3.0 by using the command line
http://technet.microsoft.com/en-us/library/cc752946.aspx

Microsoft SharePoint 2007 - SharePoint Designer Workflows does not automatically start

Today, I created a SharePoint Workflow with SharePoint Design 2007, selected the options for it to be started upon the creation of a new item and upon the modification of a new item. It didn't start!

However, if I enable the option to start the workflow manually, and do so, the workflow starts!

A google search lead me to an answer:

This behavior occurs because a security fix in Windows SharePoint Services 3.0 SP1 prevents declarative workflows from starting automatically under the system account. After you install Windows SharePoint Services 3.0 SP1, declarative workflows do not start automatically if the following conditions are true:

• The Windows SharePoint Services Web application runs under a user's domain account.
• The user logs in by using this domain account.
• The site displays the user name as System Account.

Source: http://support.microsoft.com/kb/947284