New Posts New Posts RSS Feed: Internal Query Processor Error
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Internal Query Processor Error
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
rhaney View Drop Down
Newbie
Newbie


Joined: 06-Jul-2010
Location: Orange, CA
Posts: 12 		Post Options Post Options   Quote rhaney Quote  Post ReplyReply Direct Link To This Post Topic: Internal Query Processor Error
    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!
Back to Top
DenisK View Drop Down
IdeaBlade
IdeaBlade


Joined: 25-Aug-2010
Posts: 715 		Post Options Post Options   Quote DenisK Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down