Search is busted, can't index PDFs, fullcrawlstart too?

[Guest]

Howdy,

A brief history. Customer running SBS 2003, I upgraded them to WSS3 by
installing along side WSS2, moved the DB over and everything has been working
great for the last month. Users could search and get PDFs back and
everything.

All of a sudden, PDF search stopped working. I uninstalled the iFilter and
Adobe Reader 6 and installed Adobe 8 (has iFilter included) and added the
string 38/pdf to the registry as needed. I uploaded a new PDF and would get
the following error:

Unexpected query execution failure, error code 266. Additional error
information from SQL Server is included below. "Transaction count after
EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.
Previous count = 0, current count = 1." Query text (if available): "DECLARE
@@S uniqueidentifier; DECLARE @@DocId uniqueidentifier; DECLARE @@Level
tinyint; DECLARE @@DocUIVersion int; DECLARE @@DoclibRowId int; DECLARE
@@iRet int;DECLARE @DN nvarchar(256); DECLARE @LN nvarchar(128); DECLARE @FU
nvarchar(260); SET @@Level=1 SET @@DocUIVersion =512 SET
@@DocId='D65FE3B9-A173-4BC0-879A-49AFC2E5827C' SET
@@S='7C9C73CC-700F-45AF-961F-3D91DDF49D62' SET
@DN=N'patrol/Lists/Announcements/Attachments/17'; SET @LN=N'Clearing Download
Flag.camrec';BEGIN TRAN; EXEC @@iRet = proc_AddDocument
'7C9C73CC-700F-45AF-961F-3D91DDF49D62','2723D93F-187E-42CF-BE27-55AD76A97574',4,NULL,@DN,
@LN OUTPUT, @@Level, @@DocUIVersion,
@@DocId,'2E5E7091-C6B0-495A-8AF8-A43D7BF7F08D',@@DoclibRowId,?,?,17012752,104,0,0,320,NULL,NULL,0,2577,16,0,0,-2,NULL,1,NULL,NULL,NULL,NULL,NULL,?
OUTPUT,0,?,? OUTPUT; SET @FU = dbo.fn_GetFullUrl(@DN, @LN); IF @@iRet <> 0
GOTO done; EXEC proc_DirtyDependents @@S,1,@FU; done: IF @@iRet=0 BEGIN EXEC
proc_GetLinkInfoSingleDoc @@S,@DN,@LN,@@Level; END ELSE ROLLBACK; SET
?=@@iRet;

Yeah, real nice. I did some basic searching on it and didn't find much so i
removed the search database and created a new one. And now this is where it
all goes in a handbasket:

- When I upload PDFs, i get the above error still.
- I add new list items and they are not returning in search results at all.
- Looking in Central Admin, Timer Job Sstatus, the SharePoint Services
Search Refresh is succeeding everytime it runs.
- When I run stsadm -o spsearch -action fullcrawlstart, the processor get's
pinned by msssearch, w3wp and mssdmn alternating, for about 2 minutes.
Appears to be running but nothing is returned in the search results.

A few more items

- the search service is using a user account that has full sysadmin rights
to SQL
- after running the above, the new search DB is only 30MB while the old one
is 220MB, which makes sense. The WSS DB is about 2GB.

This is rather urgent. about 100 users and their primary use for this app is
to share information and search against history. At least they can keep
uploading but searching is not working at all.

Thanks in advance!

 

[Mark Fitzpatrick]

David,
You may also want to post this into the IIS newsgroups. They're over at
microsoft.public.inetserver and there's a bunch of them including an
indexserver newsgroup. You may also want to post into the sharepoint server
NGs as well. This NG may not be the best for this sort of issue.

 

[Guest]

Howdy,

A brief history. Customer running SBS 2003, I upgraded them to WSS3 by
installing along side WSS2, moved the DB over and everything has been working
great for the last month. Users could search and get PDFs back and
everything.

All of a sudden, PDF search stopped working. I uninstalled the iFilter and
Adobe Reader 6 and installed Adobe 8 (has iFilter included) and added the
string 38/pdf to the registry as needed. I uploaded a new PDF and would get
the following error:

Unexpected query execution failure, error code 266. Additional error
information from SQL Server is included below. "Transaction count after
EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.
Previous count = 0, current count = 1." Query text (if available): "DECLARE
@@S uniqueidentifier; DECLARE @@DocId uniqueidentifier; DECLARE @@Level
tinyint; DECLARE @@DocUIVersion int; DECLARE @@DoclibRowId int; DECLARE
@@iRet int;DECLARE @DN nvarchar(256); DECLARE @LN nvarchar(128); DECLARE @FU
nvarchar(260); SET @@Level=1 SET @@DocUIVersion =512 SET
@@DocId='D65FE3B9-A173-4BC0-879A-49AFC2E5827C' SET
@@S='7C9C73CC-700F-45AF-961F-3D91DDF49D62' SET
@DN=N'patrol/Lists/Announcements/Attachments/17'; SET @LN=N'Clearing Download
Flag.camrec';BEGIN TRAN; EXEC @@iRet = proc_AddDocument
'7C9C73CC-700F-45AF-961F-3D91DDF49D62','2723D93F-187E-42CF-BE27-55AD76A9757­4',4,NULL,@DN,
@LN OUTPUT, @@Level, @@DocUIVersion,
@@DocId,'2E5E7091-C6B0-495A-8AF8-A43D7BF7F08D',@@DoclibRowId,?,?,17012752,1­04,0,0,320,NULL,NULL,0,2577,16,0,0,-2,NULL,1,NULL,NULL,NULL,NULL,NULL,?
OUTPUT,0,?,? OUTPUT; SET @FU = dbo.fn_GetFullUrl(@DN, @LN); IF @@iRet <> 0
GOTO done; EXEC proc_DirtyDependents @@S,1,@FU; done: IF @@iRet=0 BEGIN EXEC
proc_GetLinkInfoSingleDoc @@S,@DN,@LN,@@Level; END ELSE ROLLBACK; SET
?=@@iRet;

Yeah, real nice. I did some basic searching on it and didn't find much so i
removed the search database and created a new one. And now this is where it
all goes in a handbasket:

- When I upload PDFs, i get the above error still.
- I add new list items and they are not returning in search results at all.
- Looking in Central Admin, Timer Job Sstatus, the SharePoint Services
Search Refresh is succeeding everytime it runs.
- When I run stsadm -o spsearch -action fullcrawlstart, the processor get's
pinned by msssearch, w3wp and mssdmn alternating, for about 2 minutes.
Appears to be running but nothing is returned in the search results.

A few more items

- the search service is using a user account that has full sysadmin rights
to SQL
- after running the above, the new search DB is only 30MB while the old one
is 220MB, which makes sense. The WSS DB is about 2GB.

This is rather urgent. about 100 users and their primary use for this app is
to share information and search against history. At least they can keep
uploading but searching is not working at all.

Thanks in advance!

I think it's a problem of SBS 2003, because upload a file has nothing
to do with IFilter and full-text crawling

 

[LVP]

this will not help, Here it is anyway.
Upgrades of Adobe at times manifests old problems it happened to me once.
Could be due to bad PDF Docs ( even they open ) or bad upgrade.

 

[Guest]

Ah poop. Wrong newsgroup. I'll repost.

Thanks,

--
David Lozzi
Delphi Technology Solutions
Blog: www.lozzi.net

David,
You may also want to post this into the IIS newsgroups. They're over at
microsoft.public.inetserver and there's a bunch of them including an
indexserver newsgroup. You may also want to post into the sharepoint server
NGs as well. This NG may not be the best for this sort of issue.