.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Mining Model Prediction causing PC to crash

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hi,

Often when I run Mining Model Prediction from SQL Server BIDS my computer crashes.  We have checked my PC and it is fine (it is a new PC).

I have attempted to run Mining Model Prediction both on my PC on a local server and normally on a proper server with SSAS. 

Has anyone else had such an issue?  Where do we start looking to see what the problem is?

Thanks

Zoltan


Zoltan Hesley Ph.D Data Manager Callcredit UK


View Complete Post


More Related Resource Links

XBAP causing IE crash?

  
Our application is a C# XBAP.  Near as I can tell, the problem we are running into seems to be within IE rather than our code, so I tried looking for an appropriate IE forum, but the best I could find was "Internet Explorer Extension Development" and I got no response there, so trying here instead. Our application consists of a main IE instance (which contains the XBAP).  From the C# code in this XBAP, we obtain a reference to the IHtmlWindow2 object.  From that, we periodically call .open(...) to launch various other dialogs of interest to the user.  These dialogs typically contain a fair amount of Javascript as well. Our users began reporting random crashes, some with IE7, some with IE8.  I have been able to recreate a similar crash on my development system (Windows 7, IE8, Visual Studio 2010). Upon crashing, no information is sent to Event Viewer, and nothing is caught by our C# Exception handling either - IE simply exits.  I had to attach a native debugger (rather than managed) to get anything on this.  The debugger gave me the following error: Unhandled exception at 0x61755473 (mshtml.dll) in iexplore.exe: 0xC0000005: Access violation reading location 0xfeeefeee.   The error is apparently occuring in a native thread with the following callstack:      mshtml.dll!CRunPtrBase::SetRun()  + 0x3a b

Extracting Association Rules from Data Mining Model

  
Hi I have succesfully created a Data Mining Model using the Association Model. I have deployed and processed it. I need to extract all the rules that is generated by the model. I know that you normally query the model using DMX prediction queries, but in this case I need to extract the rules to a separate table for further processing. I have tried the following approaches unsuccessfully: 1. Linked server in MSSQL Management Studio. DMX query using OpenQuery. The DMX query looks like this: SELECT FLATTENED NODE_CAPTION, NODE_SUPPORT, NODE_PROBABILITY, MSOLAP_NODE_SCORE FROM DataMiningModel.CONTENT WHERE NODE_TYPE = 8   On small models this method works. On larger models with many rules I receive an exception: "XML for Analysis parser: The XML for Analysis request timed out" before it was completed This always happens after 70min. I might have missed a timeout option? 2. Using SSIS to run the same DMX query as above. The method is presented here: http://www.sqlservercentral.com/articles/MDX/64697/ This method works on small models. On larger models that did not work with method 1, it return rules. The number of rules returned is sometimes different for the same package run multiple times. For the largest models it simply returns 0 rules. I suspect that the same XML Parser error happens under the hood of SSIS. I'm currently stuck, and need some inp

Mining Model - Business user's view

  
Using BIDS, when I create a Mining model solution I can see lot's of useful utilities like Mining Model viewer, Mining Model Prediction etc that comes with lot's of graphs' etc. What would be the best approach to display these graph's to business users. Can I do this easily using SSRS/PowerPivot etc..

Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2

  

Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.

 

I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

CASES & CONTENT of a Decision Tree Mining Model in One View

  

I would like to have a SQL view that presents both the CASES & CONTENT of the decision tree mining model in one view. Meaning - the view shall consist of the following fields: Node_Name, The Column to Predict, Unique Number (or Key) of a case, and input features of the case. Here is an example:

  Node_Name        | Key |   Column to Predict   | Input1 | Input2 | Input3 |...

0000000000101      |57|

0000000000101     |372|

0000000000100     |118|

0000000000100      |52|

0000000000100     |623|

000000000010000  |41|

000000000010000 |205|

 

I'm familiar with queries such as those:

