Print Page | Close Window

Internal Query Processor Error

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2201
Printed Date: 03-Feb-2026 at 11:20am


Topic: Internal Query Processor Error
Posted By: rhaney
Subject: Internal Query Processor Error
Date 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!


Replies:
Posted By: DenisK
Date 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 - http://support.microsoft.com/kb/931329

Hope this helps.


Print Page | Close Window