SharePoint Service Pack 2 Pains

I finally bit the bullet and decided to upgrade our SharePoint farm yesterday. I’d been holding off for a while because of time constraints and because of a known issue with Project Server, also part of our farm.

I took careful steps to increment the farm from the SP1+Infrastructure update all the way through each CU up until the service pack. That all worked fine. It was when I tried SP2 I hit problems.

The first issue was that once I’d installed the WSS patch, the Sp2 patch refused to install. Rebooting the server then caused chaos as all my services complained that the SharePoint DB was the wrong version (too old, because I hadn’t run the config wizard yet).

Andy and I spent a long time poking the server yesterday, and spent time building virtual machines to take over the farm as well. We finally knocked it on the head just shy of midnight and left the server in the state it was, trying to start the upgrade installer.

When I got in this morning, the upgrade had installed. I’m guessing that the problems we were seeing were related to services starting and needing time to fail, and we simply hadn’t given them enough time to fail (mind you, the paranoid disk integrity check took a while…)

Much happier, I started the upgrade wizard. Which promptly failed. The logs showed the following:

[WebApplicationSequence] [ERROR] [5/27/2009 7:48:09 AM]: Action 12.0.4.0 of Microsoft.SharePoint.Portal.Upgrade.WebApplicationSequence failed.
[WebApplicationSequence] [ERROR] [5/27/2009 7:48:09 AM]: Feature '20477d83-8bdb-414e-964b-080637f7d99b' is not installed in this farm, and can not be added to this scope.
[WebApplicationSequence] [ERROR] [5/27/2009 7:48:09 AM]:    at Microsoft.SharePoint.SPFeatureCollection.AddInternal(Guid featureId, SPFeaturePropertyCollection properties, Boolean force, Boolean fMarkOnly)
   at Microsoft.SharePoint.SPFeatureCollection.Add(Guid featureId, Boolean force)
   at Microsoft.SharePoint.Portal.Upgrade.ActivatePublisingTimerJobsWebAppFeature.Upgrade()
   at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
[ActivatePublisingTimerJobsWebAppFeature] [12.0.4.0] [DEBUG] [5/27/2009 7:48:09 AM]: Begin Rollback()
[ActivatePublisingTimerJobsWebAppFeature] [12.0.4.0] [DEBUG] [5/27/2009 7:48:09 AM]: End Rollback()
[ActivatePublisingTimerJobsWebAppFeature] [12.0.4.0] [DEBUG] [5/27/2009 7:48:09 AM]: Begin Dispose()
[ActivatePublisingTimerJobsWebAppFeature] [12.0.4.0] [DEBUG] [5/27/2009 7:48:09 AM]: End Dispose()
[ActivatePublisingTimerJobsWebAppFeature] [12.0.4.0] [DEBUG] [5/27/2009 7:48:09 AM]: Elapsed time: 00:00:00.0312496.

A quick dig with our old friend google turned up a couple of similar posts from Jukka on Moss and MySharePointofView so I had a look at the 12 hive and to my surprise found that there was no folder for the PublishingTimerJobs feature. I copied it from one of the new servers, already patched to SP2 and ran the command:

stsadm –o installfeature –name PublishingTimerJobs

That succeeded. I then followed with the old favourite:

psconfig –cmd upgrade –inplace b2b –force

That upgrade has just completed. No project-related errors, just success, so I add my experience to the collective.

Unable to access My Tasks in Project Web Access

Sometime ago we noticed an issue with My Tasks in Project Server. Certain users were unable to access My Tasks at all – they simply got a SharePoint error page.

A little jiggery-pokery with callstack and custom errors later, we saw that the error referenced a GUID for a task. I then searched the Project Server Publishing DB for the task GUID and subsequently located the project to which it belonged. If I edited the project in MS Project and updated the server, removing the task assignment from the user, they could access my tasks.

For anyone who has a similar problem, here are the SQL queries you need:

select * from dbo.MSP_TASKS where TASK_UID='<Task GUID>'

select * from dbo.MSP_PROJECTS where PROJ_UID='<Project GUID>'

Most odd. So I logged a call with our friends in Microsoft Support.

It’s been parked for a while, but I received an email from support today advising me that the Infrastructure updates would help. Funnily enough, I’d already installed them (we keep our SharePoint farm as fully patched as we can), so that was almost all the way there.

Finally, they provided a short SQL script to run against the Publishing DB. This would identify any tasks that were orphaned and correct the issue. Luckily, we had none!

