Error
I ran the CU on my Development Environment and had some errors in my Logs! Central Admin was working fine, but my Web Application wasn't.
Action 12.1.5.0 of Microsoft.SharePoint.Upgrade.SPSearchDatabaseSequence failed.
And my web application in IE showed this error:
Server error: http://go.microsoft.com/fwlink?LinkID=96177
I found this on TeEchNet with "This is a bug in Microsoft Office SharePoint Server 2007". But no explanation whether SP1, Infrastructure Updates or Cumulative Updates fix it! Anyway, I realised I had SP1 on my machine and am now installing the new December Cumulative Update to see whether that fixes it ;-)
Rat holes
I went down lots of rat holes:
http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/3fec7688-c657-42bf-b68d-bca3df9e508e/
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/e3a38087-944b-46aa-b6fa-37482144545b/
http://technet.microsoft.com/en-us/library/cc288269.aspx
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sharepoint.general&tid=a13d562e-0c30-4120-aeee-9d88c6f81a3d&p=1
http://support.microsoft.com/kb/944267
Resolution
Basically, I went into Central Administration and stopped the Windows SharePoint Services Help Search and then started it again and created a new database. Then when I ran:
stsadm -cmd upgrade -inplace b2b -wait -force
and then
ststadm -o upgrade -inplace -url http://localhost:81
for my web application.
I then had to do an iisreset and hit the web application url and got a 404 error. In the logs I got:
Could not get Upgrade Area Url Mapping list. Aborting attempt to redirect 404 url.System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002) at Microsoft.SharePoint.Library.SPRequestInternalClass.GetMetadataForUrl(String bstrUrl, Int32 METADATAFLAGS, Guid& pgListId, Int32& plItemId, Int32& plType, Object& pvarFileOrFolder) at Microsoft.SharePoint.Library.SPRequest.GetMetadataForUrl(String bstrUrl, Int32 METADATAFLAGS, Guid& pgListId, Int32& plItemId, Int32& plType, Object& pvarFileOrFolder) at Microsoft.SharePoint.SPWeb.GetMetadataForUrl(String relUrl, Int32 mondoProcHint, Guid& listId, Int32& itemId, Int32& typeOfObject, Object& fileOrFolder) at Microsoft.SharePoint.SPWeb.GetList(String strUrl) at Microsoft.SharePo...
Although if I went to a sub site collection it worked fine!!?!?!