Time phased data unsynchronized?

[Michael Glenn]

Hi,

I have an issue where time-phased data becomes unsynchronized. For example,
0h work for a task on a particular day when viewing the project plan, but an
SQL query on time-phased data for the same task gives 0.25h. Is there some
way to force re-calculation of time-phased data?

Thanks!

 

[James Fraser]

Hi,

I have an issue where time-phased data becomes unsynchronized. For example,
0h work for a task on a particular day when viewing the project plan, but an
SQL query on time-phased data for the same task gives 0.25h. Is there some
way to force re-calculation of time-phased data?

Thanks!

Are you using Project Server 2003 or 2007?
Are you querying the MSP_WEB_WORK table, or a view, or the reporting
database?
Have you published the project?


James Fraser

 

[Michael Glenn]

Hello James,

1) Project server 2003
2) I'm querying table msp_view_proj_assn_tp_by_day
3) The project is published

 

[Mike Glen]

Hi Michael,

I don't have a server, but just couldn't miss the opportunity to say Hi! to
my namesake


Mike Glen
Project MVP

 

[James Fraser]

Hello James,

1) Project server 2003
2) I'm querying table msp_view_proj_assn_tp_by_day
3) The project is published

I haven't seen a case where that doesn't match the project data, but I
usually use MSP_WEB_WORK as a more reliable table for what users have
entered.

Is there a difference between the timephased Actual Work and the
timephased Actual Work Protected in the project plan?


James Fraser