It takes a longer than expected to for a custom view to display project information in Project Web Access 2003 (905389)

The information in this article applies to:

Microsoft Office Project Server 2003
Microsoft Project Web Access

SYMPTOMS

Consider the following situation. You connect to the Project Center page in Microsoft Office Project Web Access 2003. You use a custom view to display project information. The custom view uses filters that are based on enterprise outline codes.

In this situation, it takes a longer than expected for Project Web Access 2003 to display the project information. For example, it may take 60 seconds before the project information appears on the Project Center page.

CAUSE

This issue occurs because the MSP_OUTLINE_CODES table in the ProjectServer database links to a field that does not contain an index. The MSP_OUTLINE_CODES table is typically read-only. Additionally, the MSP_OUTLINE_CODES table contains a clustered index.

WORKAROUND

To work around this issue, create a new non-clustered index named MSP_OUTLINE_CODE_UID in the MSP_OUTLINE_CODES table. To do this, run the following SQL command:

create nonclustered index MSP_OUTLINE_CODES_CODE_UID on dbo.MSP_OUTLINE_CODES (CODE_UID)

MORE INFORMATION

For more information about how to create indexes, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_64l4.asp

Modification Type:	Minor	Last Reviewed:	7/27/2006
Keywords:	kbdisplay kbtshoot kbprb KB905389 kbAudITPRO