SELECT *
FROM OPENQUERY(AnalysisServer,
'SELECT * FROM [MyMiningModel].Cases
')
As DMX

SELECT *
FROM OPENQUERY(AnalysisServer,
'SELECT
NODE_NAME
FROM
[MyMiningModel].Content')
AS Dmx

I wish that there was a way to present the information in one view.

Thanks!


deploying mining model error

  

Error -- metadata Administrator errors. ' Sequence Clustering ~ MC ' Cube identifier of the reference to ' Sequence Clustering ~ MC-Order Number ', the name is ' Sequence Clustering ~ MC-Order Number ' dimension does not exist. There is an error in the metadata Manager. From the archives ' \\? \C: \Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008R2 SE.0. db\Sequence Clustering ~ MC.1.cub.xml ' loading Sequence Clustering ~ MC cube.  

Thanks & Regards


deploying mining model error

  

Error -- metadata Administrator errors. ' Sequence Clustering ~ MC ' Cube identifier of the reference to ' Sequence Clustering ~ MC-Order Number ', the name is ' Sequence Clustering ~ MC-Order Number ' dimension does not exist. There is an error in the metadata Manager. From the archives ' \\? \C: \Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008R2 SE.0. db\Sequence Clustering ~ MC.1.cub.xml ' loading Sequence Clustering ~ MC cube.  

Thanks & Regards


How to extract rule of mining model in DMX

  

Hello, I don't know how to extract the exact predict rule  for predict  data from mining model with DMX.

 I need to Show the rules extracted from the tree and Show the rule used for getting the predictive result in my application.

 Any help will be appreciated.


time series model - mining structure does not exist

  

I have successfully created a time series model using DMX code, but I haven't been able to export the predictions to my SQL database - the results are too large to copy/paste and I haven't been able to figure out code that will allow me to copy it directly to my SQL database. I know you have the option to save predictions to a SQL table in Visual Studio, so I'm trying to recreate the model using the new mining structure wizard on an entirely new SSAS database in Visual Studio. When I go to deploy the structure, it tells me that the mining structure does not exist. I'm confused because I'm trying to create the structure - of course it doesn't exist. Does anyone have any advice?


Myles McKee

mining model will not process on a named instance of SS 2005

  

What should be done if the error message is received:

OLE DB connection error

"make sure SQL Browser service is running on localhost"

?

My Browser service is running but it's on a named instance, not localhost.

My cube won't process (although I can browse it), neither will the mining model I've developed.

I've searched throughout the code but can't find any explicit reference to browser service. Where is the localhost specification appearing in the processing (either of the cube or the mining model)?

Are there any known fixes for this problem?

Thanks so much!
Laura

 


Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Model View Controller (MVC) for ASP.NET

  
Model View Controller (MVC) architectures, immediately wonder how the MVC pattern can be applied in an ASP.NET world. This article will demonstrate how the MVC pattern can be applied to an ASP.NET web application and still maintain the basic Microsoft supplied architecture.

Dynamic Systems Development Model (DSDM) Methodology

  
The Dynamic Systems Development Model was developed in the U.K. in the mid-1990s. It is the evolution of rapid application development (RAD) practices. DSDM boasts the best-supported training and documentation of any of the agile software development techniques, at least in Europe. DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

Overview of SharePoint Object Model

  
SharePoint offers a set of structured server-side objects those are widely used to program SharePoint Applications. These objects are hierarchically arranged and you can drill down through the object hierarchy to obtain the object that contains the components of SharePoint Application you need to use in your code.

Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

'Model' cannot be declared in this scope

  

I have a complex partial view (ugly stuff), the view page has this line:- 

<% Html.RenderPartial("PartialIndicatorWeighting", indicator);%>
and inside the ugly partial view I have this,
<td><%: Model.Active %><%: Html.CheckBoxFor(Model => Model.Active)%></td>
I'm trying to display a list of checboxes to show if the item is active or not, I get the following error:-
 
A local variable named 'Model' cannot be 

lossing focus from model pop up window controls

  

hi i using a model pop up window with some textbox but when i click on textbox of model pop up focus move to back to page textbox control plz help me 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend