Since the release of SP2 for PerformancePoint Server 2007 back in December there have been quite a few hotfixes released. The latest hotfix was just released this past week and will now bring the build number to 3.0.4315.00. This hotfix includes a fix for my posting last month PerformancePoint Dashboard Designer ‘Unable to connect to server’ with SSRS 2008. So the wait is over for anyone that has been patiently waiting to be able to use Report Center mode when using SSRS 2008 in Native mode in Dashboard Designer.
Since the SP2 release there have been quite a few fixes along the way and the hotfixes are cumulative, so if you install the latest one you will get the other fixes that have been made along the way.
Here is a list of some of the build numbers and links for the major releases and the latest hotfixes:
|3.0.4315.00||Description of the PerformancePoint Server 2007 hotfix package: April 28, 2009|
|3.0.4313.00||Description of the PerformancePoint Server 2007 hotfix package: February 26, 2009|
|3.0.4312.00||Description of the PerformancePoint Server 2007 hotfix package: February 24, 2009|
|3.0.4311.00||Description of the PerformancePoint Server 2007 hotfix package: February 9, 2009|
|3.0.4305.00||Description of the PerformancePoint Server 2007 hotfix package: February 2, 2009|
|3.0.4300.00||Description of the PerformancePoint Server 2007 hotfix package: December 22, 2008|
|3.0.4209.00||Description of PerformancePoint Server 2007 Service Pack 2|
|3.0.3917.00 (I had 3.0.3916.00 after my install)||Description of PerformancePoint Server 2007 Service Pack 1|
|3.0.3520.0||RTM Release of PPS 2007|
For a reference to the online documentation of component versions you can find that here – Monitoring Server and component versions. Take a look at this article too just for a refresher – Known issues and best practices in PerformancePoint Server 2007.
I did run into a few issues after installing this latest hotfix, but it might have been because we had the custom SDK filter installed (PerformancePoint Custom Dashboard Filter Experience). We didn’t have issues when we installed SP2 or hotfix for 3.0.4311.00, but this one did cause some issues. After I installed it it stated that the following when we tried to run and download the new update for Dashboard Designer:
the manifest may not be valid or the file could not be opened. + Manifest XML signature is not valid. + No signature was present in the subject.
Luckily this wasn’t a major deal for us since I had to setup the custom filter again so we could get the ODBC filter setup again to use with an Oracle data source. I just went through the steps to resign the manifest and application and all was good. Also ran into a minor issue in one environment after the new version of Dashboard Designer was installed. I tried the refresh to get the list of items available on the server and to connect to the server, but it stated that it was unable to connect. For some reason the pmservice.asmx file in the web service directory got corrupted and was not correct. When I tried to access the URL of the web service it stated this error message on the server:
The page must have a <%@ webservice class=”MyNamespace.MyClass” ….%> directive.
Inside the file it showed this:
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetKpis xmlns="http://www.microsoft.com/performancepoint/scorecards" /></soap:Body></soap:Envelope>
and it should have had this:
<%@ WebService Language="c#" Class="Microsoft.PerformancePoint.Scorecards.Server.PmService, Microsoft.PerformancePoint.Scorecards.Server,Version=18.104.22.168,Culture=neutral, PublicKeyToken=31BF3856AD364E35" %>
I swapped it out and this resolved that issue. So if you are having issues with Dashboard Designer and access the SSRS 2008 reports in Native mode download the latest hotfix Don’t forget, SP3 for PPS 2007 will be made available mid 2009 and that will supposedly be the final update for the stand alone product. Then on to PerformancePoint Services and SharePoint Server 2010 Enterprise
UPDATE (9/4/2009): new posting with additional hotfixes can be found here More PerformancePoint Server 2007 Hotfixes Available
UPDATE (10/16/2009): PerformancePoint Server (PPS) 2007 SP3 now available</< A>