Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

trouble with viewing lift chart

  
   Database Help (Home) -> Datamining RSS
Next:  Clustering wrong results in SQL 2005  
Author Message
jesse.farmer

External


Since: Feb 05, 2008
Posts: 1



(Msg. 1) Posted: Tue Feb 05, 2008 9:26 am
Post subject: trouble with viewing lift chart
Archived from groups: microsoft>public>sqlserver>datamining (more info?)
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.

 >> Stay informed about: trouble with viewing lift chart 
Back to top
Login to vote
Dejan Sarka

External


Since: Mar 18, 2004
Posts: 103



(Msg. 2) Posted: Mon Feb 11, 2008 8:03 am
Post subject: Re: trouble with viewing lift chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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

wrote in message

> 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.

 >> Stay informed about: trouble with viewing lift chart 
Back to top
Login to vote
jf

External


Since: Feb 21, 2008
Posts: 1



(Msg. 3) Posted: Thu Feb 21, 2008 5:50 am
Post subject: Re: trouble with viewing lift chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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)?
 >> Stay informed about: trouble with viewing lift chart 
Back to top
Login to vote
Dejan Sarka

External


Since: Mar 18, 2004
Posts: 103



(Msg. 4) Posted: Fri Feb 29, 2008 7:52 am
Post subject: Re: trouble with viewing lift chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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. -Cool 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" wrote in message

> 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)?
 >> Stay informed about: trouble with viewing lift chart 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....

Update serial number in database - Hi, I want to update specific fields in a existing table in SQL database as below example: L240100001-LG L240100002-LG *serial number is difficult to update one by one L240100003-LG L240100004-LG L240100005-LG change to L240100001-L L240100002-L..

Newbie question - I have SQL Server 2000. What add-ons do I need to try data mining, and where do I best go for resources/references?
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]