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

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.


Stephen Sanderlin is Vice President of Technology for MSProjectExperts and a Microsoft Project MVP. His earlier writings on Project Management and Microsoft Project can be read at EPMFAQ.
He is actively posting new content at ProjectServerHelp.

Popularity: 36%




Discuss this post on the EPMFAQ Blog Posts Forum.


Related Posts



« Previous Entry Next Entry »

Please discuss this post on the EPMFAQ Blog Posts Forum.

2 Responses to “Creating or Viewing Views in Data Analysis can cause Analysis Services to become unresponsive”


  1. […] © Stephen Sanderlin for EPMFAQ, 2008. | Permalink […]


  2. […] Creating or Viewing Views in Data Analysis can cause Analysis Services to become unresponsive […]


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.