With the recently released Project 2007 and Project Server 2007 Service Pack 2 (SP2) along with the Project 2007 and Project Server 2007 April Cumulative update hopefully we have seen the last of the false “check-in pending” issues. It is obviously still possible that the project may really be not checked in – but the false message should be a thing of the past. And I am absolutely positive that we you will tell me if I am wrong! And there could still be a scenario we haven’t heard about that we need to fix – so do let us know.
As with all cache related problems you may still see an issue if your cache is already “bad”, so best to make sure all your projects are really checked in on the server, and delete your cache (from the OS, not just the menu item in Pro) to ensure all is good when you load these new updates.
*** Update *** See http://blogs.msdn.com/brismith/archive/2009/06/18/project-server-2007-tracking-method-updates-since-sp2.aspx for details of settings changes to see previous behaviour, and http://blogs.msdn.com/brismith/archive/2009/07/16/project-server-2007-office-system-june-2009-cumulative-update-is-now-available.aspx for the CU details that reverted to the previous behavior for Activity Plans and Proposals.
Sometimes we fix bugs and then find that customers had been relying on the “broken” behavior. I have covered this topic in some comment postings to the Service Pack 2 article but thought it worth a full posting to help customers understand why they are seeing different behavior.
In the Infrastructure Update we introduced a timephased grid for task time tracking. Most customers thought this was a great thing – but it did introduce issues in that Project Managers who had specified a project tracking method of % Complete and remaining work could no longer enforce this method – the timephased grid was a back door to “hours per period” statusing. So we fixed this in SP2 so that Project Managers could once again control how task time was entered.
How does this affect Activity Plans and Proposals? These server-side, or Light Weight Projects, as they are sometimes called, have certain limitations; only 100 tasks, only one assignment per task and also only one method of task statusing – which is % Complete and remaining work! This cannot be changed or over-ridden. In fixing this issue for “real” projects the fix also applied to all projects with this tracking method – and included Activity Plans and Proposals.
Now we are finding that between the IU and SP2 many customers were enjoying the ability to enter timephased data against these server-side projects. As always, I’d love to hear your comments.
Thanks to Laksh for his suggestion to make a full posting, and Ville for raising my awareness via comments to my blog.
*** 2nd Update *** The Office Server download is now live KB968851 - just the article to come...
*** Update *** The top three updates are now live. The Office Servers still is not live, but you can get the MOSS update - KB 968859 - so the document is at http://support.microsoft.com/kb/968859 and the download at http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968859. The WSS KB I refer to is the global one - Christophe references the non-global KB 968857 - in case you wonder why you see differences.
The April Cumulative Updates (CUs) for Project and Project Server are now available, but there has been a slight delay with the overall Office Server one – which will include all the Office Server components including Project Server. So if you just have Project Server and no MOSS you can go ahead and download and install now. If you have MOSS you may prefer to wait a few days and do all your Office Server updates in one go.
Also the KB articles for Project Server, Office Server and WSS are not yet live. So the table has hyperlinks that work – and text URLs where they are not yet active, but will be coming shortly. I will update when I see they are live.
So here are the links:
**** Update (Thanks for the reminder to update this one Seth) This issue is resolved by the August CU for Project Server 2007 the details of which can be found at http://blogs.msdn.com/chrisfie/archive/2009/08/27/announcing-the-release-of-the-microsoft-project-and-project-server-2007-august-cumulative-update.aspx. and the direct link is http://support.microsoft.com/kb/973937.
Details of the specific issue and fix:
You install the update that is described in Microsoft Knowledge Base (KB) article 968271. When you create a site in Project Server 2007 that has the Multilingual User Interface Pack (MUI) installed, a second timer job is created in the native language and the site provisioning fails. ****
The full error is Cannot insert duplicate key row in object 'dbo.Objects' with unique index 'IX_Objects_ClassId_ParentId_Name', and this occurs when trying to provision a new PWA site in a farm. Some background first, and then the workaround. In the February CU we added a fix for the “waiting for resources” problems customers had run into when trying to provision new PWA sites. This was caused by a missing timer job. The fix checked for the timer job, and if it wasn’t found it was created – which for most of our customers was a perfect fix. However, for customers running multiple language versions (MUIs), or even just non US English versions it could fail to detect the timer job and think it was missing and try to re-create it – which led to the error!
My colleague Aik had been working on this problem and had a couple of workarounds we’d shared with customers and these turned up back in my blog comments a couple of days ago (Thanks Jose!) – so I thought the time was right for a full posting. So here are the workarounds – with option #1 being the favored one as it has the least impact on the users of the server:
Option #1 – Delete sync jobs before provisioning site
Option#2 – Change the regional settings
Any issues, or if you need some help working through these steps then please contact support. My blog reader Jose says we are may be fixing this in the June CU – though I couldn’t possibly comment…
For those who couldn’t make the webcast last month Christophe has now posted details of the recording and other SP2 resources. Christophe and Adrian presented and answered questions covering Project 2007 Service Pack 2 (SP2) as well as the Project 2007 April Cumulative Updates – and future planning guidelines for Project Server 2010.