PowerPivot for SharePoint – Orphaned record for PowerPivot service application database

You may see the following error in Windows Event Viewer or the SharePoint ULS logs: Cannot open database "<Database name of PowerPivot Service application>" requested by the login. The login failed. Login failed for user '<username>'. This is an indication of an orphaned record regarding the PowerPivot service application database in SharePoint. This may happen…

0

When must I reboot a server running Excel Services?

I have seen the below errors that required a server reboot to fix the issue: Error in GUI: Error in ULS: 03/06/2014 17:43:45.29 w3wp.exe (0x3B38) 0x574C Excel Services Application Excel Calculation Services 89rs Exception ExcelServerApp..ctor: An unhandled exception occurred during boot. Shutting down the server. Microsoft.Office.Excel.Server.CalculationServer.Interop.LoadDllException: Failed to load engine dll.Acceso denegado.       at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.LoadDll(EngineFlags engineFlags,…


Farm Solutions & Excel Services "The Workbook cannot be opened"

I have seen several customers who have custom farm solutions deployed to their farm (Central Administration > System Settings > Manage farm solutions).  Some of these are for document libraries.  I have noticed the below error several times when opening a workbook from this location(s). "Couldn't Open the Workbook The workbook cannot be opened" From what I…


PowerPivot scheduled data refresh from a SharePoint list using OData data feed connection (PowerPivot 2012 SP1 for SharePoint 2013)

To set up PowerPivot for SharePoint scheduled data refresh for a PowerPivot workbook that has a connection to a SharePoint list in it, you do not need to use a data connection file like a List.atomsvc file (you do not need to use Export as Data Feed). Another way that you can set up PowerPivot…

3

PowerPivot for SharePoint – "An error occurred when loading the Sandbox cube"

You may receive an error similar to the following when running a scheduled data refresh of a PowerPivot workbook in SharePoint: The table with ID of '<TableID>', Name of '<TableName>' referenced by the 'Sandbox' cube, does not exist. An error occurred when loading the Sandbox cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup\Sandboxes\PowerPivotServiceApplication\<GUID>.db\Sandbox.9825.cub.xml'. You might…

0