Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 924519 - Last Review: September 18, 2011 - Revision: 3.0
Publishing is blocked when you publish large project plans in a deployment of Project Server 2003 that uses more than one server that is running the Views Notification service
Consider the following scenario. In your deployment of Microsoft Office Project Server 2003, you have more than one server that is running the Views Notification service. You publish multiple large project plans to Project Server 2003. However, after some time, you can no longer publish project plans. Publishing is blocked. Specifically, the following query is blocked:
MSP_WEB_SP_QRY_ViewTaskTimephasedByDay_DeleteViewTable0;1
You experience this symptom intermittently.
This issue occurs if the following conditions are true:
- You have multiple views processing servers in your deployment of Project Server 2003.
- You publish multiple large project plans.
- You use the Microsoft Office Project 2003 Software Development Kit (SDK) to extend the databases that are used by Project Server 2003 to include the MSP_VIEW_PROJ_RES_TP_BY_WEEK table.
- A deadlock condition occurs in the MSP_VIEW_PROJ_RES_TP_BY_WEEK table.
To work around this issue, add an index to the MSP_VIEW_PROJ_RES_TP_BY_WEEK table. To do this, follow these steps:
- Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
- In the Connect to SQL Server dialog box, specify the name of the instance of SQL Server to which you want to connect in the SQL Server box, specify your login name and password in the Login name and Password boxes, and then click OK.
-
On the Query menu, click Change Database.
- In the Select database of ServerName dialog box, click ProjectServer, and then click OK.
- Copy and then paste the following lines to the Query box.
alter table MSP_VIEW_PROJ_RES_TP_BY_WEEK add SUROGATE_KEY int identity constraint SUROGATE_KEY_PK PRIMARY KEY
go
create nonclustered index TESTINDEX1 on MSP_VIEW_PROJ_RES_TP_BY_WEEK ( WPROJ_ID )
go
- On the Query menu, click Execute.
You receive the following message in the Messages box:
The command(s) completed successfully.
- Exit SQL Query Analyzer.
APPLIES TO
- Microsoft Office Project Server 2003
| kbperformance kbexpertiseinter kbtshoot kbprb KB924519 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate