No data in MSP_VIEW_PROJ_ASSN_TP_BY_DAY table

[Javier]

Hi,

I have a project published in Project Server but there is no data in
MSP_VIEW_PROJ_ASSN_TP_BY_DAY table. MSP_WEB.wproj_last_pub is today so I
don´t understand why there's no data. I need this data for reports

How can I solve this problem?

Thanks in advance

Javier

 

[Ray McCoppin]

You need to check and make sure that the views processing service is running
and ther are not xml files in the view drop folder.

This the normal cause why this happens.

Hope this Helps.

 

[Javier]

View processing service is running. I have a lot of files without this
problem but this one has it.

Thanks

 

[Gary L. Chefetz [MVP]]

Javier:

Are you using 2003? What service pack is your system? Are you using any
custom cost fields?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Javier]

Gary:

I´m using EPM 2003 SP1. I don´t use custom cost fields.

Thanks

 

[Gary L. Chefetz [MVP]]

Can you upgrade to SP2a on the server and SP2 on your clients? This may be
an issue that was corrected in the SP. You should be at this level by now.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com