PawnofGod on Thu, 06 Oct 2016 17:59:31
PowerPivot has been successfully setup on AppServer1. Data refresh is working and the timer jobs are running. I configured APPServer2 for PowerPivot and when PowerPivot runs on AppServer2 alone, PowerPivot successfully runs the workbooks and they are loaded into Analysis Services, but the Data Refresh timer job doesn't run. At least, there is no indication that it did run. If I run the job manually it doesn't fail but it doesn't show as successful either. Workbooks are not getting refreshed. Any thoughts would be appreciated.
Dean_Wang on Fri, 07 Oct 2016 01:49:30
Please view Job History in CA after you run PowerPivot Data Refresh timer job. Then provide screenshot about the PowerPivot Data Refresh timer job status here.
And provide error message in ULS logs.
ULS viewer is a good tool to check for ULS logs:
Eric Hager on Tue, 25 Sep 2018 20:38:56
Did you ever find a solution for this? I am having the same problem.
PawnofGod on Wed, 26 Sep 2018 11:09:19
I had to look through my old notes for this. This is quote from my notes, "I could not get the PowerPivot data refresh timer job to run on the second server. After tons of research I finally rebooted both servers and it worked."
I hope this helps.
Eric Hager on Wed, 26 Sep 2018 12:37:42
Thanks for responding. I will give this a shot tonight and update the thread with my results. Fingers crossed...
Eric Hager on Wed, 26 Sep 2018 14:28:23
Ha! That worked! I couldn't wait until tonight to give this a try, so I just moved some services to other servers and rebooted both of the servers in question. Yesterday, I had rebooted Server2 and it did not work. After reading your response this morning I went ahead and rebooted server1, this also did not work. I then rebooted the servers together, first server2 and then server1 a few seconds later and this worked. Not sure exactly what was going on to make it happen this way but hopefully these extra details will save someone else a lot of headaches.