trouble with viewing lift chart

[j***@gmail.com]

I'm having _occasional_ trouble viewing my lift charts. I'm using
Visual Studio and SQL Server 2005. The error I get is always:

----------------
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.Error (Data
mining): The specified DMX column was not found in the context at line
571, column 28..
-------------

Sometimes if I reprocess the model, my lift chart will come out ok.
This happens on some models but not others. All my models are against
the same database. The database is NOT a named instance. I've tried
restarting SQL Server and Analysis Services Server repeatedly, and it
has no effect. I've also redeployed my project and rebuilt my model
multiple times.

Any thoughts? This is a very annoying problem.

[Dejan Sarka]

I hope this is not too basic answer. However, occasionally I had similar
problems with lift chart before applying SQL Server 2005 Sercive Pack 2.
Could you check this?
--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

Post by j***@gmail.com
I'm having _occasional_ trouble viewing my lift charts. I'm using
----------------
Execution of the managed stored procedure
Exception has been thrown by the target of an invocation.Error (Data
mining): The specified DMX column was not found in the context at line
571, column 28..
-------------
Sometimes if I reprocess the model, my lift chart will come out ok.
This happens on some models but not others. All my models are against
the same database. The database is NOT a named instance. I've tried
restarting SQL Server and Analysis Services Server repeatedly, and it
has no effect. I've also redeployed my project and rebuilt my model
multiple times.
Any thoughts? This is a very annoying problem.

[jf]

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)?

[Dejan Sarka]

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

Post by jf
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
------
Execution of the managed stored procedure
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)?