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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ah poop. Wrong newsgroup. I'll repost.

Thanks,

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


"Mark Fitzpatrick" wrote:

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.

--

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:81D54A81-6E3B-4FA2-9B5E-C9F1DD2D3378@xxxxxxxxxxxxxxxx
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!

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



.

Relevant Pages

  • Re: Migrating ASP/MSSQL app from IIS 4 to IIS 6
    ... > declare @P1 int ... >> Use SQL Profiler to verify that the commad text you expect to be ... >> a quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Search is busted, cant index PDFs, fullcrawlstart too?
    ... installing along side WSS2, moved the DB over and everything has been working ... @@S uniqueidentifier; DECLARE @@DocId uniqueidentifier; DECLARE @@Level ... When I upload PDFs, i get the above error still. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Refactoring/Optimizing code
    ... do I get rid of the "avoid unused private fields" notification ... This is a Visual Basic newsgroup, of which VB6 is the latest version. ... In VB6 you need to specifically declare the variable type for each declaration and the above code would declare sHGBvalue as a Variant (the default data type), since its type is not specified, and sHGBdate as a string. ...
    (microsoft.public.vb.general.discussion)
  • Search is busted, cant index PDFs, fullcrawlstart too?
    ... tinyint; DECLARE @@DocUIVersion int; DECLARE @@DoclibRowId int; DECLARE ... When I upload PDFs, i get the above error still. ... to share information and search against history. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Search is busted, cant index PDFs, fullcrawlstart too?
    ... You may also want to post this into the IIS newsgroups. ... "DECLARE ... When I upload PDFs, i get the above error still. ...
    (microsoft.public.dotnet.framework.aspnet)