Submit My Question - Recent Questions - Recent Answer

Problem: Deployment works, but processing does not

Hi,

I am working with the 'Using SQL Server Data Mining" book, and am trying to deploy and process the 'MovieClick' example in chapter 3. Here is my problem: I am able to create the Data source, the source view, the data mining structure and data mining models (Decision trees and Bayes). When I select 'Buil - Deploy solution' all scripts are successfully deployed to the server, but once the processing start the application nothing happens. I see the that BI is trying to do something, or waiting for something. I can see a text that '0 cases are read'. The app does not time out, and i have to cancel the deployment.

Please let me know how to address this. I have followed the instructions in the book step-by-step (twice already), and I have the same problem. I have done the 'Adventure Works' data mining tutorials, and they work ok.

Any hint?

Thanks,

Doriak

[923 byte] By [Doriak] at [2008-2-7]

«« Problems with SQL Express Beta
»» Sending email in vb2005

# 1

Update on this issue.

I have tried the same project with the same instructions on a different machine, and I have the same issue. What it is worse, is that now once BI tries to kick the processing and it does not work, Visual Studio freezes so that I have to kill the process.

Doriak

Doriak at 2007-9-8 >

top of Msdn Tech,SQL Server,Data Mining...

# 2

Hi,

Could somebody please help clarifying this?

Thanks,

Doriak

Doriak at 2007-9-8 >

# 3

You might be hitting a bug that occurs on single-proc systems. You can work around by changing some server settings using SQL Server Mgmt Studio. See this thread for details: http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/2131.aspx

RamanIyer at 2007-9-8 >

# 4

Raman,

Thank you for the answer. The link you provided helped me to resolve the configuration issue. I am also working with a 1 CPU system for development purposes. I would like only to ask the team to provide updated documentation on configuration for typical scenarios as this was nowether to find in the BOL.

Thank you again. And now, back to mining :)

Doriak

Doriak at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech