Data Mining Model Viewer of Decision Tree out of memory error

We've successfully processed a large decision tree model in SQL Server 2005. When I try to view the tree in the mining model viewer, I get the following error:

TITLE: Microsoft Visual Studio

The tree graph cannot be created because of the following error:

'Exception of type 'System.OutOfMemoryException' was thrown.'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=ErrorCreateGraphFailed&LinkId=20476

The link provides no other documentaiton on the error.

We're using 64-bit SQL on a Dell Workstation running XP-64 with 16GB of memory. From my view of things we aren't close to running out of memory. Since the model processed and the error occurs when viewing the model, is this a problem with Visual Studio and nont necessarily Anlaysis Services?

Thanks in advance.

Nick

Hello, Nick
As you said, it seems a viewer problem and not a server problem.
There is a simple way to find out: start the Profiler tool (All Programs\SQL Server 2005\Performance Tools\SQL Server Profiler) and connect to the Analysis Services instance.

Then, try to browse the model. If the error is coming from the server, you should see it in the trace.

If possible, please save the trace file and post it (or send it to me directly,
bogdanc AT microsoft DOT com), so that we can trace the problem

thanks|||

Bogdan,

Thanks for looking into this. The model errored I don't see any errors in the trace but I'm not sure. I'm very familiar profiler in term of SQL Server but Analysis Services. I'll send the trace directly to your email.

Nick

|||It looks like the tree has a really large number of nodes (around 34 000) and the viewer has troubles handling that many nodes and runs out of memory. We will definitely try to address this issue in future versions.
Meanwhile, here are a few suggestions:
- Increase the COMPLEXITY_PENALTY or the MINIMUM_SUPPORT parameters of the mining model. These would effectively reduce the complexity of the tree, bringing it to a more manageable size.
- Use the "Generic Content Tree Viewer" sample. It can be downloaded from here http://www.sqlserverdatamining.com/DMCommunity/_Downloads/1348.aspx
It allows interactive navigation of the model content and it provides access to all the information inside the tree viewer
- Use the Data Mining add-in for Visio -- it allows rendering of only the top levels of a tree