Resource availability information and MSP_VIEW_* tables

A

alo

Hi:

I have configured PWA to generate only resource availability information in
a range of two years all nights. It had been working ok until some days ago,
when I noticed it started to fail. I noticed that the information at least in
the MSP_VIEW_PROJ_ASSN_TP_BY_DAY is wrong (exists one entry for each day of
the assignments but the fields about work, realwork, ... of the assignment
are 0 fo some projects that should have values in those days).

I have read in the administrator's guide that the COM+ Microsoft Office OLAP
Cube component controls the generation of information of availability, so I
have tried with various configurations of the COM+ Microsoft Office OLAP Cube
component changing the activation from Server to Aplication, ... but it
doesn´t seems to work properly (generates the information one day and stop
some days after...)

So my cuestions are,
what is the recomended configuration for the COM+ component?
Why can it be failing?
Why i`m loosing information in MSP_VIEWS_* tables if they shoud be updated
in the publishing process?

Thanks.
 
Top