Excel Services 2010 error - Unable to process request

Article ID: 2711527 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You have on a Windows 2008 machine that has Microsoft SharePoint Server 2010 installed.
You notice within Internet Information Services (IIS) that the application pool for Excel services has stopped. You start it, and it stops again. This occurs multiple times. You go to a Document library, and select to view in browser, an Excel file. You receive an error message as
"Unable to process request" 
You review the SharePoint server diagnostic (ULS) logs, and find performance counter call failure and the following error:

The Performance Counter OS (pdh) PdhAddEnglishCounter method call failed with error code PDH_CSTATUS_NO_MACHINE.
and
Unexpected exception occured while trying to access the performance counters registry key. Exception: System.InvalidOperationException: The Performance Counter OS (pdh) PdhAddEnglishCounter method call failed with error code PDH_CSTATUS_NO_MACHINE. at Microsoft.Office.Excel.Server.PdhPerformanceCounter.Pdh.CheckReturnValue(PDH_STATUS status, Boolean throwOnError, String methodNameForTracing) at Microsoft.Office.Excel.Server.PdhPerformanceCounter.Initialize() at Microsoft.Office.Excel.Server.PdhPerformanceCounter..ctor(String categoryName, String counterName) at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.Initialize()

CAUSE

This issue occurs when the Service account under which Excel services is configured to run does not have the necessary permissions to access the performance counters on the Windows 2008 server. Excel services initializes and detects the health of the server and its own services.

RESOLUTION

The service account associated to Excel services and the application pool that is running Excel services must have permissions to the registry key below.

The service account would need to be added to the two groups that are set on the registry key. The two groups are: Performance Monitor Users and Performance Log Users group. Add the two groups to the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

The permissions to grant to the two groups within the Advance settings of permissions are as follows:
  • Performance Monitor Users (<Machine_Name>\Performance Monitor Users): Read, Query Value, Enumerate Subkeys, Notify
  • Performance Log Users (<Machine_Name>\Performance Log Users): Read, Query Value, Enumerate Subkeys, Notify

The specific dialog boxes on the Perflib registry key permissions would be set to 'Read' for Performance Monitor Users and Performance Log Users:


Collapse this imageExpand this image
Dialog box for setting Read

You would select Advanced on the Permissions for Perflib, and set the following permissions for the Performance Monitor Users and Performance Log Users:

Collapse this imageExpand this image
Advanced Permissions dialog box

You will select within the Advanced Security Settings for Perflib, Performance Monitor Users, then click on Edit button. The Permission Entry for Perflib will be to add the following Allow Permissions, and once the permissions are selected, then click OK:

Collapse this imageExpand this image
2715747

You will click OK after setting the permissions on one group. You will return and select within the Advanced Security Settings for Perflib, Performance Log Users, then click on Edit button. The Permission Entry for Perflib will be to add the following Allow Permissions, once the Permissions are set, then click OK:

Collapse this imageExpand this image
2715750

Close all dialog boxes.

MORE INFORMATION

For a list of features that are accessible to the 'Performance Monitor Users' and 'Performance Log Users' group, view the following information:

Overview of Windows Performance MonitorFor further troubleshooting, you can check the System or Application Event log for the following Event IDs and information:

System Event log:

A process serving application pool 'd5da5ea468b74927b617f88811f9bb30' suffered a fatal communication error with the Windows Process Activation Service. The process id was '3372'. The data field contains the error number.

and
Application pool 'd5da5ea468b74927b617f88811f9bb30' is being automatically disabled due to a series of failures in the process(es) serving that application pool.

Application Event log:


Error - Event ID 1023 on .NET - .NET Runtime version 2.0.50727.4216 - (No additional details)

and
Warning - Event ID 2026 on Excel Services Application
An internal error occurred.
at Microsoft.Office.Excel.Server.PdhPerformanceCounter.Pdh.CheckReturnValue(PDH_STATUS status, Boolean throwOnError, String
methodNameForTracing)
at Microsoft.Office.Excel.Server.PdhPerformanceCounter.Initialize()
at Microsoft.Office.Excel.Server.PdhPerformanceCounter..ctor(String categoryName, String counterName)
at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp.Intialize()
at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2711527 - Last Review: May 26, 2012 - Revision: 7.0
APPLIES TO
  • Excel Services in Microsoft SharePoint Server 2010
Keywords: 
KB2711527

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