Upgrading from SharePoint 2013 to 2016 and ReportingServices/PowerPivot (SharePoint integration), when users attempt to modify an existing PowerPivot schedule, Unable update PowerPivot Schedule

Reviewing the SharePoint logs, there is an error Could not find stored procedure 'DataRefresh.GetSchedule' Missing DataRefresh.GetSchedule

Am I missing a patch? Current configuration:

SharePoint 2016 v. 16.0.4351.1000

SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.513.0

I can replicate the behavior on existing and new Excel documents (creating a new schedule seems to work and clearing the file's Properties didn't make a difference)

The [DataRefresh].[GetSchedule] is already removed in SP 2013 as mentioned at the official Microsoft article Changes to PowerPivot Service application database in SharePoint Server 2013

enter image description here


I think you got this error in SP 2016 for old files because you didn't apply the Hot fix on the SharePoint 2013 before migration.

The available workarounds

  • Recreate the old schedule again as a fresh and new schedule on the SharePoint 2016 that should be working properly as you confirmed!
  • Or Open a ticket with Microsoft, maybe they have easiest solutions!
  • Thank you for the response. Yes, I've read the article and this is a new SharePoint 2016+PowerPivot environment and able to reproduce the problem with a new Excel document. Our DBAs will not allow a SQL Server 2012 patch on SQL Server 2016 and those stored procedures listed do not exist on the old SharePoint+SQL server backend. I assume the hotfix has already been applied since SharePoint 2013 is working fine. – KevinRF 2 days ago
  • Ran a SQL Server trace and the SharePoint PowerPivot service is executing the GetSchedule stored procedure, but right after is executing the GetRefreshSchedule stored proc. No errors and if I run the command in SSMS, the data is returned, I assume, as expected. Some sort of bug...oops..undocumented feature in the service/UI? Opened a ticket with Microsoft. – KevinRF 2 days ago
  • Actually, it's a strange issue, in the documentation, Microsoft said the stored procedures already removed! I am looking forward to hearing from you after Microsoft reply! – Mohamed El-Qassas MVP 2 days ago
  • So far the techs are all focused on the warning (the red text in the first screenshot) and not the ULS logs or any of the other data points I've provided. I'm not inspired with confidence right now. – KevinRF 2 days ago

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.