PowerPivot Management Dashboard Error (in SharePoint Central Admin)

Question

I have 3 SharePoint 2010 SP1 (Aug-2011 CU) farms. I've installed PowerPivot for SharePoint 2012 in all 3. (TEST farm has RC0, STAGE and PROD farms have RTM). PowerPivot appears to be working correctly in the user-facing web applications. The only problem I'm having is that the two Excel Services reports that are embedded in the PowerPivot Management Dashboard (in Central Administration) throws the same error in all three farms. The error dialog gives very little information:

• Title bar:  "Excel"
• Message:  "An error has occurred. Please try again."

I've studied the ULS logs during these events and though there are 30-50 entries for each. there doesn't appear to be much that helps me understand what the solution might be. One entry that seems promising is:

"The EXECUTE permission was denied on the object 'proc_FetchChunkFromDocStreams'"

I've seen a couple of other similar posts here and tried to follow any steps they noted as resolving their issue.

• I've made sure that the Excel Services service account has the correct rights in the content database for Central Admin (using the PowerShell GrantAccessToProcessIdentity method on the web application).
• I've made sure that Central Admin is registered as a "Trusted File Location" for Excel Services (and that both embedded and trusted data connection libraries are OK).
• I've trusted the "PowerPivot Management" document library as a data connection library.

I'm logging in as the account that was used to install / configure SharePoint which has full control in Central Admin.

I've also tried loading the embedded spreadsheets directly through Excel Services:

1. /PowerPivot%20Management/[GUID]/1033/Server%20Health.xlsx
2. /PowerPivot%20Management/[GUID]/1033/Workbook%20Activity.xlsx

Any suggestions on what I'm missing?

Thanks,

Mike:o

Answer 1

Hello Moverholt,

Could you share the ULS logs with us? And could you please set it to Verbose?

Thanks,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 2

Mariano -

Thanks for the reply. Would you like me to filter the verbose log file on something to reduce its size? I set logging to VERBOSE and repeated the steps then turned VERBOSE back off. Total elapsed time was about 90 seconds and it accumulated 11,663 rows (about 3.5 MB). Is there somewhere I can post the log file? I suspect it's way too much to include in a post here without filtering it somehow.

There are 145 entries with the correlation id associated with one of the two messages containing the string:

"The EXECUTE permission was denied on the object 'proc_FetchChunkFromDocStreams'"

There are many references in this set of entries to the "Server Health.xlsx" file. Let me know what you'd like me to send...

Thanks,

Mike:o

Answer 3

Hi moverholt,

Can you please sent it, zipped, to my email? mtn <at microsoft.com, and I'll take a look.

Thanks a lot,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 4

Hello,

I experienced the exact same problems. The Health & Usage book would never load. I assume that you have restarted the service as well as done an IISRESET. If not, do so. One other thing to try is in the app pool that hosts Excel Calc Services, set Load User Profile to True, then do another IISRESET. That fixed it for me.

Bryan Minarsky