Projects missing in MSP_VIEW_PROJ_PROJECTS_ENT

[madrigal]

Hi group, I' have a problem with some projects. I 've published the projects,
but they are not appearing in the table MSP_VIEW_PROJ_PROJECTS_ENT. Other
projects in similar conditions are in the table. I supposed that publishing
the projects create an entry for the projects in the table ¿isn't it?. ¿Any
one of you have had the same problem?
Thanks in advance.

 

[Jonathan Sofer - MCP]

Are there any files stuck in the view drop folder?

 

[Elias Hämäläinen]

Hi,

I had the same problem. You probably have solved the issue, but here's what
I have noticed.

I find out that the projects which didn't appear in the
MSP_VIEW_PROJ_PROJECTS_ENT had very high (over 10^7) EnterpriseProjectCostn
values. If the value was under that, the project showed up in the table after
publishing. Weird.

Does someone know how to use higher values in enterprise cost fields?

 

[Gary L. Chefetz [MVP]]

Elias:

This is a known issue in Project Server SP1. Enterprise cost fields
containing values > 24 million prevent the _ENT table from being written.
This hotfix was released a while ago, but go ahead and get the latest hotfix
from Microsoft and the problem will go away.

 

[Gary L. Chefetz [MVP]]

Elias:

I should have been more specific. This is fixed post SP1, so you must have
SP1 installed first.