Thursday, March 8, 2012

Data Mining Wizard (Not Responding)

I am trying to create a new mining structure, but when launching the wizard the "Data Mining Wizard" stops responding where the dropdownlist with the algorithms should appear.

The bizarre thing is that I can access the cube and the datawarehouse just fine using the same setup, it's just the mining wizard that doesn't work.

I am using SQL 2005 standard & Visual Studio 2005 Team Suite (and yes I have reinstalled SQL 2005) - no change.

Are there any logs that might shed some light on this strange behavior, or is this a known issue?

The main difference with the DM wizard is that, unlike other wizards, it actually connects to the server to determine the list of available algorithms. However, it is supposed to provide a default list of algorithms if it cannot connect.

You might try looking at the project settings to make sure that the deployment server is set up correctly.

Have you succesfully deployed any AS projects to an AS server?

|||

Hi Chris

The behavior of the algorithm selection wizard page is to retrieve the list of algorithm from the deployment server. If the query times out, it reverts to a list of cached algorithms. The value of the timeout depends on whether:

1. The server is a nonexistent machine (in this case, the timeout is equal to the time it takes to determine from DNS that the machine name is nonexistent and is usually fast)

2. The server is offline. In this case, the timeout is longer (usually 30 seconds, but can be configured under network settings).

3. The server is online, but Analysis Service is not started. This timeout is the TCP timeout, usually 30 seconds.

The first step is to determine your deployment server. For that, right click on the project select properties and look under Configuration Properties -> Deployment. The server name is available in the property grid. Next, please ensure that the server is reachable and is running Analysis Services. If it's an offline server, that you should get a list of default algorithms after 30 seconds or the timeout configured for your machine

Let me know if you have any further questions

Thanks

Shuvro

|||

I have the exact same issue, I have deleted and removed every thing and reinstalled SQl 2005 standard and Visual Studio 2005 and every time I get an unresposive screen when trying to pick a mining model.

I had created a mining model before and worked fine but know just stops responding.

|||

If possible, please work with tech support - we haven't seen these issues outside of what we've already commented on, and it's difficult to debug through the forum.

Thanks

No comments:

Post a Comment