Microsoft KB Archive/905389

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

Article ID: 905389

Article Last Modified on 1/30/2007

-

APPLIES TO


 * Microsoft Office Project Server 2003
 * Microsoft Office 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://msdn2.microsoft.com/en-us/library/aa258260(SQL.80).aspx

Additional query words: prj srv query pwa

Keywords: kbdisplay kbtshoot kbprb KB905389

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.