Excel workbook disk cache cannot be created - Event 5226 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Excel workbook disk cache cannot be created

Event ID:   5226

Summary:   Excel Services Application saves the workbooks it loads to a temporary cache on disk. In this case, a workbook disk cache cannot be created on the Excel Services Application server computer.

Symptoms:   One or more of the following symptoms might appear:

  • Excel Services Application fails to start.

  • The provisioning of the service fails.

  • Workbooks fail to load.

  • This event appears in the event log: Event ID: 5226 Description: Unable to create or access workbook cache at <disk location of cache>. Excel Services Application cannot function without a workbook cache.

Cause:   One or more of the following might be the cause:

  1. The account that runs the application pool in which Excel Services Application runs might not have permissions to create a directory on the Excel Services Application server computer.

  2. The Excel Services Application server computer might have hard disk problems or the hard disk might be full.

Resolution:   Verify that the server computer is functioning and has sufficient disk space

  • Verify that the computer that runs the Excel Services Application server functions correctly and contains enough disk space. The event log message for ID 5226 identifies the disk that the Excel Services Application server uses.

Resolution:   Verify that the account that runs Excel Services Application can create a Temp folder

  • Verify that the account that runs Excel Services Application has permissions to create a Temp folder on the server computer. Delete the existing Temp folder so that the service can create a new Temp folder. Use the following procedure to identify the account that runs the application pool in which Excel Services Application runs.

To identify the application pool account:

  1. Click Start, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint Management Shell.

  2. At the command prompt, type the name of the Get-SPExcelServiceApplication Windows PowerShell cmdlet to obtain the name of the application pool. Note the value of the ApplicationPool property that this cmdlet returns.

  3. Click the Start button, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

  4. In the Connections pane, expand the server node and then click Application Pools.

  5. In the reading pane, in Features View, in the Identity column, note the account for the application pool that you identified.

Resolution:   Verify permissions on the workbook cache location

  • Verify that the account that runs the application pool in which Excel Services Application runs has permissions to create a directory on the Excel Services Application server computer. Start by indentifying the location of the workbook cache.

    To identify the workbook cache location:

    1. On the SharePoint Central Administration Web site, in the Application Management section, click Manage service applications and in the Name column click the name of the Excel Services Application application that is affected by the problem.

    2. On the Manage Excel Services Application page, click Global Settings and in the Workbook Cache section note the location of the workbook cache in the Workbook Cache Location text box.

    3. If the Workbook Cache Location box is empty, Excel Services Application is using the default location, %windir%\temp.

    To verify permissions on the workbook cache location

    1. Navigate to the parent directory for the workbook cache location. The default location is <OS drive>:\windows\temp.

    2. Right-click the folder and click Properties. The Properties dialog box appears.

    3. On the Security tab, in the Group or user names list, verify that the account appears that runs the application pool in which Excel Services Application runs. Note that the account might be a member of a group in this list.

    4. If the application pool account is not included in the list, click Edit, and then click Add.

    5. Type the name of the account and click OK.

    6. In the Properties dialog box, on the Security tab, click Advanced.

    7. In the Advanced Security Settings dialog box, select the name of the account, and then click Edit.

    8. In the Advanced Security Settings for <folder name> dialog box, verify that the account is selected, and then click Edit.

    9. In the Permission Entry for <folder name> dialog box, verify that all permission check boxes are selected for Allow, and that all permission check boxes are cleared for Deny.

    10. Click OK to close all dialog boxes.

Resolution:   Delete old Excel Services Application folders in the workbook cache directory, so that the cache can be recreated

  1. Navigate to the parent directory of the workbook cache. The default location is <OS drive>:\windows\temp.

  2. If the directory includes an Excel Services Application folder, delete the folder.

Resolution:   Perform an iisreset operation to restart the service

  • On the computer, click Start, click Run, and in the Open text box, type iisreset and click OK.