RBS and Service Pack 1 (SP1)

[Stuart Futrill]

I have just applied Service Pack 1 to ProjectServer 2002
and Project Pro 2002.

Now whenever I save a change to an enterprise resource the
RBS field is left blank! This happens on changes from the
Enterprise Resource Pool and from Web Access. For example
I de-actiavted a user in web access and this also deleted
the RBS entry for that resource.

Is this a know problem, is there a fix?

Thanks Stuart.

 

[Gary L. Chefetz \(MVP\)]

Stuart:

This is a known issue. I'll get back to you with a workaround shortly.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

 

[Gary L. Chefetz \(MVP\)]

Stuart:

Run the following script and it'll prevent the RBS values for resources from
getting reset to NULL.

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

Once you've done this, the RBS values will behave normally.


--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

 

[Stuart Futrill]

Hi Gary

Thanks very much for the script.
I will run it later and hopefully resolve the problem.

Regards

Stuart.