Service Pack 1

OverviewEPM 2007

Adrian Jenkins| MicrosoftSupportability Program Manager

Christophe Fiessinger| MicrosoftTechnical Product Manager

AgendaOverview & Service Pack 1 (SP1) contentDownload locationsDeployment guidelinesPost SP1 hot fix rollupQuestions and Answers

What SP1 isHot fixes and DCRsCustomer reported problemsCrashing problems reportedMicrosoft internally reported issuesPostponed issues found near the original 2007 ship dateSecurity fixes

What SP1 is notA service pack based heavily on support call dataThe size and depth that would normally be expected for a first service packFor more information:KB Article Title

936984 Description of the 2007 Office System servers Service Pack 1

936988 Description of the Microsoft Windows SharePoint Services 3.0 Service Pack 1

937154 Description of the Microsoft Office Project 2007 Service Pack 1

937961 Description of the Office 2003 Web Components Service Pack 1 for the 2007 Microsoft Office System

940850 Description of Microsoft Office Language Interface Pack 2007 Service Pack 1

List of SP1 FixesThemes:

Lookup Table & Custom FieldsActive CacheQueueTimesheet & StatusingPerformanceStability

KB Article Description942386 Issues fixed in Project 2007 by 2007 Office suite Service Pack 1

942387 Issues fixed in Project Server 2007 by Office 2007 Servers Service Pack 1

942388 Issues fixed in Windows SharePoint Services 3.0 by Windows SharePoint Services 3.0 Service Pack 1

942390 Issues fixed in Office SharePoint Server 2007 by 2007 Office System servers Service Pack 1

942722 Issues Fixed in Microsoft Project Portfolio 2007 Service Pack 1

Where to download SP1?http://www.microsoft.com/downloadsOfficeOffice Language PacksOffice Web ComponentsProjectProject Language PackServers (MOSS, Project, Forms, Groove)Server Language Packs, x86Server Language Packs, x64Windows SharePoint ServicesWindows SharePoint Services Language PackWindows SharePoint Services Language Pack, x64 Windows SharePoint Services with SP1 (slipstream)Windows SharePoint Services with SP1, x64 (slipstream)

Deployement GuidelinesDeploy software updates for Office Project Server 2007Deploy software updates for Windows SharePoint Services 3.0Planning and Deploying Service Pack 1 for Microsoft Office SharePoint Server 2007 in a Multi-server Environment

Deploy in pre-production/test platform first, and validate specific fixes you were expecting in SP1. Validate your typical usage scenarios prior to any deployment into production.

Post SP1 Hot fix Rollup Patch - 1What is it?

Hot fixes made after the SP1 code base was locked down and up until SP1 is released

Typically released 4 to 8 weeks after a SP

Leverage your Microsoft representative to get it

Should I wait for its release prior to deploying SP1?

Depends if it contains specific fixes that are specific to your deployment.

Post SP1 Hot fix Rollup Patch - 2 Project Client:

KB Article Description941657 Error 458 appears when using the ProjectBeforeTaskChange or

ProjectBeforeTaskChange2 VBA event941657 Project crashes intermittently while connecting to Project Server

and products such as Black Ice Firewall are installed941657 Booking type of resources within a project get changed during

the migration process941657 Assignment booking type does not make it into the

ASSN_BOOKING_TYPE column in dbo.MSP_ASSIGNMENTS table941657 Project may keep crashing when a user tries to save a project

back to Project Server924679 Script error appears when closing a project while the Save

Baseline or List project guide is open941657 Users are able to save baselines on imported plans despite

being denied in security settings941657 Project may crash when grouping a resource view by RBS level

Post SP1 Hot fix Rollup Patch - 3 Project Server:

KB Article Description941426 Adding more work to a task that has progress and is tracked on a % Complete

basis incorrectly adds work to the task941426 A crash may occur when updating tasks on multiple summary tasks via PSI941426 OLAP cube dimensions do not work properly for the MSP_Project_Timesheet cube941426 Build Team: Default Assignment owner is not changed after resources substitution

in PWA941426/941657 Status manager field not updated when saved from a template

941426 UpdateUserSyncSetting tool not working properly941426 Need ability to clear rejected task assignment via PSI941426 Self assign with actuals appears as one request in approvals.941426 'Start Date' for tasks shows as NA in Applied Requests and Errors941426 Updating custom field via PSI may cause ProjectSchedulingEngineException error941426 Error when users are set to a high a RBS level941426 IE has encountered a problem with an add-on and needs to close - PJGRID12.ocx941426 Synching to WSS Root site can take a long time depending on the number of users

being synchronized. An option now exists to disable sync941426 Self assign to an existing task with an assignment incorrectly shows an update is

needed to the resource the was originally assigned to the task941426 Project Owners dropdown in Edit Project Properties does not take RBS into Account941426 Updating tasks in PWA may cause failure to load projects in Project Professional941426 Need the ability to remove themselves from a task with actual work is already

applied941426 Outline codes are not indented in Grouping views

Questions & Answers - 1Will SP1 break existing customization?

It depends! If you’ve changed standard PWA pages, database schema and stuff like that, then you could run into problems. Otherwise, things should be OK.

Have there been any changes or fixes to PSI methods?

No changes to the methods. There haven’t been any major fixes.

Q & A - 2Have there been changes to PSMigrate?

Not really. It has been recompiled to match Winproj.exe. There is a post SP1 rollup fix that does fix an issue with resource booking types.

Can I migrate from PS 2003 to PS 2007 + SP1?

Yes, you can apply SP1 on your target environment. PS 2003 SP3 is NOT a pre-requisite nor is it necessary.

Does SP1 contain any additional tools? No. There are no tools, for example, to check whether or not MPP files have become corrupted and so forth.

Q & A - 3Are there any fixes that are specific to localized languages?

No. When we were looking at the fixes to put into SP1, we were unaware of issues that were specific to a localized build.

When will the SP1 language packs, 64-bit and 32-bit versions be shipped?

All at the same time.

Q & A - 4Are there any dependencies between the SP1 client and server versions?

No. We test with RTM clients against SP1 servers and vise versa. However, with all of the fixes that are in SP1, it is a great idea to have both the server and client upgraded to SP1. There are also no dependencies between Office desktop applications. For example, you can install Project 2007 SP1 and still have Office 2007 at the RTM level. You will need to install WSS 3.0 SP1 before installing Project Server SP1, however.

Q & A - 5Are there any database schema changes?

A few minor changes. There are a lot of stored procedures and index changes to improve performance.

Have any fixes been made that will help master and sub projects work better together – especially those that have been imported?

Yes, there was a hot fix done for this and it is included in SP1.

Q & A - 6Where can I get Project Portfolio Server SP1?

PPS SP1 should be released next week

Does SP1 contain updates to PWA’s ActiveX controls?

Yes, they will have to be redeployed on the desktops. Please note that the hot fix rollup package will contain updates as well.

How do we verify the version number of the client and the server?

In Project go to Help/About MS Office Project (6215)On the server go to Central Admin/Operations/Servers in Farm (6219)

Q & A - 7Is the CodePlex Timesheet Tied-Mode solution starter included in SP1?

No, here’s a link: Timesheet Tied-Mode v1.0

What’s the plan for SP2?No target date so far, driven based on feedback. If you have issues continue to work with Microsoft Support to get a hot fix.

What about compatibility with the next version of Windows Server 2008 and the next version of SQL Server 2008?

Issues are being addressed with beta versions of these products.

18© 2007 Microsoft Corporation. All rights reserved.

This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.