The Project Portfolio Server 2007 SP1 is now available:
For a list of what is fixed in SP1, check out:
PingBack from http://www.biosensorab.org/2008/02/18/project-portfolio-server-2007-sp1-is-here/
There are some very nice improvements. Sadly, reports which were configurated previous SP1 installation cannot be generated or edited anymore on my test system.
Unable to cast object of type 'Microsoft.Office.Project.PortfolioServer.BusinessLayer.Reporting.StructureEntriesListREC' to type 'Microsoft.Office.Project.PortfolioServer.BusinessLayer.Reporting.ReportEntityCollection'.
New reports are working fine, though.
Line, in regards to the issue that you were running into with your existing reports, were those reports working in PPS 2007 RTM or was it only after you applied PPS 2007 SP1 that it stopped working? Certainly very interested in this issue as we've not had other customers report this problem.
If your reports existed in a version prior to PPS 2007, it will need to be migrated as per the steps in the “Project Portfolio Server 2007 Programmers Reference” in order for the reports to be viewable in PPS 2007 RTM or SP1.
Aik, we are testing SP1 on the demo EPM environment of Microsoft. The version was PPS 2007.
We just tested it again on an environment identical to the one of our client, and we didn't meet the same problem, so I guess we'll take the risk and install it on the productive system.
I've no idea what didn't work properly on the first installation.
My reports are not working in the DemoVPCSP1 with the following error message.
To my knowledge I have only installed a printer in order to get the graphs working to the right of the matrixes in the optimizer. If this could be linked to the error I am receiving, I do not know, but it seems unlikley to me.
Sp1 caused the importprojects to fail
I encountered the same problem and error description as Tor after applying the SP1 to the MS Demo Image and other PPS systems running on PPS 2007 RTM (not upgraded from PPS 2006):
- Public reports in PPS fail to open with the error:
- public reports are not even listed anymore in the report manager of the reporting services! so they seem to be deleted after applying SP1!
- private reports cannot be opened in PPS instantly. At least they are listed as reports in the reports manager of reporting services. As a workaround you can edit the private reports in PPS and save them. Afterwards they are working again. However, this does not work for public reports.
I hope Microsoft can deliver a solution for that problem, since the public reports are the most important ones for the customers.
i can confirm the points Mirko posted, same behaviour after installation of PPS 2007 SP1 at one of our customers.
Maybe it's a temporary workaround to save all public reports as private, do the SP1 installation, edit the private reports and save as public again.
Comments from Microsoft are welcome :)
This is not really a comment, but a call for help!
I noticed that here we speak about portfolio and exactly I work above at the moment, and I am exactly confronted with an error which persite during the installation of portfolio server 2007 on sql server on 2005, the error is the following one:
-2147217913? fail to execute sql string, DB_PPSAccountData_Upgrade_12_Integrated SQL String, begin transaction set nocount on declare @accountid @internalclassid........
please if somebody went at the end of this installation, which he(it) helps me.
My e-mail: email@example.com