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

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.