I recently encountered a problem that was resolved after some hit and trial efforts. Since I couldn't find the solution on google so I thought putting up it here would help some one using Performance Point and .Net 3.5
1. Installed and configured Performance Point server, no issues
2. Setup and published dashbaords
3. Didn't use for some time and in the meantime Installed Visual Studio 2008 and .Net 3.5
4. Recently tried to run the performance point, it failed to conenct to the database server, gave following error message
" unable to connect to the specified server"
5. Tested SQL db isntances and connectivity but everything was perfect and fully accessible from elsewhere
6. Tried connecting to to Performance Point Montioring Server (File->Options->Server->Connect), didn't' work either, same error message
7. Through IIS, brought up the web services page (http://localhost/WebService/PmService.asmx). There was the error message I was looking for, the web service could not run as it failed to load system.web.extension. The config file had version=1.0.61025.0 and although I had ver 1.1, 2, 3 and 3.5 of .net framework installed still it could not load the right dll.
8. I manually edited the web config and replaced all instances of version=1.0.61025.0 with Version=3.5.0.0. That's it, it started working again.
9. I had to do the same for http://localhost/Preview/web.config to bring up the preview site.
Thanks for your help Nick, the performance point guru.
Check Nick's post on similar database connectivity issue, if this is not the issue you are facing
http://nickbarclay.blogspot.com/2007/11/pps-data-source-connection-problems.html
Friday, February 22, 2008
MS Performance Point connection issue
Subscribe to:
Post Comments (Atom)
8 comments:
Glad to have been of help, Hassan.
Cheers,
Nick
Hassan
I believe the root cause is that the .NET 2.0 AJAX extensions are not installed. I tried the solution above, and can connect, but an IE Script Error occurs when opening an Analytic Chart or Grid in a Report.
Hassan,
I believe the root cause is that the .NET 2.0 AJAX extensions are not installed. I tried the solution above, and can connect, but an IE Script Error occurs when opening an Analytic Chart or Grid in a Report.
This post was really useful, but...
Parser Error Message: Unable to create type 'PPSWebParts:ScriptManagerLoader'. Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Hi hassan...
Can you tell me exactly where all to make these.. coz im getting stuck at this exact error.
I have .net framework 3.0..
Do i really need 3.5?
Hi nidhi,
This error occurs when you have .net 3.5 installed on your machine as I experienced, are you sure you do not have 3.5 installed on your machine? Check your config files what version they are pointing to and then check with your machine's assembly cache C:\WINDOWS\assembly to find what versions of system.web.extensions are installed on your machine.
hope it will help
I had the same issues. Turned out I didn't have the right Ajax Extensions installed.
Although the fixed mentioned here work for the preview, it doesn't work for the final deployed scorecards: you'll get the failure on ScriptManager as mentioned by John.
Don't change the web.configs, just install the Ajax Extension toolkit and you'll be up and running.
I was having he same issue due to .NET Framework 3.5 install, but instead of modifying my web.conf files I decided to run the ASP.NET AJAX 1.0 install (http://www.microsoft.com/downloads/details.aspx?FamilyID=ca9d90fa-e8c9-42e3-aa19-08e2c027f5d6&displaylang=en) which added the web.extension verion PerformancePoint was looking for. I now have both verions install and everything is working fine.
Murad Akram
Post a Comment