Earlier this week i had an issue at a client site with PPS and a Sharepoint farm. The site had 2 servers in their Sharepoint farm.
I went in to develop some dashboards and found out that there was a problem using Excel Services reports.. everything else seemed ok. Within Dashboard Designer, the View tab for the Excel services report was unable to display the report. A standard IIS .Net web app error page came up saying “Error in ‘/’ Application”, specifically that ExcelServicesPage.aspx was not found. Luckily i had remote access to the Sharepoint servers so i traced this error down to the following:
- the Excel Services calculation engine was only installed on one box in the farm (the secondary box)
- the application was trying to load the Excel Services web part (ExcelServicesPage.aspx) from the server that contained Excel Services.
- PPS was only installed on the primary server in the farm
To fix this i simply ran the M&A install on the secondary server in the farm. Note that I chose the distributed install and only chose to install the web parts on the secondary server. This worked immediately without a reboot or restart of IIS.