Project Server - force publish?

[Brian Edwards]

In our Project Server MS SQL database, there are tables called
MSP_WEB_PROJECTS and MSP_VIEW_PROJ_PROJECTS_ENT. There is supposed to be a
key connecting the two called WPROJ_ID on both tables. For one of our
projects there is an entry for "THIS PROJECT NAME" in the MSP_WEB_PROJECTS
table but not in the MSP_VIEW_PROJ_PROJECTS_ENT table. It sounds like
something failed at a time the project was trying to be published. Trying to
republish the project from Project Pro now fails.

Is there a solution to this problem? We have a Business Intelligence report
that runs every payroll period that should show what projects our employees
have applied time to and "THIS PROJECT NAME" does not show up even though we
are certain employees have applied time to the project over the last two
weeks.

Project Pro 2003
Project Server 2003
MS SQL 2000

TIA

 

[Brian Edwards]

In our Project Server MS SQL database, there are tables called
MSP_WEB_PROJECTS and MSP_VIEW_PROJ_PROJECTS_ENT. There is supposed to be a
key connecting the two called WPROJ_ID on both tables. For one of our
projects there is an entry for "THIS PROJECT NAME" in the MSP_WEB_PROJECTS
table but not in the MSP_VIEW_PROJ_PROJECTS_ENT table. It sounds like
something failed at a time the project was trying to be published. Trying to
republish the project from Project Pro now fails.

Is there a solution to this problem? We have a Business Intelligence report
that runs every payroll period that should show what projects our employees
have applied time to and "THIS PROJECT NAME" does not show up even though we
are certain employees have applied time to the project over the last two
weeks.

Project Pro 2003
Project Server 2003
MS SQL 2000

TIA

More info:

We tried the rebuild solution at
http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/BinaryRebuild.aspx to no avail.