Server: Msg 8623 - The query processor could not produce a query p

11 Sep 2006 9:51 PM

Andy

Dear all,
We get the following error *periodically* on our site...

Server: Msg 8623, Level 16, State 1, Line 8
Internal Query Processor Error: The query processor could not produce a
query plan. Contact your primary support provider for more information.

When it occurs it happens all the time, until the error stops (if you see
what I mean). The duration of the error period may be a few minutes, or about
3 hours like this afternon.

I've cut a query down and can reproduce the error (when it occurs!) with the
following code. NB If the Insert line is omitted, the error does NOT occur..

declare @search varchar(100)
set   @search = N'"Jaws*"'
DECLARE @GUID UniqueIdentifier
SET @GUID = NewID()
-- Inserting matches from book titles
INSERT INTO SearchResults (GUID, titleid, theRank, theType) --!!!
SELECT @GUID, [KEY], RANK, 'Title' as type FROM
CONTAINSTABLE(WebTitles,title,@search)
DELETE FROM SearchResults WHERE GUID = @GUID

If anyone has any ideas, I'm all ears. I've googled quite alot but to no
avail.

*Many* thanks in advance.
Andy

NB, table definition...
CREATE TABLE [SearchResults] (
    [PK_SearchResults] [int] IDENTITY (1, 1) NOT NULL ,
    [GUID] [uniqueidentifier] NULL ,
    [TitleID] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
    [theRank] [int] NULL ,
    [theType] [varchar] (8) COLLATE Latin1_General_CI_AS NULL ,
    [cntTitleId] [int] NULL ,
    PRIMARY KEY CLUSTERED
    (
        [PK_SearchResults]
    ) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO

12 Sep 2006 7:43 AM

ML

How many users are accessing the SearchResults table?

Try indexing the GUID column.

Also try including the WebTitles table when retrieving from CONTAINSTABLE
(this is not required, but I'm interested in results).

ML

---
http://milambda.blogspot.com/

13 Sep 2006 3:42 AM

Leo Giakoumakis [MS]

Andy,

This is most likely a server bug. Please contact product support.

Regards,

Leo

Show quoteHide quote

"Andy" <A***@discussions.microsoft.com> wrote in message
news:B72638C0-4F6F-496C-97C0-68CC868F2E80@microsoft.com...
> Dear all,
> We get the following error *periodically* on our site...
>
> Server: Msg 8623, Level 16, State 1, Line 8
> Internal Query Processor Error: The query processor could not produce a
> query plan. Contact your primary support provider for more information.
>
> When it occurs it happens all the time, until the error stops (if you see
> what I mean). The duration of the error period may be a few minutes, or
> about
> 3 hours like this afternon.
>
> I've cut a query down and can reproduce the error (when it occurs!) with
> the
> following code. NB If the Insert line is omitted, the error does NOT
> occur..
>
> declare @search varchar(100)
> set @search = N'"Jaws*"'
> DECLARE @GUID UniqueIdentifier
> SET @GUID = NewID()
> -- Inserting matches from book titles
> INSERT INTO SearchResults (GUID, titleid, theRank, theType) --!!!
> SELECT @GUID, [KEY], RANK, 'Title' as type FROM
> CONTAINSTABLE(WebTitles,title,@search)
> DELETE FROM SearchResults WHERE GUID = @GUID
>
> If anyone has any ideas, I'm all ears. I've googled quite alot but to no
> avail.
>
> *Many* thanks in advance.
> Andy
>
> NB, table definition...
> CREATE TABLE [SearchResults] (
> [PK_SearchResults] [int] IDENTITY (1, 1) NOT NULL ,
> [GUID] [uniqueidentifier] NULL ,
> [TitleID] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
> [theRank] [int] NULL ,
> [theType] [varchar] (8) COLLATE Latin1_General_CI_AS NULL ,
> [cntTitleId] [int] NULL ,
> PRIMARY KEY CLUSTERED
> (
> [PK_SearchResults]
> ) WITH FILLFACTOR = 90 ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>