Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 922689 - Last Review: September 18, 2011 - Revision: 4.0
Windows SharePoint Services links are missing from project plans after you move Project Server 2003 and Windows SharePoint Services to a new server
After you move Microsoft Office Project Server 2003 and Microsoft Office Windows SharePoint Services to a new server, you notice that Windows SharePoint Services
links are missing from project plans in Microsoft Office Project Web Access.
When you try to add a new site link to a project plan, you may
receive the following error message:
The site that you are trying to link to is already in use by another project
This issue occurs if the following conditions are true:
- The new server name was not correctly added into the
MSP_WEB_STS_SERVERS table.
- An existing project still references the old
server.
After you move Windows SharePoint Services to a new server, the entry in
the MSP_WEB_STS_SERVERS table may be updated. Or, a second row may be added. The MSP_WEB_STS_SERVERS table contains the server name, the port,
the administration port, and the managed path of the sites.
In the
MSP_WEB_PROJECTS table, project sites are listed
in
the WSTS_SERVER_ID column.
This column links
to the MSP_WEB_STS_SERVERS table to identify the server. The subweb name in the WPROJ_STS_SUBWEB_NAME column provides
the remaining
text of the URL. If
content exists on the server that is listed
in the WSTS_SERVER_ID column, you
can access the content by
using Project Web Access.
And, the name
of the administration page
appears in the URL.
To resolve this issue, following these steps:
- Update the fields in the MSP_WEB_STS_SERVERS table so that the fields reference the new server.
- Update the WSTS_SERVER_ID column in the MSP_WEB_PROJECTS
table so that the column references the new server.
For example, if the server ID of the new server is 2, update
the value in the WSTS_SERVER_ID column to 2 in the MSP_WEB_PROJECTS
table.
APPLIES TO
- Microsoft Office Project Server 2003
| kbtshoot kberrmsg kbprb KB922689 |
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