Feb 06
PowerPivot Icons Not Displaying

Sign into the Server as the farm account or the web application pool account that runs the PowerPivot Service.

  • Open Command Prompt as an administrator
    • Change the directory to the root of C:\
      • You can do this by typing cd.. which takes you to the next sub directory. You generally will need to do this twice to get to C:\
    • cd C:\inetpub\wwwroot\wss\VirtualDirectories\www.domain.com80\bin\
      • GetSnapshot.exe "http://domain.com" "http://domain.com/sites/CoryRetherford/PowerPivot Gallery/document name.xlsx" "C:\Users\spaccount\Desktop" spaccount_log_file 26 300
        • Here is an explanation of each parameter
          • "http://domain.com" = http://www.retherfords.com
          • document name.xlsx = 2010 World Cup Tracker_Final.xlsx"
          • "C:\Users\spaccount\Desktop" = location you want to save the log file
          • spaccount_log_file = Name of the log file you specify
          • 26 300 = maximum number of snapshots and time until the process is aborted

  • After running this syntax you should see the following in the output log file that will be saved to the desktop you specified previous
    • <SnapshotCaptureLog serverUrl="http://www.domain.com" workbookUrl="http://www.domain.com/sites/CoryRetherford/PowerPivot Gallery/PowerPivot Healthcare Audit.xlsx" fileNameBase="spfarmpp_test" snapshotCount="26" timeout="30">

      <Snapshot filename="C:\Users\spfarm\Desktop\spaccount_test_0_A.png" name="ServerGroupPvt" type="1" active="True" />

      <Snapshot filename="C:\Users\spfarm\Desktop\spaccountpp_test_1.png" name="Dashboard" type="1" active="False" />

      <Snapshot filename="C:\Users\spfarm\Desktop\spaccountpp_test_2.png" name="Top 5" type="1" active="Fal    se" />

      <Snapshot filename="C:\Users\spfarm\Desktop\spaccountpp_test_3.png" name="Data for Sheet7 Chart 1" type="1" active="False" />

      <Snapshot filename="C:\Users\spfarm\Desktop\spaccountpp_test_4.png" name="Data for Sheet7 Chart 2" type="1" active="False" />

      <Error timeout="True">System.TimeoutException: The operation has timed out.</Error>

      </SnapshotCaptureLog>

  • You will also see image files (.png) appear on the desktop which is an indication that the process was successful.

Initially when I attempted the previous process I received an error in the resulting log files each time until I uninstalled IE9 from the Server
<Error>onXLFrameLoad::Error! document.readyState = interactive</Error>

Note*
Once you have completed these steps you will want to delete and reload the Excel PowerPivot enabled files to the SharePoint gallery. You can see an example of this by clicking the image below.

RESOURCES

http://blogs.msdn.com/b/mtn/archive/2010/10/15/how-to-manually-refresh-powerpivot-gallery-thumbnails.aspx
http://performancepointblog.com/2010/12/ie9-and-powerpivot-snapshot-generation-don%E2%80%99t-mix/

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools