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 4
  • Likes

Hello Everyone,

 

We have seen an increase in PowerPivot Thumbnail issues.  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 do this, find the account that is running SharePoint-80.  Log into the machine 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"
fileNameBase="747f6f1d_0307_40f3_84ca_e7b4b3f05373"
snapshotCount="26" timeout="300">
<Error timeout="True">System.TimeoutException: The operation has timed out.</Error>
</SnapshotCaptureLog>

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

Microsoft® SQL Server® 2008 R2 Service Pack 1
http://www.microsoft.com/download/en/details.aspx?id=26727

<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 =
interactive</Error>
</SnapshotCaptureLog>

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"
http://support.microsoft.com/kb/926642

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)

tschauer
tschauer.<fqdn>

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>
</SnapshotCaptureLog>

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>
</SnapshotCaptureLog>

Refreshing PowerPivot Gallery thumbnails
http://blogs.msdn.com/b/mtn/archive/2010/10/15/how-to-manually-refresh-powerpivot-gallery-thumbnails.aspx

Comments
  • #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..!

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