Problem with enterprise text fields and SQL server

S

Steve Heller

I am having a problem accessing data for an enterprise text field from
the ProjectServer SQL database.

What happens is that when I update "EnterpriseText2" in Project, the
change is not visible in the MSP_VIEW_PROJ_PROJECTS_ENT table in SQL
Server, and changing data in that table doesn't do anything to the
data seen in Project. The field I'm interested in isn't visible in the
Project Server web page.

I have found that the changes made in Project are actually recorded in
SQL Server, but only in the MSP_TEXT_FIELDS table, not in the
MSP_VIEW_PROJ_PROJECTS_ENT table that Microsoft recommends we use to
retrieve such data.

What should I do to get around this problem?
 
S

Steve Heller

I've found another problem in attempting to use MSP_TEXT_FIELDS
instead of MSP_VIEW_PROJ_PROJECTS_ENT: one of the projects in the
database has two rows of enterprise text fields in MSP_TEXT_FIELDS,
not just one. This seems like an error to me. Am I missing something
here?

When looking at this situation, I also noticed that the project id
isn't a key in MSP_TEXT_FIELDS, which is why it is possible to have
two rows for one project. Shouldn't that be a key, which would prevent
such duplication?
 
Top