New Posts New Posts RSS Feed: Error: expression is more than 8000 chars long
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Error: expression is more than 8000 chars long

 Post Reply Post Reply
Author
ngoel View Drop Down
Newbie
Newbie


Joined: 17-Nov-2009
Posts: 15
Post Options Post Options   Quote ngoel Quote  Post ReplyReply Direct Link To This Post Topic: Error: expression is more than 8000 chars long
    Posted: 09-Oct-2011 at 5:32pm

We are runnning Ideablade Version: 3.6.4.1 and getting the error:

{"Unable to construct in-memory query expression - expression is more than 8000 chars long. Please try to restrict the size of this query expression"}

 
The error is happening with only some of the queries irrespective of query length. We manage to run a query with over 100, 000 character with no problem where as other queries with abt 30000 characters return with the above mentioned error.
 
There is no problem with the queries as these queries run with SQL Management studio and return the correct data.
 
Can you please let us know what causes this error and if there is a fix for this?
 
Thanks
Nitin
 
 
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1390
Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 10-Oct-2011 at 1:42pm
The error comes when trying to run the query against cache using the DataTable.Select method.   This method does not have a hard ceiling of 8000 characters but does have a limitation as to query complexity, which DevForce for somewhat obscure reasons chose to interpet as an 8000 character limitation.  The character count does not include subqueries, which is why you may see larger queries work successfully.
 
This problem was "alleviated" in the DevForce 3.6.6 release so that the cache query check is not made when the QueryStategy is DataSourceOnly.   Unfortunately the only workaround in earlier releases is to modify the query to suit the limitation.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down