Microsoft KB Archive/875438

= After you install Service Pack 1, the RBS codes are reset in Project Server 2002 =

Article ID: 875438

Article Last Modified on 7/27/2006

-

APPLIES TO


 * Microsoft Project Server 2002, Service Pack 1 (SP1)

-



SYMPTOMS
When you apply Microsoft Project Server 2002 Service Pack 1 (SP1) to Microsoft Project Server 2002, the resource breakdown structure (RBS) relationships are reset.



CAUSE
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.



RESOLUTION
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



MORE INFORMATION
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.

Keywords: kbtshoot kbprb KB875438

-

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

© Microsoft Corporation. All rights reserved.