Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

Troubleshooting the PowerPivot Gallery. Thumbnails Not Rendering. Invoking and Analyzing the Getsnapshot.exe/Gallerysnapshot.exe

Troubleshooting the PowerPivot Gallery. Thumbnails Not Rendering. Invoking and Analyzing the Getsnapshot.exe/Gallerysnapshot.exe

  • Comments 7
  • Likes

Before you do anything, browse (while logged on the WFE as the account running the Web Application) to C:\Users\<WebAppAccount>\AppData\Local\Temp.  This location MUST exist, I have seen issues where the User Profile for the WebAppAccount does not exist.  This is where the .pngs (thumbanails) are placed prior to being updated in the PowerPivot Gallery.  If they can't be placed here, you can rest assured they will not be updated in the PowerPivot Gallery.



If my blog does not resolve it.  You will need to manually invoke the Getsnapshot.exe, rename the “thumbnails.info” file that is generated on the desktop to “thumbnails.txt” and look at its contents.  To manually invoke the thumbnails, find the account that is running your Web Application.  Log into the WFE as that account:


SharePoint 2010:


Start > Run > CMD > C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin


Pass this parameter: GetSnapshot.exe "http://tschauer2010" "http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" "C:\Users\tschauer\Desktop" thumbnail
26 300


SharePoint 2013:


Start > Run > CMD > C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\bin


Pass this parameter: GallerySnapshot.exe "http://tschauer2010" "http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" "C:\Users\tschauer\Desktop" thumbnail
26 300


*To build the above:


  1. You need to know the Web App, in this case: http://tschauer2010 (CA > Application Management > Web Applications > Manage Web Applications > URL): http://tschauer2010
  2. The path of the workbook, in this case: http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx


Here is an example of what it will look like (SharePoint 2010):


 If this runs, you will see the below icons on the desktop (this takes time):


The “thumbnails.txt” (after you rename and open in notepad) could say many things.  Here are examples and how I fixed them.

1. To fix the below, disableloopbackcheck (see KB 896891):

 <SnapshotCaptureLog serverUrl="http://tschauer2010" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx"
snapshotCount="26" timeout="300">
<Error timeout="True">System.TimeoutException: The operation has timed out.</Error>

Update (1/5/2015):

We ran into another scenario recently where this timeout error was presenting. It turns out that if your site is set up for Forms Based Authentication and you have a login page, snapshots will NEVER be generated properly. The thumbnail rendering for Excel worksheets has issues with non-Windows authentication methods. When a user saves a workbook in a PowerPivot Gallery, SharePoint triggers an event, which PowerPivot Gallery intercepts to launch a Capture Snapshot process that generates a new thumbnail for every worksheet in the workbook. This unattended Capture Snapshot process must authenticate to access the workbook but is generally unable to deal with login pages, such as to enter user credentials in an ASP.NET sign-in form or to select a particular authentication method if multiple methods are enabled on the Web app.

      Source (Page 13): http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/MSFTBIAuthOverview.docx

2. To fix the below add the below Service Pack to the PPIV machine:

Microsoft® SQL Server® 2008 R2 Service Pack 1

<SnapshotCaptureLog serverUrl="http://tschauer2010” workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnails"
snapshotCount="26" timeout="300">
<Error>onXLFrameLoad::Error! document.readyState = interactive</Error>
<Error>onXLFrameLoad::Error! document.readyState =

3. To fix the below, you can do one 1 of 2 things found in this KB:

Error message when you try to access a server locally by using its FQDN or its CNAME alias after you install Windows Server 2003 Service Pack 1: "Access denied" or "No network provider accepted the given network path"

Method 1 (recommended): Create the Local Security Authority host names that can be referenced in an NTLM authentication request

1.   Go to REGEDIT > HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > Lsa>MSV1_0
2.   Right click MSV1_0 > New > Multi-String Value
3.   Type ‘BackConnectionHostNames’
4.   Right click & select ‘Modify’
5.   Enter the Hostname of the site: WEBSITENAME (and on a new line enter the FQDN, WEBSITENAME.domain.com as well)


Method 2: Disable the authentication loopback check (On all WFE's (make sure to reboot)).

Re-enable the behavior that exists in Windows Server 2003 by setting the DisableLoopbackCheck registry entry in the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa registry
subkey to 1. To set the DisableLoopbackCheck registry entry to 1, follow these steps on the client computer:

1.Click Start, click Run, type regedit, and then click OK.
2.Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3.Right-click Lsa, point to New, and then click DWORD Value.
4.Type DisableLoopbackCheck, and then press ENTER.
5.Right-click DisableLoopbackCheck, and then click Modify.
6.In the Value data box, type 1, and then click OK.
7.Exit Registry Editor.
8.Restart the computer.

<SnapshotCaptureLog serverUrl="http://tschauer" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnail" snapshotCount="26" timeout="300">
<Error>Terminatingcapture process: 'Illegal redirection to resources outside of the web application:'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>

If you are using SSL you will want to look at you CAPI2 Event logs (Application and Services Logs > Microsoft > Windows > CAPI2) for GallerySnapshot.exe errors.  I have seen where servers are unable to retrieve the SSL cert for a couple of reasons (expiration or firewall/proxy blocking).  A workaround is to log on to the Web Front Servers as the account running the Web Application > Internet Options > Advanced > and uncheck "Check for server certificate revocation".  For security purposes you will want to get the Certificate issue resolved, but this can be a temporary workaround:

4. To fix the below:

Log on to all machines that are Web Front Ends with the account (very important) that is running the Web Application hosting the PowerPivot Gallery.  If this account cannot log on to that server you have a problem.  It needs to have access to that server.  Once logged on, Open Internet Explorer >Internet Options > Security tab > Trusted Sites > Sites > add the URL to the list of Trusted Sites (may need to log on to the WFE(s) as account running SP-80): http://tschauer2010:80

I have also seen that you need to un-tick "Require server verification (http:s) for all sites in this zone." under Internet Explorer >Internet Options > Security tab > Trusted Sites > Sites.

<SnapshotCaptureLog serverUrl="http://tschauer2010" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnail"
snapshotCount="26" timeout="300">
<Info>'http://tschauer2010:80' was found in a different trust zone (URLZONE_TRUSTED). Attempting to remove from URLZONE_TRUSTED.</Info>
<Info>’http://tschauer2010:80’ was removed from (URLZONE_TRUSTED)</Info>
<Info>’http://tschauer2010:80’ has been added to(URLZONE_INTRANET)</Info>

Refreshing PowerPivot Gallery thumbnails

  • #3 fixed it, thank you so much for posting this!

  • #3 AND #4 Thanks, your page is going directly in my favourites

  • Have you manually run and received this error on PowerView files in gallery?

    Unexpected content type:text/html; charset=utf-8

  • i am getting Illegal redirection to resources outside of the web application:'res://ieframe.dll/navcancl.htm'' error. Tried all above but still no luck. I am using Excel 2010 +SP2010 (sql 2008r2) +POWERPIVOT SQL 2012. Data is refreshing and snapshot is not capturing..!

  • What if i missing getsnapshot.exe file under C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin ?

  • Andrej: The getsnapshot.exe file should be located on the web front end server. If you are missing the getsnapshot.exe file, the Powerpivotwebapp.wsp solution may not be deployed to the web application. Go to SharePoint Central Administration > System Settings > Manage farm solutions to ensure it is deployed.

  • Did anyone responded to Sebastian's error "Unexpected content type:text/html; charset=utf-8" ?

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment