August 28, 2002 at 3:53 pm
Greetings,
One of my customers is getting an error which states:
'Internal Query Processor Error: The query processor could not obtain access to a required interface.'
The error # is 8601.
Does anyone know what this is?
SB
August 28, 2002 at 4:49 pm
I have not seen this and no where has anyone else came across. If the error is repeatable and the customer knows the steps the best thing to do is use Profiler to catch the actions occurring that lead up to the error. If this is an inhouse developed app may be the customer is doing something no one anticipated and you need to fix. If is a major error may have written information to the Event Viewer logs or SQL Server logs, check both.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 28, 2002 at 4:58 pm
As Antares pointed out, if you can fire up Profiler to catch the query throwing the exception, that would be a big help. There are quite a few articles in the Microsoft KB dealing with "internal query processor error" but the error code is usually 8621 and up. Is 8601 the correct error #?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 21, 2016 at 5:08 pm
It might possible the table is having column store index and user is trying to do operations i.e. insert, update or delete. In that case this error can happen.
Solution in this regards: Drop column store index, complete the operations then recreate the column store index.
June 22, 2016 at 1:05 am
saimsaboor (6/21/2016)
It might possible the table is having column store index and user is trying to do operations i.e. insert, update or delete. In that case this error can happen.Solution in this regards: Drop column store index, complete the operations then recreate the column store index.
He is having SQL Server 2000
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply