Error 8624 Severity 16
Contents |
360 games PC games internal query processor error sql 2008 r2 Windows games Windows phone games Entertainment All Entertainment
Internal Query Processor Error The Query Processor Encountered An Unexpected Error During Execution
Movies & TV Music Business & Education Business Students & educators query processor could not produce a query plan because of the hints defined in this query Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 query plan. SQL Server > SQL Server Database Engine Question 0 Sign in to vote SQL Server 2005 9.0.3161 on Win 2k3 R2 I receive the following error: "Error: 8624, Severity: 16, State: https://support.microsoft.com/en-us/kb/977450 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 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) 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 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 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 changwith a work or school account from your organization can view it. Report abuse How does this content violate the Docs.com Terms of Use? Threats, cyberbullying, harassment More information Harassment is any behavior https://docs.com/microsoft-suppo/6917 intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Child endangerment or exploitation More information Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Offensive content More information Any content of an adult theme, inappropriate, or offensive. Virus / spyware / malware More information Any link to or advocacy query processor of virus, spyware, malware, or phishing sites. Content infringement More information Any behavior that appears to violate your intellectual property. Other More information Any other inappropriate content or behavior as defined by the Terms of Use. Comments (required) Please provide as much detail as possible about the abuse or offensive behavior you are reporting. Include a contact email address so we can ask for more information if needed. privacy statement Sign internal query processor In What email address or phone number would you like to use to sign in to Docs.com? If you already have an account that you use with Office or other Microsoft services, enter it here. Remember me Or sign in with: Signing in allows you to download and like content, which the author will be aware of. Docs.com PublishSign in Outlook.com People Calendar OneDrive Word Online Excel Online PowerPoint Online OneNote Online Sway Docs.com Office Online Embed code for: Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan. - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs Copy Select a size Microsoft Support Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan. - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs Likes 0 Views 13 Show less Show more Show less Show more Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server Management Studio:--------------------------------------------------------------Error: 8624, Severity: 16, State: 116.Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.--------------------------------------------------