Problem with RBS update using PDS

[Mikaelo]

Hello!

I have some strange problem.

I have RBS structure like
Node1
Node2
Node3
Node4
Node5

when i open PWA->Resources i see something
Node1
list of resources
Node2
Node2.Node3
list of resources
Node2.Node4
list of resources
all is ok.

Then using PDS i try to add some outline code with method
OutlineCodeAddValues, it add it correctly, i see it from Project (Windows)

but on tab Resourses i see some bad picture
Node1
list of resources
Node2Node3
list of resources
Node2Node4
list of resources

list of RBS structure without . it's very strange because in all other place
(for example assign resource a new RBS i see Node2.Node3)

any suggestions are welcome ....

Thanks, Mike

 

[Mikaelo]

found solution!

Project Server has incorrect stored procedure MS_PDS_CacheFullName

for getting code mask it using

select @code_mask = AS_VALUE

from MSP_FIELD_ATTRIBUTES fa inner join MSP_ATTRIBUTE_STRINGS ats on
fa.AS_ID = ats.AS_ID

where fa.ATTRIB_ID = 200

and fa.ATTRIB_FIELD_ID = @field_id

and fa.PROJ_ID = @ent_global_id


but correctly using with
and fa.Proj_ID = ats.Proj_ID

so right query:

select @code_mask = AS_VALUE

from MSP_FIELD_ATTRIBUTES fa inner join MSP_ATTRIBUTE_STRINGS ats on
fa.AS_ID = ats.AS_ID and fa.Proj_ID = ats.Proj_ID


where fa.ATTRIB_ID = 200

and fa.ATTRIB_FIELD_ID = @field_id

and fa.PROJ_ID = @ent_global_id


ProjectServer 2003 service pack1 will not correct this