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

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

|||

Hi,

Could somebody please help clarifying this?

Thanks,

Doriak

|||

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

|||

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