Article ID: 898463
Article Last Modified on 9/27/2007
APPLIES TO
- Microsoft Office Project Server 2003
SUMMARY
This article describes the Microsoft Office Project Server 2003 issues that are fixed in the Project Server 2003 post-Service Pack 2 hotfix package that is dated February 28, 2006.
This article describes the following items about the hotfix package:
- The issues that the hotfix package fixes.
- The prerequisites for installing the hotfix package.
- Whether you must restart your computer after you install the hotfix package.
- Whether the hotfix package is replaced by any other hotfix package.
- Whether you must make any registry changes.
- The files that the hotfix package contains.
INTRODUCTION
List of issues fixed
This hotfix package fixes the following issue.
898120 An SQL query that includes Resource and Calendar read views takes longer than expected to return the query results in Project Professional 2003
This hotfix package fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:
- Indicators to notify you that documents are associated with a task are missing after you modify a document library
Consider the following scenario. You link one or more tasks in a project to one or more documents in a Microsoft Windows SharePoint Services document library. Then, you modify the document library in Datasheet view. When you view the project on the View A Project page in Project Center, the There are documents associated with this task indicators in the Indicators column are no longer displayed next to the tasks in the project.
- The date that appears in the Created column is incorrect when you view a project in Project Center
Consider the following scenario. You programmatically create a project from an enterprise template by using the ProjectCreate method. Then, you log on to Project Web Access 2003 and view the project in Project Center. In this scenario, the date that appears in the Created column is incorrect. The date that appears in the Created column unexpectedly represents the date that the enterprise template was created. The date that appears does not represent the date that the project was created.
- The MSP_PDS_CacheFullName stored procedure contains an incomplete INNER JOIN statement
The MSP_PDS_CacheFullName stored procedure contains an incomplete INNER JOIN statement for the PROJ_ID field. This condition may create values in the OC_CACHED_FULL_NAME field that do not have separator characters.
- Resources unexpectedly appear in both the Filtered Enterprise Resources list and the Resources in the project list on the Build Team page
You click Build Team in Project Center to build a team for your project. When you view the Build Team page for your project, you find that some resources unexpectedly appear in both the Filtered Enterprise Resources list and the Resources in the project list. You expect a resource to appear in either the Filtered Enterprise Resources list or the Resources in the project list.
This problem may occur if Project Server 2003 contains a large number of resources. For example, this problem may occur if Project Server 2003 contains more than 2000 resources. In this scenario, the ResourcesStatus method incorrectly processes the resources that are displayed in the lists on the Build Team page.
- Unsubmitted timesheets for users who account status is set to Inactive are displayed on the View timesheet summary page
Consider the following scenario. You log on to Project Web Access 2003 as a member of the Resource Managers group or the Project Managers group. The link appears under Timesheet on the Home page indicates that one or more users have unsubmitted timesheets for a particular time period. When you click the link, the View timesheet summary page lists users who have unsubmitted timesheets. However, you notice that the list includes users whose account status is set to Inactive.
- Certain operations are performed two times when you build an online analytical processing (OLAP) cube in Project Web Access 2003
You build an OLAP cube in Project Web Access 2003. When you view the log file, the log file shows that the following operations are performed two times when the OLAP cube is created:- Initializing Cube 'MSP_ASSN_FACT'
- Initializing Cube 'MSP_RES_AVAIL_FACT'
- Information about resources does not appear in the table on the View resource assignments page
You log on to Project Web Access 2003, click Resources, and then click View resource assignments to view resource assignments for a project. You add resources to the Resources to display list, and then click Apply. However, in certain scenarios, information about the resources does not appear in the table on the View resource assignments page.
- Project Server 2003 sends e-mail messages about status reports to users even after the account status of users is set to Inactive
You configure Project Server 2003 to send e-mail messages to notify and remind users about upcoming or overdue tasks and status reports. Users who sign up for e-mail notifications and reminders receive the e-mail messages. However, Project Server 2003 continues to send e-mail messages about status reports to users even after you set the account status of users to Inactive.
- Values that represent actual work unexpectedly disappear when you view the next time period in Timesheet view
Consider the following scenario. You log on to Project Web Access 2003. In Timesheet view on the View my tasks page, you enter work that you completed on a project task assignment. You enter work for all days of the week. This work includes the weekend. When you click the arrow to view the next time period, values that represent actual work unexpectedly disappear.
- The Marked column is not displayed on the View a project page in Project Center
You publish a project that contains a Marked column to Project Server 2003. When you log on to Project Web Access and view the project in the Project Center, the Marked column is not displayed in the view on the View a project page. You expect the Marked column and the values that the column contains to be displayed in the view.
- "An error occurred while trying to access the resources stored on the database." error message when users try to view resource information on the Resources page
Consider the following scenario. You log on to Project Web Access 2003 and define a filter for a Resource Center view. The fields that you specify in the filter are not in the Displayed fields list for the view. When a user views resource information on the Resources page by using the Resource Center view that contains the filter, the user receives an error message that is similar to the following:The user cannot change to another Resource Center view until you remove the filter from the view or until you add the fields that are specified in the filter to the Displayed fields list.
- Elements of a status report are missing or are unavailable on the Submit a status report page
You create a status report request in Project Web Access 2003. Then, you send the status report request to your team members. When a team member fills out the status report, the user experiences the following symptoms on the Submit a status report page:- The Send button and the Save button are unavailable.
- Toolbars are missing from the page.
- Borders of certain text boxes are incorrectly rendered on the page.
- The name of the status report is not displayed on the page.
MORE INFORMATION
Service pack information
This problem was first corrected in Project Server 2003 Service Pack 3. To resolve this problem, obtain the latest service pack for Project Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
873458 How to obtain the latest service pack for Project Server 2003
Hotfix information
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Office Project Server 2003 service pack that contains this hotfix.
To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
Prerequisites
This hotfix is a Project Server 2003 Service Pack 2 hotfix. To install the hotfix, you must have Project Server 2003 Service Pack 2 installed.
For more information about Project Server 2003 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
887621 Description of Project Server 2003 Service Pack 2
Restart information
You do not have to restart your computer after you apply this hotfix.
Hotfix replacement information
This hotfix is not replaced by any later hotfix.
Registry information
You do not have to create any registry keys or modify any registry keys to use any hotfixes that this package contains.
File information
This hotfix may not contain all the files that you must have to fully update a product to the latest build. This hotfix contains only the files that you must have to correct the issues that this article lists.
The global version of this hotfix uses a Microsoft Windows Installer package to install the hotfix. The dates and times for these files are listed in coordinated universal time (UTC) in the following table. When you view the file information, the date is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Download information
| File name | File version | File size | Date | Time |
|---|---|---|---|---|
| Office2003-kb898463-glb.exe | 11.0.8015.0 | 4,138,232 | 28-Feb-2006 | 00:07 |
Microsoft Windows Installer .msp file information
| File name | File version | File size | Date | Time |
|---|---|---|---|---|
| Prjsvr.msp | Not Applicable | 4,588,032 | 28-Feb-2006 | 00:06 |
| Secviews.sql | Not Applicable | 94,644 | 27-Apr-2005 | 01:26 |
| Websps.sql | Not Applicable | 1,221,504 | 16-Jan-2006 | 20:46 |
After the hotfix package is installed, the global version of this hotfix package has the file attributes, or later file attributes, that are listed in the following table.
| File name | File version | File size | Date | Time |
|---|---|---|---|---|
| Build.inc | Not Applicable | 1,838 | 17-Jan-2006 | 09:46 |
| Entstrep.asp | Not Applicable | 53,307 | 17-Jan-2006 | 09:02 |
| Pds.dll | 11.2006.0.3117 | 1,260,296 | 17-Jan-2006 | 22:48 |
| Pj11od11.dll | 11.2.2006.1117 | 924,544 | 17-Jan-2006 | 23:52 |
| Pj11tm11.dll | 11.2.2006.1117 | 269,576 | 17-Jan-2006 | 22:48 |
| Pjbusobj.dll | 11.2.2006.1117 | 326,920 | 17-Jan-2006 | 22:48 |
| Pjclient.cab | Not Applicable | 656,620 | 18-Jan-2006 | 00:15 |
| Pjoledb.dll | 11.2.2006.1117 | 4,234,504 | 17-Jan-2006 | 22:48 |
| Pjsvradc.dll | 11.2006.0.3117 | 162,568 | 17-Jan-2006 | 22:48 |
| Prjres.dll | 11.2.2006.1117 | 1,735,552 | 17-Jan-2006 | 23:52 |
| Projolap.dll | 11.2006.0.3117 | 293,640 | 17-Jan-2006 | 22:48 |
| Qylibstd.sql | Not Applicable | 80,250 | 28-Sep-2005 | 00:22 |
| Serconv.dll | 11.2.2006.1117 | 641,920 | 17-Jan-2006 | 23:52 |
| Svrdbdl.asp | Not Applicable | 51,726 | 17-Jan-2006 | 09:02 |
| Webclvw.asp | Not Applicable | 49,102 | 17-Jan-2006 | 09:02 |
Additional notes
- For more information about how to install this hotfix, see the Readme.txt file that is included in the hotfix package.
For more information about the terminology that Microsoft uses when correcting software after it is released, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft Product updates, tools, and add-ons
Additional query words: PSRV PSRV2003 ProjectServer2003 prj svr
Keywords: kberrmsg kbtoolbar kbqfe kbprogramming kbautomation kbconfig kbhotfixrollup kbaccounts kbopenfile kbnewfile kbtasks kbprojectserver2003presp2fix kbexpertisebeginner kbprojectserver2003sp3fix KB898463
