"Query is too Complex"

[Starbuck]

OK, first let me say that I am no DB person.

But I have a user here who keeps getting this error
whenever she does, whatever it is she does, with
databases...

A google search takes me to various forums where
I am forced to sign up before I can read any answers.

Interesting note here is that the guy in the office next
to her can run this same query without any problems.

So, can this be a hardware issue?
If I threw more RAM at this problem would that do?

Or is this strickly a coding issue?
Why would one machine run this query ok, yet another
machine generates this error?

Any pointers that you guys could throw my way would
be greatly appreciated.
Thanks

*$

[Gert-Jan Strik]

Re: "Query is too Complex"

Starbuck,

I am afraid you haven't provided enough information to be of help. What
error is she getting? What statement is she running? etc.

By the way, you can search the archive of the public Microsoft
SQL-Server forums on Google (without registration). Have a look at

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver

Hope this helps,
Gert-Jan


Starbuck wrote:[color=blue]
>
> OK, first let me say that I am no DB person.
>
> But I have a user here who keeps getting this error
> whenever she does, whatever it is she does, with
> databases...
>
> A google search takes me to various forums where
> I am forced to sign up before I can read any answers.
>
> Interesting note here is that the guy in the office next
> to her can run this same query without any problems.
>
> So, can this be a hardware issue?
> If I threw more RAM at this problem would that do?
>
> Or is this strickly a coding issue?
> Why would one machine run this query ok, yet another
> machine generates this error?
>
> Any pointers that you guys could throw my way would
> be greatly appreciated.
> Thanks
>
> *$[/color]

--
(Please reply only to the newsgroup)

[Starbuck]

Re: "Query is too Complex"

The error message is "Query is too complex".

The Query that is being run combines 2 tables into
a table query. There is only one join.

The issue seems to be that this query runs on another
machine just fine... They have similar hardware,
and software, but it fails with a "Query is too complex"
error on her machine.

We dont feel that this is in fact a "complex" query.

Point is, I need this to run on her machine, but I am
unable to determine what the differences are.

Could this be a connection issue?

I'm really shooting in the dark here, so any suggestions
are greatly appreciated.

thanks again.
*$


On Thu, 05 Aug 2004 19:43:08 +0200, Gert-Jan Strik
<sorry@toomuchs pamalready.nl> wrote:
[color=blue]
>Starbuck,
>
>I am afraid you haven't provided enough information to be of help. What
>error is she getting? What statement is she running? etc.
>
>By the way, you can search the archive of the public Microsoft
>SQL-Server forums on Google (without registration). Have a look at
>http://groups.google.com/groups?hl=e...blic.sqlserver
>
>Hope this helps,
>Gert-Jan
>
>
>Starbuck wrote:[color=green]
>>
>> OK, first let me say that I am no DB person.
>>
>> But I have a user here who keeps getting this error
>> whenever she does, whatever it is she does, with
>> databases...
>>
>> A google search takes me to various forums where
>> I am forced to sign up before I can read any answers.
>>
>> Interesting note here is that the guy in the office next
>> to her can run this same query without any problems.
>>
>> So, can this be a hardware issue?
>> If I threw more RAM at this problem would that do?
>>
>> Or is this strickly a coding issue?
>> Why would one machine run this query ok, yet another
>> machine generates this error?
>>
>> Any pointers that you guys could throw my way would
>> be greatly appreciated.
>> Thanks
>>
>> *$[/color][/color]

[Erland Sommarskog]

Re: &quot;Query is too Complex&quot;

Starbuck (Starbuck@Bogus Domain.com) writes:[color=blue]
> The error message is "Query is too complex".
>
> The Query that is being run combines 2 tables into
> a table query. There is only one join.
>
> The issue seems to be that this query runs on another
> machine just fine... They have similar hardware,
> and software, but it fails with a "Query is too complex"
> error on her machine.
>
> We dont feel that this is in fact a "complex" query.
>
> Point is, I need this to run on her machine, but I am
> unable to determine what the differences are.
>
> Could this be a connection issue?
>
> I'm really shooting in the dark here, so any suggestions
> are greatly appreciated.[/color]

If you are in the dark, guess how dark we are in, who don't even know
what environment you are using, or how the query looks like.

That much I can tell, that the message "Query is too complex" does not
appear in master..sysmess ages, so it is not likely to be a message from
SQL Server. To be able to assist further we need to see the query,
we need to know what environment the user gets this error in, and we
need to know which database engine you are working with. (It should be
MS SQL Server, else you are posting to the wrong newsgroup.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Simon Hayes]

Re: &quot;Query is too Complex&quot;


"Starbuck" <Starbuck@Bogus Domain.com> wrote in message
news:spk4h0t52b f29a93mcpvbb1pj s7sa3hqk5@4ax.c om...[color=blue]
> OK, first let me say that I am no DB person.
>
> But I have a user here who keeps getting this error
> whenever she does, whatever it is she does, with
> databases...
>
> A google search takes me to various forums where
> I am forced to sign up before I can read any answers.
>
> Interesting note here is that the guy in the office next
> to her can run this same query without any problems.
>
> So, can this be a hardware issue?
> If I threw more RAM at this problem would that do?
>
> Or is this strickly a coding issue?
> Why would one machine run this query ok, yet another
> machine generates this error?
>
> Any pointers that you guys could throw my way would
> be greatly appreciated.
> Thanks
>
> *$[/color]

I've never heard of this error before - as Erland pointed out, this is not a
native MSSQL error - however some Googling suggests that it is likely to be
either an MS Access issue, or something related to some very old data access
components (the most recent exact hit for this error in Google newsgroups is
in the year 2000). For example:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q103/4/29.asp&NoWebContent=1

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q125/7/67.ASP&NoWebContent=1

http://www.dotnet247.com/247reference/msgs/43/216266.aspx

http://www.google.com/search?sourceid=navclient&ie=UTF-8&oe=UTF-8&q=query+too+complex

Without more information, however, it's very difficult for anyone to give
any good advice. What is the database (Access, MSSQL), what is the client
(Access, in-house app, third-party app), what are the operating systems, the
servicepacks, how is the query submitted, what is the definition of the
query and tables, what difference is there between the workstations where
the query works and does not (OS, hardware) etc.

My best guess is that you are querying an MS Access database, and the "guy
in the next office" has a more recent Windows version than the user with the
error (and therefore more recent data access components), but that's purely
speculation and very likely to be wrong. If you're not using MSSQL, then as
Erland said, you will get a better response in a forum dedicated to your
database platform.

Simon