DevForce Community Forum : Internal Query Processor Error http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Internal Query Processor Error Sat, 11 Apr 2026 18:48:33 -700 Thu, 30 Sep 2010 15:28:32 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2201 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Internal Query Processor Error : Hi Ryan;Could you show me the... http://www.ideablade.com/forum/forum_posts.asp?TID=2201&PID=8680#8680 Author: DenisK
Subject: 2201
Posted: 30-Sep-2010 at 3:28pm

Hi Ryan;

Could you show me the query that you're trying to do?

Searching online gives me:

This problem occurs if the following conditions are true:
  • The query contains at least one JOIN clause.
  • The query contains one or more subqueries that have no input tables.

Without knowing exactly what you want to do, I can only suggest:

1. Rewrite your queries in such a way that doesn't use the JOIN clause.

2. Follow the suggestion from Microsoft. (Which means you might have to use Stored Procs)
  • Rewrite the query so that the subquery contains at least one input table.
  • Add an OPTION (FORCE ORDER) query hint to the query.
  • Add a join hint to the JOIN clause of the query.

3. Download the hotfix mentioned on the support website. http://support.microsoft.com/kb/931329

Hope this helps.
]]> Thu, 30 Sep 2010 15:28:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2201&PID=8680#8680 Internal Query Processor Error : I'm getting the error "Internal... http://www.ideablade.com/forum/forum_posts.asp?TID=2201&PID=8660#8660 Author: rhaney
Subject: 2201
Posted: 28-Sep-2010 at 12:04pm

I'm getting the error "Internal Query Processor Error: The query processor could not produce a query plan." when saving a particular set of entities.  The entity of which I believe is the offending entity has a persisted computed column.  Some of the information I have read online recommends using "SET ARITHABORT ON" before executing the query.
 
How can I accomplish this with DevForce?
 
Is there a way to do this without using stored procedures or views?
 
Thanks!
]]> Tue, 28 Sep 2010 12:04:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2201&PID=8660#8660