(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)
Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct”. The file was there; he could be seen it using WebDAV “\\ServerName@CAPort#\PowerPivot Management\<guid for service application>\1033\Workbook Activity.xlsx” or the UI:
and then:
but it could not be accessed via CA.
Dan ultimately solved the problem by recognizing that he had configured AAM for the user visible Web Application, but since he didn’t configure the AAM name for CA, the system could not see the file. He added the AAM entry for both the affected web application and the CA web application and all worked as expected.
Moral of the Story: If you get “file not found” errors on SharePoint (particularly system files), two ideas should immediately pop into your head: (1) AAM server naming might be off (remember you need AAM mappings for IP addresses as well as ‘names’ in SharePoint – folks frequently forget that); or features could be disabled (some services register and deregister components if the feature is activated or not).
All-in-all, a GREAT catch by Dan – with my thanks.
Enjoy!
I had a problem where the path in the .odc file was incorrect. After uploading the changed file, all is well except for the silverlight control. Have to check that part with a net monitor.
[...] Please click through to continue reading Don’t forget your Central Admin when creating AAM entries [...]