how to populate empty project server database views

[Nosh]

The default views that come with the project server database are empty when I
look at them through enterprise manager. There are a couple of functions in
PDS that populate the views but they do it if you pass id for each project
into it. Is there a normal way to populate these views?

 

[Ed Morrison]

You must publish the project plans. In Project Pro go to Collaborate,
Publish, All Information. Close the project plan. After the publishing
operation completes, the views will be populated.

 

[Nosh]

I have published the projects, each one separately but apart from two views
"MSP_CONVERSIONS_PROJ_READVIEW"&"MSP_STRING_TYPE_PROJ_READVIEW"
allmost all of the rest seem to be empty. There is one more thing though in
our implementation of the project server the analysis server is not
emplemented at all.

 

[Ed Morrison]

Sorry, I thought you meant the PWA views.

Most of the database views check which objects you have access to in the
msp_res_security or msp_proj_security tables using your @@SPID (process
identifier of the current user)

These security tables are temporarily populated by the PDS during a Read or
Write operation, therefore this table should normally appear empty. As a
result, any view that is dependent on security will appear empty most of the
time.

If you are not using the PDS for data access, I would recommend that you use
the tables directly.

Hope this helps.
--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com