0

All of sudden PowerPivot Management Dashboard Processing Timer Job has started failing in my SharePoint 2013 server.

I have verified below:

  1. The Power Pivot SQL server instance is running SQL Server.
  2. Data Model Settings of the Excel Services application in SharePoint Central Administration has the PivotPoint server configuration.

What could be the reason for this failure and how to resolve this?

I found below errors in SharePoint hive logs.

Opening workbook model for refresh for url http://central admin site url/PowerPivot Management/GUID/PowerPivot Management Data.xlsx (session policy: CloseSessionOnDispose, KeepActiveSessionAlive)

Setting the ECS context scope to the following url: http://central admin site url/PowerPivot Management/GUID/PowerPivot Management Data.xlsx

EXCEPTION: NoAvaialbleStreamingServerException: we cannot locate a server to load the workbook data model. -> Microsoft.AnalysisServices.SPClient.Interfaces.ExcelServicesException: we cannot locate a server to load the workbook data model.....

The Execute method of job definition Microsoft.AnalysisServices.SPAddin.UsageProcessingTimerJob (ID 292a186b-c54e-4f4b-9e41-4592bd3c300a) threw an exception. More information is included below.

We cannot locate a server to load the workbook Data Model.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.