Project Server 2007: Has your cube build stopped working to the schedule?

Thanks for this resolution go to two of my colleagues in France – Bruno Sgorlon and Marc Biarnes.

The symptoms the customer had were that they could build the cubes just fine when using the manual “Build Now” option – but the cube builds were not happening at their scheduled times.  In one of the cases another symptom was that the “CubeAdminSRPJob” job was not present in the Timer Job definitions.

This issue was traced to a desynchronized WSS file system cache and was resolved by clearing the WSS file system cache on all servers in the farm.

To do this you can follow the resolution steps mentioned in the following article :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;939308

The article actually refers to an error you can see after changing some alternate access mappings – but the resolution also applies to, and more importantly, helps resolve this cube scheduling issue.

After all the steps in the article are done correctly, then change the scheduling for Project Server Cube building :

  • Uncheck both check boxes for the cube update Frequency  and click Save.
  • Check both check boxes for the cube update Frequency  and click Save.

Thanks Bruno and Marc for finding this resolution, and also for allowing me to share on my blog.

Technorati Tags: