unexplained MSP_PROJECTS record

[Stu Futrill]

Can anyone explain a record in the MSP_PROJECTS table in our PROJECT
SERVER SQL database. These are selected field values from the table.
The rest of the fields are identical to the Global Template record.

PROJECT_NAME global20030710101426
PROJ_PROP_COMPANY Microsoft Corporation
PROJ_READ_ONLY 1
PROJ_READ_WRITE 1
PROJ_READ_COUNT 1
PROJ_TYPE 1002
PROJ_CHECKEDOUT 1

My best guess is this is a corrupt Global Template record. It appears
to be checked out from the relevant field value, but does not show in
Project Server Admin section as a checked out project. Also from what
I can see the PROJ_TYPE value of 1002 is not valid. These are the
documented values for the PROJ_TYPE field that I have found.

0 - Regular project (default)
1 - Project template
2 - Global template
3 - Resource global
100 - Created regular project
101 - Created project template

Does anyone have any ideas how this record has been created, or if I
should delete it?

Thanks

Stuart.

 

[Stu Futrill]

After more testing it appears to me that Project Server
keeps a backup of the Enterprise Global (EG) . This takes
the form of an entry in the MSP_PROJECTS with PROJ_TYPE =
1002.

If anyone is interested ...

Each time you save the EG a new record is added into
MSP_PROJECTS table with PROJ_TYPE = 2 and the old EG is
changed to PROJ_TYPE = 1002. Also the EG that was
PROJ_TYPE = 1002 before saving is deleted.