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

Infrastructure Update Intel

posted July 28th, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3 out of 5)
Loading ... Loading ...

Update: Please see Christophe Fiessinger’s blog post concerning Known Issues with the Infrastructure Update

Popularity: 89%




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Infrastructure Update Caveats for Cost Resources

posted July 16th, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 4.5 out of 5)
Loading ... Loading ...

While reviewing the white paper that describes the recent Project 2007 Infrastructure Update in detail, I came upon some interesting information at the end of the document.

Before I start, I first want to thank and congratulate Microsoft on a job well done with the quality and quantity of documentation they’ve provided for this update. Compared to the sometimes-cryptic KB Articles that typically accompany hotfixes and updates, the Infrastructure Update’s documentation is outstanding.

That being said, I do have some concerns relating to the changes in Cost Resources, which are a new way in Project 2007 of accounting for costs associated with a project. Cost Resources are typically used to account for non-work costs such as travel expenses. The Infrastructure Update makes some significant changes to the way that Cost Resources function, and while I am a big fan of the idea of Cost Resources, I cannot help but be concerned by some of the caveats I’ve quoted below:




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Project and Project Server 2007 Infrastructure Update

posted July 16th, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5 out of 5)
Loading ... Loading ...

For those of you that haven’t heard yet, yesterday morning Microsoft released the long-awaited Infrastructure Update for WSS, the Office Servers (including Project Server), and Project 2007.

You can read an overview of updates here, and read detailed information in this white paper.

This update promises significant performance and stability improvements to the entire line of Office Servers, WSS, and the Project Client. If you haven’t already (or have only read the overview), I strongly recommend you read the white paper. It contains 30 pages of information about the update, and contains a lot of important information (including user scenarios to avoid).

From the overview:

Project Server

  • Timesheets and My Tasks stability and usability improvements
  • Queue Management user interface improvements
  • Logging Tracing improvements
  • Project Server performance improvements
  • Project Server 2003 to Project Server 2007 migration fixes



Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Issues with SQL Server 2005 SP2 CU7

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

Back in April, I posted an article where I recommended that you install the latest CU for SQL 2005 (CU7).

Since then, I’ve recieved feedback regarding some issues introduced by this CU. It would appear that they are more of an issue than I originally thought. Based on this feedback, I’m going to recommend that you all stick with CU6 for the time being.

Popularity: 79%




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Creating or Viewing Views in Data Analysis can cause Analysis Services to become unresponsive

posted April 23rd, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

At a previous client, I encountered an issue where, when creating or viewing certain views in Data Analysis, the Analysis Services service would spike in processor/memory utilization and become unresponsive.

I have recently discovered that this is a known issue in environments that have an interaction between Office Web Components and SQL Server 2005 Analysis Services with Service Pack 2 (which means Project Server).

Although I’m not 100% sure, I believe the KB that covers this issue is KB936251. The symptoms seem to fit.

At any rate, I have been told that the resolution was included way back in SQL Server 2005 Cumulative Update 2. I recommend that you install the current CU, which is CU7, due to the number of fixes it contains. UPDATE: I’ve recieved information that CU6 is a better choice due to some issues introduced by CU7. I’ve posted a followup article here.



Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



Event ID 6398, 6482, and 7076 in your event logs?

posted February 9th, 2008 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 4 out of 5)
Loading ... Loading ...

Are you seeing one or more of the following Event IDs (6398, 6482, and 7076) in your event log approximately every minute? Many of our clients have seen these errors indicating insufficient storage on their MOSS/WSS/Project Server farms, but are unable to find exactly what the errors refer to. Upon investigation, they generally find that there is sufficient memory and hard disk space on all servers in the farm (including SQL Server). However, even in cases where the amount of available storage is lacking, expanding the amount of available storage does not make the errors stop.

The full errors are:



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



Cube Build Failure: Your permissions on the server computer do not allow you to administer this Analysis server

posted December 22nd, 2007 by Stephen Sanderlin
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.5 out of 5)
Loading ... Loading ...

When building a cube for the first time,  a deployer will sometimes see an error similar to the following error message in the Cube Status screen:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to delete the Olap database: PWA_AnalysisServices. Error: Your permissions on the server computer do not allow you to administer this Analysis server. Error:

Typically, this error is caused by failing to correctly or completely follow the directions outlined in this article on configuring Analysis Services 2005 to work with Project Server 2007. It can also caused by not restarting Analysis Services after you give the SSP account administrative permissions to Analysis Services — this does not appear in the aforementioned article, but it is sometimes required.



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.