Re: trouble with viewing lift chart

Jesse,

I did not give up with this issue. I used MVP channel to talk with MS Data Mining team, and here is what I got from Jamie MacLennan:

"My guess is that this is a known issue with having lots of nested tables causing a server deadlock. Setting the CoordinatorExecutionMode to a larger negative number (e.g. -8) prevents this from happening."

You can check also the SSAS Server Properties whitepaper at http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx


"jf" <jesse.farmer@xxxxxxxxx> wrote in message news:a2cad933-19fc-412c-9c72-ff16e85073a1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Yeah, I installed SP2 and I set the connect timeout in my VS client to
a high value for the AS designer. I'm actually getting a slightly
different error now viewing the lift chart:
------
Failed to execute the query due to the following error:

Execution of the managed stored procedure
GenerateScatterTableUsingDatasource failed with the following error:
Exception has been thrown by the target of an invocation.Memory error:
Allocation failure ..
-----

This seems to happen if I include all of my nested tables (8 nested +
1 case). If I leave off 1 nested table, I DO get my lift chart. Is
this a limitation (only 8 total tables)?

.

Loading