Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 875438 - Last Review: September 18, 2011 - Revision: 3.0
After you install Service Pack 1, the RBS codes are reset in Project Server 2002
When you apply Microsoft Project Server 2002 Service Pack 1 (SP1) to Microsoft Project Server 2002, the resource breakdown structure (RBS) relationships are reset.
In Project Server 2002 SP1, there is an
SPROC
that examines the
WRES_RBS_UID_P10SP1 field in the
MSP_WEB_RESOURCES table. This
field must have a value that is the same as the corresponding value in the
MSP_CODE_FIELDS table. However, the SP1 upgrade strips a statement
that copies this value from the code fields table to the Web resources
table. Therefore, when the
SPROC finds the value missing, it deletes the
corresponding record in the
MSP_CODE_FIELDS table. The resource's RBS value is
set to NULL.
To resolve this problem, run the following script after you have installed Project Server 2002 SP1 and before you access Microsoft Project Server:
update wr
set wr.WRES_RBS_UID_P10SP1 = cf.CODE_UID
from MSP_WEB_RESOURCES wr inner join MSP_CODE_FIELDS cf on wr.RES_EUID =
cf.CODE_REF_UID
where cf.PROJ_ID = 1 and CODE_CATEGORY = 1 and CODE_FIELD_ID = 205521540
If you have already lost the RBS values, the script cannot restore them. Therefore, you must examine the enterprise resource and reset it. The RBS values are not reset until you check out the enterprise resource.
Therefore, until you checkout an enterprise resource, you will not notice
that there is a problem, because everything will work as expected. Setting it resolves the problem because the
SPROC correctly sets the right value in the
WRES_RBS_UID_P10SP1 field.
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