Article ID: 830240
Article Last Modified on 2/13/2006
APPLIES TO
- Microsoft Project Server 2002
SUMMARY
Microsoft has released an update to Microsoft Project Server 2002. This update enhances security and improves stability and performance.
INTRODUCTION
This article describes how to download and install Microsoft Project Server 2002 Service Pack 1 (SP1). Additionally, this article describes the issues that are fixed by Microsoft Project Server 2002 SP1.
MORE INFORMATION
Important Before you install this update, make sure that you meet the following requirements:
- You have Microsoft Project Server 2002 installed.
- You have Microsoft Windows Installer 2.0 or later installed.
For additional information about the Windows Installer requirement, see the "Windows Installer update requirements" section.
How to download and install the update
To update your installation of Microsoft Project Server 2002 to Microsoft Project Server 2002 SP1, follow these steps:
Note We strongly recommend that you back up your project plan database before you continue to install this update. You cannot roll back or remove this update. Backups of the database should be done before you run the Microsoft Project Server Service Pack 1 SQL update. Additionally, we strongly recommend that you back up your Microsoft SharePoint database if applicable.
- In Windows Explorer, create a folder on drive C, and then name the folder kb830240.
- Install the Microsoft Project Server Service Pack 1 SQL update to upgrade your project plan database. To do this, follow these steps.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:323330 How to Back Up, Schedule, and Restore a Microsoft Project Server Database
- The following file is available for download from the Microsoft Download Center:
![[GRAPHIC: Download]](/wiki/images/f/f3/Download.gif)
Download the English version of the Project Server Service Pack 1 SQL update package now.
Release Date: March 23, 2004
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
Note To obtain a localized version of the Project Server Service Pack 1 SQL update, visit the following Microsoft Web site: - Click Save to save the Microsoft Project Server 2002 Service Pack 1 SQL installation file (for example, Projectserver2002-kb830240-sqlfile-fullfile-enu.exe) to the C:\kb830240 folder.
- In Windows Explorer, double-click the Project Server 2002 Service Pack 1 SQL update file that you downloaded in steps 2c and 2d, and then extract the files to the C:\kb830240 folder.
- To install the update, the Osql.exe file is required on the computer where the CMD file in the next step is run. If you run the Upgdb101.cmd file directly on the computer where your project plan database resides, the Osql.exe file should already be present.
Note The Osql.exe file is also available on the Project Server 2002 CD-ROM in the \support\database folder. - Click Start, and then click Run.
- In the Open box, type cmd, and then click OK.
- Run the Upgdb101.cmd file with the following parameters at the command prompt. To do this, type the following (without typing the greater-than (<) or less-than (>) signs), and then press ENTER:
Upgdb101.cmd <
sql server name> <database name> <system administrator account login> <system administrator account password>Or, if you use Windows authentication SQL Server as the currently logged in user, type the following, and then press ENTER:
Note By leaving off the system administrator account login and password, the command file will assume Windows authentication to SQL Server. If you supply only the SQL Server name, the command file will assume that the database name is ProjectServer.Upgdb101.cmd <
sql server name> <database name> - At the command prompt, type exit, and then press ENTER.
- The following file is available for download from the Microsoft Download Center:
- Install Project Server 2002 SP1. To do this, follow these steps:
- The following file is available for download from the Microsoft Download Center:
Download the English version of Project Server 2002 Service Pack 1 package now.
Release Date: March 23, 2004
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
Note To obtain a localized version of Project Server 2002 SP1, visit the following Microsoft Web site: - Click Save to save the Project Server 2002 SP1 installation file (for example, Projectserver2002-kb830240-fullfile-enu.exe) to the C:\kb830240 folder.
- In Windows Explorer, double-click the Project Server 2002 SP1 installation file that you downloaded in steps 3c and 3d to start the Setup program.
- Click Yes to accept the license agreement.
- If you are prompted to insert your original Project Server 2002 CD, insert it, and then click OK.
- Follow the steps that appear on your screen to install the update.
- The following file is available for download from the Microsoft Download Center:
- If you use SharePoint Team Services from Microsoft, install Microsoft Office XP Service Pack 3 (SP3) for SharePoint Team Services.
Note Office XP SP3 is not currently compatible with SharePoint Team Services when you install Office XP SP3 on a computer that is running Microsoft Windows Server 2003. If you want to run SharePoint Team Services on a computer that is running Windows Server 2003, do not install Office XP SP3 now.
For additional information about how to obtain and install Office XP Service Pack 3 for SharePoint Team Services, click the following article number to view the article in the Microsoft Knowledge Base:833845 Overview of Office XP Service Pack 3 for SharePoint Team Services
After you install Office XP Service Pack 3 for SharePoint Team Services, you must update your custom template files. To do this, follow these steps:
- Run the Stswiz.exe file.
The Stswiz.exe file is part of your original Project Server 2002 installation, and can be found in the \Support folder on your Project Server 2002 CD-ROM. This will reinstall the custom template files. - Click Provision additional SharePoint Web sites for Project Server
- In the list of available web sites, click the Web site where SharePoint is installed.
- Click Next
- When STSWIZ complete, click Finish
- The following file is available for download from the Microsoft Download Center:
Download the English version of Project Server 2002 SharePoint Team Services update package now.
Release Date: March 23, 2004
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
Note To obtain a localized version of Project Server 2002 SharePoint Team Services update, visit the following Microsoft Web site: - Click Save to save the Microsoft Project Server 2002 SharePoint Team Services update installation file (for example, Projectserver2002-kb830240-stsfile-fullfile-enu.exe) to the C:\kb830240 folder.
- In Windows Explorer, double-click the Project Server 2002 SharePoint Team Services update file that you downloaded in steps 4b through 4d, and then extract the files to the C:\kb830240 folder.
- In the C:\kb830240 folder, double-click Setup.exe to update the template files.
- Copy the Upgwebs.cmd file and the Stswizup.vbs file to the inetpub\wwwroot folder.
- New subwebs will automatically contain the updated templates. To update your existing subwebs, run the Upgwebs.cmd file from a command line.
Note To upgrade all Microsoft Project subwebs, each subweb has to be specified with the /w switch in the command line. - Click Start, and then click Run.
- In the Open box, type cmd, and then click OK.
- At the command prompt, type Upgwebs.cmd with the appropriate options, and then press ENTER.
Options /? Use this option to display usage options. /s Use this option to supply a SharePoint Team Services Web site name. /w Use this option to supply the existing subweb that is to be updated. This option can be used multiple times for multiple subwebs. Example:
Upgwebs.cmd /s
sts web site/w ms_projectserver_publicdocuments /w 106 /w 109
Note The
sts web siteis a placeholder for something like "default web site."
- Run the Stswiz.exe file.
- If you installed SQL Server Desktop Engine (also known as MSDE 2000) when you installed Project Server 2002, your computer that is running MSDE 2000 may be vulnerable to the Slammer worm.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:814046 PSVR2002: Project Server users with MSDE 2000 installed may be vulnerable to Slammer worm
![[GRAPHIC: Download]](/wiki/index.php?title=File:Download.gif){kind=small}
Additional information when you install Project Server 2002 SP1
Restart requirement
You do not have to restart your computer after you install this update.
Other requirements
When you first locate Project Web Access after you install this update, you may be prompted to reinstall the ActiveX controls.
Microsoft Project Server 2002 Service Pack 1 (SP1) for Multilingual User Interface Pack
For complete Project 2002 SP1 functionality, also install the Project Server 2002 Service Pack 1 (SP1) for Multilingual User Interface Pack if you use the Multilingual User Interface Pack (MUI). To do so, visit the following Microsoft Web site:
How to determine whether the update is installed
The update contains updated versions of the following files:
Date Time Version Size File name -------------------------------------------------------------- 3/5/2004 1:01 AM 53,573 Addmod.asp 3/5/2004 1:52 AM 10.0.2104.130530 6,000 Atlconv.dll 3/5/2004 1:01 AM 8,470 Authlib.asp 3/5/2004 12:20 AM 611 Build.inc 9/5/2002 11:19 AM 6,133 Clntutil.asp 3/5/2004 1:02 AM 2,334 Comminct.asp 3/24/2003 11:58 AM 1,550 Comlib.asp 3/5/2004 1:01 AM 4,815 Creasubw.asp 3/5/2004 1:02 AM 6,227 Datspval.js 3/5/2004 1:02 AM 34,933 Dbname.inc 3/5/2004 1:01 AM 13,778 Defsts.asp 3/5/2004 1:01 AM 13,659 Defvwdsn.asp 3/5/2004 1:01 AM 3,742 Delsubwb.asp 3/5/2004 1:01 AM 13,658 Dldrilld.asp 3/5/2004 1:01 AM 13,571 Dlmain.asp 3/5/2004 1:01 AM 829 Dlredir.asp 3/5/2004 1:02 AM 51,787 Entstrep.asp 3/5/2004 1:01 AM 7,898 Ent_mode.asp 3/5/2004 1:02 AM 2,714 Execasp.js 3/5/2004 1:02 AM 2,616 Getses.asp 3/5/2004 1:02 AM 8,635 Grid.asp 3/5/2004 1:02 AM 3,901 Grid.js 3/5/2004 12:14 AM 1,783,404 Insdef.sql 3/5/2004 12:14 AM 368,496 Insdeflp.sql 3/5/2004 1:02 AM 508 Isexecpg.asp 3/5/2004 1:02 AM 6,943 Issshell.asp 3/5/2004 1:01 AM 16,669 Linkdocs.asp 3/5/2004 1:02 AM 16,834 Linkissu.asp 3/5/2004 1:02 AM 6,777 Locstr.asp 3/5/2004 1:01 AM 24,984 Mansts.asp 3/5/2004 1:06 AM 10.0.2104.1305 158,448 Mkretail.dll 3/5/2004 1:02 AM 27,040 Modanaly.asp 3/5/2004 1:02 AM 9,808 Modcomp.asp 3/5/2004 1:02 AM 26,506 Moddtl1.asp 3/5/2004 1:02 AM 12,289 Moddtl2.asp 3/5/2004 1:02 AM 12,538 Moddtl3.asp 3/5/2004 1:02 AM 5,921 Modeldtl.inc 3/5/2004 1:02 AM 47,784 Modeler.asp 3/5/2004 1:02 AM 13,956 Models.asp 3/5/2004 1:02 AM 43,322 Modmulti.asp 3/5/2004 1:02 AM 20,577 Modtool.asp 3/5/2004 1:02 AM 17,891 Mrgstrep.asp 3/5/2004 1:06 AM 10.0.2104.305 920,304 Mspjwms.dll 2/18/2003 4:08 PM 10.2003.0.218 126,976 Mspnav.dll 7/23/2003 3:23 PM 10.0.2003.723 340,480 Mswarp.dll 9/5/2002 11:19 AM 3,975 New4task.asp 3/5/2004 1:02 AM 12,511 Newres.asp 3/5/2004 1:02 AM 5,460 Notedlg.asp 3/5/2004 1:01 AM 12,667 Notify.asp 3/5/2004 1:02 AM 3,810 Notvwdlg.asp 3/5/2004 1:02 AM 1,626 Objconst.asp 1/21/2004 10:05 PM 8,478,160 Owc10.exe_0001 7/16/2003 1:03 PM 10.2003.0.716 61,440 Pcsviews.dll 3/5/2004 1:06 AM 10.0.2104.305 658,160 Pds.dll 3/5/2004 1:02 AM 12,749 Pdsxml.asp 3/5/2004 1:52 AM 10.0.2104.1305 899,920 Pj10od10.dll 3/5/2004 1:06 AM 10.0.2104.1305 265,456 Pj10tm10.dll 3/5/2004 1:06 AM 10.0.2104.1305 298,224 Pjbusobj.dll 3/5/2004 1:11 AM 51,849 Pjcintl.cab 3/5/2004 1:13 AM 1,336,851 Pjclient.cab 3/5/2004 1:06 AM 10.0.2104.1305 109,808 Pjdbcomm.dll 3/5/2004 1:02 AM 20,670 Pjdetvw.asp 3/5/2004 1:10 AM 10.0.2104.1305 3,283,696 Pjintl.dll 3/5/2004 1:10 AM 10.0.2104.1305 596,720 Pjintlw.dll 3/5/2004 1:06 AM 10.0.2104.1305 326,384 Pjmsghlr.dll 6/9/2003 4:02 PM 10.0.2003.609 188,928 Pjnpe.dll 3/5/2004 1:06 AM 10.0.2104.1305 178,928 Pjobjprv.dll 3/5/2004 1:06 AM 10.0.2104.1305 4,127,984 Pjoledb.dll 3/5/2004 1:06 AM 10.0.2104.1305 261,360 Pjquery.dll 3/5/2004 1:06 AM 10.0.2104.1305 249,072 Pjresm.dll 3/5/2004 1:02 AM 2,157 Pjsess.asp 2/9/2003 12:44 PM 113,819 PJSVR10.CHM 3/5/2004 1:06 AM 10.0.2104.1305 240,880 Pjsvrsec.dll 3/5/2004 1:06 AM 10.0.2104.1305 904,432 Pjsvrutl.dll 3/5/2004 1:06 AM 10.0.2104.1305 170,736 Pjvwmgr.dll 3/5/2004 1:02 AM 50,738 Pjxmlfun.js 3/5/2004 1:02 AM 30,584 Pjxmlgrd.asp 3/5/2004 1:02 AM 27,328 Portview.asp 3/5/2004 1:02 AM 8,646 Prjmenu.asp 3/5/2004 1:52 AM 10.0.2104.1305 1,715,024 Prjres.dll 10/23/2003 9:34 AM 157,184 Prjsvre.mst 3/5/2004 1:06 AM 10.0.2104.305 326,384 Projolap.dll 10/31/2003 1:37 PM 100,936 Pscomp.exe 3/5/2004 1:06 AM 10.0.2104.305 64,240 Psvracub.dll 3/5/2004 1:02 AM 886 Pwdchnge.asp 3/5/2004 1:02 AM 1,438 Qrystr.asp 10/7/2003 6:57 PM 94,708 Qylibstd.sql 3/5/2004 1:02 AM 21,548 Resdetvw.asp 3/5/2004 1:02 AM 21,901 Resgraph.asp 3/5/2004 1:02 AM 23,581 Resregvw.asp 3/5/2004 1:02 AM 1,848 Savedata.asp 3/5/2004 1:02 AM 3,402 Sdbtask.asp 3/5/2004 1:02 AM 2,647 Sdbvison.asp 10/5/2003 11:54 PM 65,572 Secviews.sql 3/5/2004 1:01 AM 58,553 Seditcat.asp 3/5/2004 1:01 AM 4,713 Sesstart.asp 3/5/2004 1:01 AM 13,998 Sgroups.asp 3/5/2004 1:01 AM 23,517 Sgrpadd.asp 3/5/2004 1:02 AM 39,661 Shell.asp 3/5/2004 1:02 AM 6,018 Sproctsk.asp 3/5/2004 1:01 AM 6,198 Spwd.asp 3/5/2004 1:02 AM 70,043 Strepwz2.asp 3/5/2004 1:01 AM 22,916 Stsadmod.asp 3/5/2004 1:01 AM 4,373 Stsmodsv.asp 3/5/2004 1:02 AM 63,496 Stsutil.asp 3/5/2004 1:01 AM 31,845 Susers.asp 3/5/2004 1:01 AM 54,934 Susradd.asp 3/5/2004 1:01 AM 1,650 Svnotopt.asp 3/5/2004 1:01 AM 54,222 Svrdbdl.asp 3/5/2004 1:01 AM 9,679 Svrstsad.asp 3/5/2004 1:01 AM 8,979 Svrsync.asp 3/5/2004 1:01 AM 5,190 Syncuser.asp 3/5/2004 1:02 AM 31,702 Tmstrep.asp 3/5/2004 1:01 AM 17,417 Tskdlist.asp 3/5/2004 1:02 AM 5,115 Tskgrid2.inc 3/5/2004 1:02 AM 15,153 Tskopt.asp 3/5/2004 1:02 AM 15,741 Tskpages.asp 4/2/2003 1:32 PM 20,991 Tsktrans.asp 3/5/2004 1:01 AM 8,100 Uploaddc.asp 3/5/2004 1:02 AM 11,535 User.asp 3/5/2004 1:02 AM 37,281 Visonvw.asp 3/5/2004 1:01 AM 67,616 Vwaddmod.asp 3/5/2004 1:06 AM 10.0.2104.1305 129,776 Vwnotify.exe 12/12/2003 1:03 PM 1,105,276 Websps.sql
To determine the version of the file from this list that is installed on your computer, follow these steps.
Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
- Click Start, and then click Search.
- In the Search Results pane, under Search Companion, click All files and folders.
- In the All or part of the file name box, type the file name of the file that you want to find, and then click Search.
- In the list of files, right-click the found file, and then click Properties.
- On the Version tab, determine the version of the file that is installed on your computer.
Note If Project Server 2002 SP1 is already installed on your computer, you receive the following error message when you try to install Project Server 2002 SP1:
Windows Installer update requirements
To install the update that is described in this article, you must have Windows Installer 2.0 or later installed. Both Microsoft Windows XP and Microsoft Windows 2000 Service Pack 3 (SP3) include Windows Installer 2.0 or later. To install the latest version of Windows Installer, visit one of the following Microsoft Web sites:
Windows Installer for Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows Millennium Edition (Me):
Windows Installer for Microsoft Windows NT 4.0 and Microsoft Windows 2000 (pre-SP3):
List of issues fixed by the update
Project Server 2002 SP1 fixes the issues that are described in the following Microsoft Knowledge Base articles:
817835 PRJ2002: Actual Hours and Total Hours Are Blank in Timesheet View
331971 PSVR2002: SharePoint Team Services admin operation in Project Web Access does not work
328044 Microsoft Project Server 2002 update: August 20, 2002
331209 PRJ2002: Print Preview Problems with Text Box Draw Objects
329736 PSRV2002: Baseline Work Values Are Lost After You Change the Project Plan and You Republish
328988 PSRV2002: You Cannot Render Custom Indicators in PWA When You Print or Print Preview
331975 Scheduling Conflict Message When You Try to Recalculate a Project
811596 PRJ2002: The "Open from Project Server" dialog box does not support multiple-project selection
812638 PSVR2002: Task Reminder Notifications Do Not Contain the Project Name
812639 Duplicate projects appear in Microsoft Project Web Access, or you cannot generate OLAP cubes in Project Server 2002
812640 PSVR2002: Cannot Build OLAP Cube When Scheduled
815456 PSVR2002: Error Message When You Create a New Model
817542 PSRV2002: Date Range Is Wrong in Timesheet View
821608 PSVR2002: User Does Not Receive E-Mail Notification When New Task Is Assigned to User
821609 PRJ2002: Changes to the Enterprise Number Fields Are Not Updated in the Project Plan
821803 Outline codes that are written by the PDS show up incorrectly in Project Server 2002
822639 E-Mail Notification Reminders Use US Date Format in Mail Body for All English Versions of Project
822383 PSVR2002: Error message when you try to use the Portfolio Modeler
823333 Availability of the Microsoft Project Server 2002 hotfix package: July 7, 2003
823806 Availability of the Microsoft Project Server 2002 hotfix package: June 16, 2003
823807 Availability of the Microsoft Project Server 2002 hotfix package: July 16, 2003
823959 Microsoft Project Server 2002 hotfix package: July 24, 2003
328957 PSRV2002: JAWS screen-reader reads Tasks page and Internet Explorer stops responding
306220 PSRV2002: Timephase %Complete for non-working days is not calculated when you update actual work from Project Web Access
329732 PRJ2002: Performance Issues When You Use EnterpriseOutlineCodes
331199 PRJ2002: When You Try to Close a Master Project, You Are Repeatedly Prompted to Save Changes
306290 You experience long delays when you perform actions by using the Enterprise database in Project 2002
331195 Proj2002: Enterprise Text Fields Are Not Deleted from the Database Tables
827147 Availability of the Microsoft Project Server 2002 hotfix package: September 3, 2003
328982 Cannot access the Issues page in Project Web Access
830808 Microsoft Project Server 2002 hotfix package: October 30, 2003
830823 Microsoft Project Server 2002 hotfix package: November 11, 2003
822373 PSRV2002: Duplicate Templates Appear in Microsoft Project Web Access
817837 PSRV2002: Microsoft Project Server cannot use the date values specified when you build an OLAP Cube
Project Server 2002 SP1 fixes the following issues that were not previously documented in the Microsoft Knowledge Base.
The Project box shows all projects in the project database
When you view the Project box on the NewTaskPage.asp page in Project Web Access (PWA), all projects in the project database are listed. This issue may occur when you log on to Project Web Access by using New Project Task permissions and you are a member of the Team Member group.
You receive the "The page cannot be found" message if a file name contains DBCS characters
When you click the link in Project Web Access to edit a document, and then click the Discussion icon, you receive the "The page cannot be found" message and the file name in the URL appears incorrectly. This problem may occur if the file name contains DBCS characters.
All issues disappear when you filter issues in PWA
When you filter issues in your project plan on Project Web Access (PWA), all issues may disappear.
The Project plan from Project 2000 is not published to Project Server 2002
After you publish your project plan in Microsoft Project 2000 to your Project Server 2002 server, log on to Project Web Access as the project manager, and then click the link for your published project plan, information for your project plan is not found.
The Project plan is slow to open
When you try to open your project plan, the plan may take a long time to open. This problem may occur when there are many project plans in your project database.
You cannot publish a project plan or create a Portfolio Analyzer view
When you try to publish a project plan or create a Portfolio Analyzer view from a client PC that is not in the same domain where the Project Server resides, you cannot either publish your project plan or create the custom Portfolio Analyzer view.
Notification is not sent when the submitted time is declined by the project manager
In a Project Server environment where no SNMP mail services are available, notification is not sent for a team member who has submitted Actual Work for a task and has had the submission declined by a project manager.
Enterprise resources take a long time to open
When you try to open many Enterprise resources in your project plan, the resources may take an unexpectedly long time to open.
The lookup table that is linked by RBS field does not show in Portfolio Modeler
When you link the RBS field to another field's lookup table, the Portfolio Modeler does not show the lookup table.
You cannot remove SMTP server information in Project Web Access
After you enter information for an SMTP server on the Notifications page in Project Web Access, you cannot remove the information that you entered.
Actual Work does not show in a custom Assignment view
When you add Actual Work to a custom Assignment view, and then you view your custom Assignment view, the Actual Work field does not show.
Republishing a project plan may cause your plan to be duplicated in your project database
When you republish your project plan, your plan may be duplicated in your project database.
You cannot add an administrator back to My Organization
After you remove the administrator from My Organization on your project server, you cannot add the administrator back to My Organization.
Memory may not be released after you make ADO calls in your ASP or JSCRIPT code
When you make ADO calls in your ASP or JScript code in your project plan, memory may not be released.
Registry handles may not be released when you make PDS calls
When you make a Project Data Service (PDS) call that is not handled by the PDS or an extension, registry handles may not be released.
The Baseline Cost is different from the Baseline Cost that is reported by Portfolio Analyzer
When you have a 0-day duration task in your Enterprise project plan, Baseline Cost that is reported in Project Server Portfolio Analyzer may be different from the Baseline Cost in your project plan.
"Spooler error: 0x0004005" error message when you first try to save a project plan
When you first try to save your project plan on a project server that has the Windows SharePoint Services AutoWeb Create option turned on, you may receive a "Spooler error: 0x0004005" error message.
Keywords: atdownload kbinfo kbupdate KB830240
