strange project name "globalyyyymmdd"

[andrea molinari]

Hi everyone
I'm extracting some statistics from project server database, but I've
some strange behaviour. During tests, I published a project, that in
the table MSP_PROJECTS has been named in the form
"globalyyyymmddhhmmss", So the value of the field "proj_name" of this
table is something like "global20060530185921". After other publishing
operations, I finally had a record with the real name of the project,
but the "global2006...." was still in the database.
The serious problem is that the published project has some custom
fields associated: the respective values, in the tables MSP_CODE_FIELDS
and MSP_OUTLINE_CODES, are associated with the "globalyyyymmdd....."
project ID, while all the other data (resources, tasks, assignments)
are associated with the ID of the "normal" project ID.
Of course, when I do some joins to collect data for the "normal"
project, I can't get the values for the personalized field.
Can anyone give me some indication on what a "globalyyyymmdd" project
is, and most of all how to correct this problem or connect the two
projects, in order to get ALL the information?
Thanks a lot
Andrea

 

[Rod Gill]

I think the Global file is the Enterprise Global file. If so, DO NOT edit
it!! Any edit is likely to corrupt project server and possibly require a
re-install to correct. The date codes say when the Global file was backed up
last.

Even if you are reading data, I would not use it. In Project Server,
provided your projects are published, use the MSP_VIEW tables for reporting
purposes.