EPMFAQ
Project Server Help, FAQs, Blogs, and HowTos
This is The Header Then

Project Server 2007 Post-SP1 Hotfixes

posted February 24th, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Chris Fiessinger recently posted a list of links to the post-SP1 hotfixes here.

For your benefit, I’ve copied them here:

These hotfixes take advantage of Microsoft’s new Hotfix Request offering… Each KB article for a hotfix has a link whereby you can submit an email request for the hotfix. Microsoft will respond with links to the hotfix. This should save you from having to call PSS every time you need a hotfix. However, if you choose to use these hotfixes, please remember that they have not been fully tested and you may experience some unexpected behavior.

Popularity: 18%




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Slow or Failing Cube Builds and Very Large TempDB

posted December 29th, 2007 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5 out of 5)
Loading ... Loading ...

At my present client, prior to the release of Project Server 2007 SP1, we obtained and deployed the hotfix rollup described in KB939594 to resolve some of the issues present in the product prior to the release of SP1.

Unfortunately, after deployment of this hotfix we discovered that when building the cube it would take significantly longer than RTM to build. Specifically:

  • Cubes built with earliest start and latest finish would take an hour and a half or more to build
  • Cubes built with a timeframe of 36 months forward and 13 months back 7+ hours to build and would cause the TempDB to get HUGE (in excess of 200GB)

When running the Cube Build without a date range, the cube would build in an hour or two — but as soon as you introduced a date range, the cube build would jump to 7+ hours, if it was even successful at all. More often than not, however, it would simply grow the TempDB to around 250GB, filling up the disks that the SQL databases were stored on and fail.




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts




The opinions expressed on this site by the authors and those providing comments are theirs alone, and do not reflect the opinions of the respective employers of the authors or any employee thereof. Our respective employers are not responsible for the accuracy of any of the information supplied by on this site.

Terms of Use | Privacy Policy | Publishers

All content on this website is covered by the
Creative Commons Attribution-Share Alike 3.0 United States License.
Theme ©2007 The Heckerped WordPress Theme created by JTk of Doc5 under the Creative Commons Attribution License.