Internal Query Processor Error Sql Server 2000
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error: 8624 Internal Query Processor Error: The query processor could not produce a internal query processor error: the query processor could not produce a query plan query plan. SQL Server > SQL Server Database Engine Question 0 Sign in internal query processor error the query processor encountered an unexpected to vote SQL Server 2005 9.0.3161 on Win 2k3 R2 I receive the following error: "Error: 8624,
Internal Query Processor Error Sql 2008 R2
Severity: 16, State: 1 Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services." I have traced this to an insert
Internal Query Processor Error 8630
statement that executes as part of a stored procedure. INSERT INTO ledger (journal__id, account__id,account_recv_info__id,amount)
VALUES (@journal_id, @acct_id, @acct_recv_id, @amount) There is also an auto-increment column called id. There are FK contraints on all of the columns ending in "__id". I have found that if I remove the contraint on account__id the procedure will execute without error. None of the other constraints seem query processor could not produce a query plan because of the hints defined in this query to make a difference. Of course I don't want to remove this key because it is important to the database integrity and should not be causing problems, but apparently it confuses the optimizer. Also, the strange thing is that I can get the procedure to execute without error when I run it directly through management studio, but I receive the error when executing from .NET code or anything using ODBC (Access). Thursday, May 24, 2007 9:48 PM Reply | Quote Answers 1 Sign in to vote I consulted tech support. It was finally classified as a bug. The database was in 80 compatibility and changing it to 90 made the problem go away. The other work around was to set arithabort on. This explained why it worked from management studio and not anywhere else. Apparently management studio has arithabort set to on by default. The following is the case closure confirmation from the MS engineer: PROBLEM: ======= An insert query to a table that has foreign key references cannot generate a plan with error 8624 when arithabort is set to be off. Server: Msg 8624, Level 16, State 1, LineThis item appears to be a duplicate of another existing Connect or internal item. A more detailed explanation for the resolution of this particular item may have been provided in the comments section. 14 0 Sign into vote ID 332815 Comments 10 Status Resolved Workarounds 0 Type Bug Repros 4 Opened 3/12/2008 5:21:14 PM Access Restriction Public Description When doing a simple insert statement we are getting the "Internal Query Processor Error: The query processor could not produce a query plan." error. We are running build 3042. DETAILS ATTACH A FILE EDIT THIS ITEM Assign https://social.msdn.microsoft.com/Forums/sqlserver/en-US/59c0e1e0-741d-48c9-9eaf-38b5cc1f57d3/error-8624-internal-query-processor-error-the-query-processor-could-not-produce-a-query-plan?forum=sqldatabaseengine To Item can only be reassigned when it is active. Comments (10) | Workarounds (0) | Attachments (2) Sign in to post a comment. Please enter a comment. Submit Posted by mrdenny on 8/16/2010 at 3:50 PM Can we get this one listed as a duplicate of 228950 so that it shows up as a child of it when that one is brought up.Also is there any https://connect.microsoft.com/SQLServer/feedback/details/332815/internal-query-processor-error-the-query-processor-could-not-produce-a-query-plan status update on either? The other item hasn't had an update since 2006. Posted by David Morrissey on 12/22/2009 at 2:31 PM I am working in SQL 2008 and got the same error:"Msg 8624, Level 16, State 1, Line 13Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services."I tried your recommended "set" workarounds and got the same results:set ANSI_NULLS ONset ANSI_PADDING ONset ANSI_WARNINGS ONset CONCAT_NULL_YIELDS_NULL ONset NUMERIC_ROUNDABORT OFFset QUOTED_IDENTIFIER ONset ARITHABORT ONdeclare @D datetime, @I uniqueidentifier, @A uniqueidentifier, @E uniqueidentifierset @D = getdate()set @I = newid()set @A = newid()set @E = newid()INSERT INTO [msHR].[dbo].[Permission] ([PermissionID] ,[CreatedOn] ,[CreatedByID] ,[ModifiedOn] ,[ModifiedByID] ,[EmployeeID] ,[ObjectID] ,[ObjectTypeID] ,[PermissionTypeID] ,[RoleID] ,[ActiveOn] ,[ExpiresOn] ,[SecurityGroupID] ,[StateCodeID] ,[Recurse]) VALUES (@I ,@D ,@A ,@D ,@A ,@E ,null ,null ,465 ,null ,@D ,null ,null ,1 ,0)Here are the details of my environment:Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)Microsoft MSXML2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer7.0.5730.13Microsoft .NET Framework2.0.50727.3603Operating System5.1.2600 Posted by Microsoft on 3/13/2009 at 5:10 PM Thank you for taking the time to report this issue.This sounds like a duplicate of an issue we ar
Product Activation +Application Usage TechNotes and FAQs +Product Activation TechNotes and FAQs +Recommendation Engine -SELECTserver TechNotes and FAQs "An Error Has Occurred" when manually transmitting usage logs using a preconfigured http://communities.bentley.com/products/licensing/w/licensing__wiki/4865 URL About SELECTserver Connecting to the Bentley servers through Firewalls and Proxy Servers [FAQ] Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...' Data Update Service Warning [TN] Database Maintenance Database Setup Tool Configuration and Explanation [FAQ] Deployed SELECTserver Database and Internet Connectivity Insight [TN] Deployed SELECTserver issue with new Bentley SSL certificate Deployed SELECTserver Knowledge Requirements [TN] Deployed SELECTserver Technical Requirements [TN] Enabling Diagnostic query processor Logging for SELECTserver Error 1068: Cannot start the Bentley SELECTserver service Error 417 : in SELECTserver and GateWay logs Glossary Of Licensing Terms [FAQ] Group Policy Administration (ADM) files How do I keep usage reports current? How do I set up or prevent license checkouts? How to create a new website in IIS7 How to create a Virtual Directory in IIS7 How To Install internal query processor a Gateways on Vista and Windows 7, Server 2008 How to Install the SELECTserver application How to migrate users to a custom activation group HTTP Error 404.13 "The request filtering module is configured to deny a request that exceeds the request content length" when importing response file HTTP Error 500.21 - Internal Server Error on SELECTserver Administrative Site Import xml File on Deployed Server IP Address Hosted Server License and SELECTserver Administration [FAQ] License Tool Command Line Options Manual Installation of SQL Express (2008 - 2012) Moving (relocating) the SELECTserver application to a new server. Moving Your SELECTserver Database +Older SELECTserver Versions Opening Admin site pager starts (runs) installer process Opening Administration Site Restricting access to a deployed SELECTserver Administration Site. Configuration example (video). Running the Data Update Service and restarting IIS in order to immediately update a deployed license Schedule Report - no Parameter selectable Security [FAQ] SELECT Server 08 11 Series [CS] +SELECTserver SELECTserver 9 Known Issues SELECTserver 9.xx.xx.xx Gateway Update Process [FAQ] SELECTserver 9.xx.xx.xx Upgrade Information [FAQ] SelectServer Client Access Restrictions technical overview (video). SELECTserver Database Backup [TN] +SELECTserver Gateway SELECTserver Gateway error 1053 SELECTserver Gateway Explained SELEC