SELECT MP.PROJ_NAME, MAS.PROJ_UID, MAS.TASK_NAME,
MAS.TASK_UID, MR.RES_NAME, MAS.RES_UID,MAS.ASSN_UID
FROM MSP_ASSIGNMENTS_SAVED AS MAS
INNER JOIN MSP_PROJECTS AS MP        
ON MAS.PROJ_UID=MP.PROJ_UID
INNER JOIN MSP_RESOURCES as MR
ON MAS.RES_UID=MR.RES_UID
WHERE TASK_UID NOT IN(SELECT TASK_UID
FROM MSP_TASKS_SAVED)

When I experienced the problem there were no hits in my old friend Google so hopefully this will help somebody, somewhere.

Here are the links to the infrastructure updates for completeness. Remember to read the docs carefully on installing these babies!

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695), 64-bit edition

Infrastructure Update for Microsoft Office Servers (KB951297)

Infrastructure Update for Microsoft Office Servers (KB951297), 64-bit edition

Infrastructure Update for Project 2007 (KB951547) – English

EMEA Project Conference: Keynote Thoughts

Well, the keynote just ended and I needed to check email so I thought I’d do a quick post. A good chunk of the keynote had already been covered by yesterday’s partner-only sessions. However, Mike Angiulo publicly announced that the Office 2007 family Service Pack 1 will be available on December 11th, 2007. I guess that means we can tell the world! I’m surprised, actually, that I haven’t noticed this on any of the SharePoint blogs I frequent.

Anyhoo… We were given a short demo of Project 14. It has some useful new features that should make it easier to build a new project when you don’t have all the details – much more so than Project 2007. Much to Paul’s horror, however, Project 14 has a shiny ribbon bar! I guess that’s going to be a real love/hate thing. Personally, I quite like the ribbon bar, but I can understand why some folk think of it as burying functionality because not all the millions of toolbar icons are visible at once.

Also interesting is that Project Portfolio Server is being merged into Project Server with version 14. As someone who is new to the area of EPM this is a product which I am not familiar with, but merging functionality into a single system would seem to me to have serious benefits, not least in terms of having one less system to manage.

I’m not going to blog every session I attend, but if I see something interesting I will post later. Right now, it’s time for the first ‘real’ session of the day – a sysadmin chalk and talk.

Project Partner Day

Well, it’s the end of day zero, the partner-only day here at the Madrid Project Conference. It’s been an interesting day. I’m not sure what I am allowed to say, but service pack 1 for Office 2007, which covers the desktop products, sharepoint, project server et al is very close to being available now. That was an interesting announcement, as we are looking at installing Project Server in Black Marble. I’d like to wait for SP1 – it makes sense – but because SharePoint will be patched at the same time I need to do some testing of our customisations first.

Meanwhile, outside the conference, we managed to leave the hotel for a few hours this morning before the partner event. The part of Madrid we are in has an incredible amount of building work underway; all all the roads are dual carriageways with big cloverleaf junctions. A fifteen minute taxi ride to the local Shopping Centre would probably have been a ten minute walk, had we realised where the shopping centre was in relation to the hotel. Ah well!

Tomorrow, the conference starts in earnest and I am planning to follow the system administration track, leaving the project management stuff to Paul and Jim. There are some interesting sessions ahead…

EMEA Project Conference – Madrid

Finally, after all the excitement that Richard and Robert had in Seattle and Barcelona, I find myself in the Auditorium Hotel, Madrid for the EMEA Project Conference.

According to the multilingual sales blurb in my room, the hotel is the largest in Europe, and I must say it’s very nice. We flew in yesterday and today is an MS Partner-only day before the conference itself kicks off tomorrow.

Project Server is something we’re very interested in using ourselves, and it’s integration with SharePoint (MOSS/WSS) makes it an attractive solution to anybody who has already deployed MOSS for their corporate intranet, as we have.

Also on the agenda today is VSTS integration with Project Server, which I’m keen to see more on. Closing the loop between developer activity and project planning and monitoring can make a big difference to whether a project comes in on time and budget.

I’m here for the SysAdmin track, whilst Paul and Jim cover the managerial and best practice side of things. I’ll do my best to blog on what I see, although it’s a pretty packed few days, ending in a good sprint from the end of the last session at 3:15 on Wednesday to make it to the airport in time for our 5:25 flight back to Blighty.