FIX: PowerPivot workbooks are always loaded to the PowerPivot server that is last added to the SharePoint farm despite the use of server health based allocation or round-robin allocation

Article translations Article translations
Article ID: 2270925 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Expand all | Collapse all

On This Page

SYMPTOMS

You have a SharePoint farm that contains two or more PowerPivot servers in Microsoft SQL Server 2008 Analysis Services. However, the PowerPivot workbooks are always loaded on the PowerPivot server that is last installed in the farm. You expect the workbook to be loaded in the PowerPivot server that has the most RAM available. This issue occurs either when you use the default round-robin or the server health allocation for the PowerPivot servers. Additionally, this issue occurs even when other PowerPivot servers have more free memory.

For example, consider the following scenario:
  • You install the PowerPivot for SharePoint component on two computers.
  • On the first computer, you create a new SharePoint farm by running the SQL Server 2008 R2 setup wizard. This computer has 3.5 GB of RAM available. A PowerPivot Gallery is created automatically in the SharePoint farm.
  • You configure the SharePoint farm to use server health allocation for client requests.
  • On the second computer, you join the SharePoint farm on the first computer. This computer has less than 1.6 GB of RAM available. 
  • You create a PowerPivot workbook in Excel 2010 and upload the workbook to the PowerPivot gallery. 
In this scenario, the workbook is loaded on the second computer.  You expect the workbook to be loaded on the first computer.

RESOLUTION

SQL Server 2008 R2

The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
2261464 Cumulative update package 3 for SQL Server 2008 R2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about how to install the PowerPivot for SharePoint component, visit the following Microsoft Developer Network (MSDN) website:
Installation (PowerPivot for SharePoint)
For more information about how to plan a PowerPivot deployment in a SharePoint farm, visit the following MSDN website:
Plan a PowerPivot deployment in a SharePoint farm
For more information about how to use PowerPivot Gallery, visit the following MSDN website:
How to: Use PowerPivot Gallery
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499 New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 2270925 - Last Review: August 16, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Analysis Services
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2270925

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com