Project Center view takes longer than expected to display projects in Microsoft Project Web Access (872819)



The information in this article applies to:

  • Microsoft Office Project Server 2003

SYMPTOMS

Microsoft Project Web Access takes longer than expected to open the Project Center view to display projects and project information that are stored on a Microsoft Office Project Server 2003 database.

CAUSE

This problem occurs because the Project Center view runs a query on the contents of the Project Server database. If the Project Server database contains many custom fields that are based on Enterprise Outline Codes (EOC), and if there are several filters that are based on these custom fields, the query will take longer than expected to run. This delay occurs because the query is not optimized for situations where there is filtering that is based on EOC-based custom fields and when there are many projects in the Project Server database.

RESOLUTION

How to obtain the hotfix

This issue is fixed in the Project Server 2003 Hotfix Package dated August 18, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

838882 Description of the Project Server 2003 post-Service Pack 1 (SProject Server 2003) hotfix package: August 18, 2004

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Modification Type:MajorLast Reviewed:4/7/2006
Keywords:kbQFE KBHotfixServer kbQuery kbweb kbtshoot kbProject2003sp1fix kbbug kbfix KB872819 kbAudITPRO