Performance Point Monitoring - cannot connect to the specified server

Today I was moving a prototype dashboard off a virtual server onto a development server. I saved the workspace file and copied it over and I got the following error when I clicked the test button in the data source page - "Unable to connect to the specified server. Make sure the address is correct"

image

This was a bit puzzling as it was connecting to "localhost" so it should have worked fine on the dev server.

If you do a search in your favorite search engine for this error you will possibly come across the following Microsoft Knowledge base article http://support.microsoft.com/kb/953107 (I have not set this up as a link so that it does not get any extra "google juice") which recommends uninstalling .Net 3.5, uninstalling PPS and then re-installing PPS before installing .Net 3.5. I'm not even sure if this server has the .Net 3.5 framework installed on it. Luckily I'm a bit lazier than that :) Looking down a few more results in the search turned up a forum post where it mentioned that the name of the PPS server is saved inside the workspace (.bswx) file.

So I opened the options dialogue and checked in the Server tab.

image

And what do you know, the name of my vritual PPS Monitoring server name was embedded in the workspace file and it was this server that Dashboard Designer could not find, not the SSAS server. Once that was fixed everything started working again.

image

If the error message had have said either

"Unable to connect to the specified PPS Monitoring server. Make sure the address is correct"

or better yet, something like:

"Unable to connect to the PPS monitoring server http://virt2k3s:40000/WebService/PmService.asmx. Make check the Server Url in the options dialog and make sure it is correct"

I could have solved this without having to resort to a web search. I have found that PerformancePoint has a few other non-specific error messages like this which are quite frustrating. I know there is the concept of not putting too much detail in the error messages for security reasons, but this error message is almost useless.

Another interesting development that I stumbled across is that the Dashboard Designer does not even seem to know that it stores this setting. If you change only the server details and then close Dashboard Designer without explicitly saving it will not recognize that the .bswx file needs saving and will discard your edits.

Update 21 Jun 08: As Nick points out. He actually covered this issue and much more in his post on connection issues in PerformancePoint, so if you are having other connection issues in PPS you should definitely check out that post. I had read his post when he made it and I knew I had all my identities correct as I had already connect to this server and was able to access other scorecards on it.

The subtle thing that I had missed was that opening a .bswx file could change the connection of a workspace.

I was also using a PC that still had IE7 configured to use live search which I had throught was closing the gap with google, but I just checked and live search ranks Nick's post much lower than google. So I have also just taken the link tags off the url to the MS KB article so that I do not contribute to that particular article's search ranking.

Print | posted on Saturday, June 21, 2008 12:02 AM

Comments on this post

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
Hi Darren,

I'm surprised that a search on "Unable to connect to the specified server. Make sure the address is correct" didn't present you with this: http://nickbarclay.blogspot.com/2007/11/pps-data-source-connection-problems.html. I detailed the solution to this problem in the second half of that post.

Cheers,
Nick
Left by Nick Barclay on Jun 21, 2008 7:56 AM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
The error message sounds like something has altered the pmservices.asmx file. You may have to do a repair or re-install of PerformancePoint.
Left by Darren Gosbell on Aug 05, 2008 9:38 PM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
Hi Darren,
I reinstalled the monitoring server component. I created a dashboard through DD, But when i tried to preview it on a website it gave me the following error:
Server Error in '/Preview' Application.
--------------------------------------------------------------------------------

Method not found: 'Void System.Web.UI.ScriptManager.set_LoadScriptsBeforeUI(Boolean)'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.MissingMethodException: Method not found: 'Void System.Web.UI.ScriptManager.set_LoadScriptsBeforeUI(Boolean)'.

Source Error:


Line 38: </asp:WebPartZone></td>
Line 39: </tr>
Line 40: </table><PPSWebParts:ScriptManagerLoader runat="server" id="scriptManagerLoader">
Line 41:
Line 42: </PPSWebParts:ScriptManagerLoader><script type="text/javascript">


Source File: c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\097d7ac93026477398efa5966ef1b64f\89e71f39760d4ce6991bc7d1b78d8656.aspx Line: 40

Stack Trace:


[MissingMethodException: Method not found: 'Void System.Web.UI.ScriptManager.set_LoadScriptsBeforeUI(Boolean)'.]
Microsoft.PerformancePoint.Scorecards.WebParts.ScriptManagerLoader..ctor() +0
ASP._097d7ac93026477398efa5966ef1b64f_89e71f39760d4ce6991bc7d1b78d8656_aspx.__BuildControlscriptManagerLoader() in c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\097d7ac93026477398efa5966ef1b64f\89e71f39760d4ce6991bc7d1b78d8656.aspx:40
ASP._097d7ac93026477398efa5966ef1b64f_89e71f39760d4ce6991bc7d1b78d8656_aspx.__BuildControl__control4(Control __ctrl) in c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\097d7ac93026477398efa5966ef1b64f\89e71f39760d4ce6991bc7d1b78d8656.aspx:5
System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
ASP.res_default_master.__BuildControlPlaceHolderMain() in c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\res\default.master:24
ASP.res_default_master.__BuildControl__control6() in c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\res\default.master:9
ASP.res_default_master.__BuildControlTree(res_default_master __ctrl) in c:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview\res\default.master:1
ASP.res_default_master.FrameworkInitialize() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\preview\e95ea01e\9767768b\App_Web_t4rm0mgx.6.cs:0
System.Web.UI.UserControl.InitializeAsUserControlInternal() +31
System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +1978544
System.Web.UI.Page.get_Master() +48
System.Web.UI.Page.ApplyMasterPage() +18
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +543




Left by NIdhi on Aug 11, 2008 10:34 PM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
I'm not sure what would cause this. That appears to be an issue related to the javascript. I have not seen anything like this, the issue may be somewhere in IIS.
Left by Darren Gosbell on Aug 16, 2008 12:56 AM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
I have tried the steps described above. But still the problem is not resolved and
I think the problem is coming because,
PPS monitoring application pools are not coming among the list of application pools in inetmgr. What to do for that?
Left by Kasturi Banerjee on Aug 19, 2008 4:45 PM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
Interesting,

sounds like good instructions, but not exactly what im looking for

Anyway, thanks for the post
Left by software development uk on Oct 10, 2009 1:38 AM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
@software development uk: If the connection to the PPS server is not your issue and you are trying to connect to a SQL or SSAS backend, then running a profiler trace may give you some hints as to why the connection is failing.
Left by Darren Gosbell on Oct 10, 2009 10:56 AM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
have u installed ajax 1.0 extension separately on your server machines or do u have .Net framework 3.5 version (which includes ajax extension 3.5). Performance point dashboard designer and its webparts look for all dlls corresponding to ajax 1.0 extension. Like for error related to </PPSWebParts:ScriptManagerLoader><script type="text/javascript"> is mostly because this tag is registered with Microsoft.PerformancePoint.Scorecards.WebParts, Version=3.0.0.0 assebly in GAC. which probably seeks to look for system.web.extensions version=1.0.6125.0. All this is related to installation of ajax extension 1.0
Left by mukesh on Mar 18, 2010 5:47 PM

# re: Performance Point Monitoring - cannot connect to the specified server

Requesting Gravatar...
That appears to be an issue related to the java script.I have not seen anything like this, the issue may be somewhere in IIS.
Left by mattress cleaning on Oct 28, 2010 6:29 PM

Your comment:

 (will show your gravatar)