Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm having problems with a MOSS setup that after an incremental crawl, the search results will get corrupted. Troubleshooting it further using the search web service, the resulting XML looks like this:

 <ResponsePacket xmlns="urn:Microsoft.Search.Response">
  <Response domain="QDomain">
  <Range>
    <StartAt>1</StartAt> 
    <Count>20</Count> 
    <TotalAvailable>34</TotalAvailable> 
    <Results>
      <Document xmlns="urn:Microsoft.Search.Response.Document">
        <Action>
          <LinkUrl /> 
        </Action>
        <Properties xmlns="urn:Microsoft.Search.Response.Document.Document">
          <Property>
            <Name>RANK</Name> 
            <Type>Int64</Type> 
            <Value>1000</Value> 
          </Property>
        </Properties>
      </Document>
      <Document xmlns="urn:Microsoft.Search.Response.Document">
        <Action>
          <LinkUrl /> 
        </Action>
        <Properties xmlns="urn:Microsoft.Search.Response.Document.Document">
          <Property>
          <Name>RANK</Name> 
          <Type>Int64</Type> 
          <Value>1000</Value> 
        </Property>
      </Properties>
    </Document>
...
...
...
...
...

    </Results>
  </Range>
  <Status>SUCCESS</Status> 
  </Response>
</ResponsePacket>

In other word, it says it can find 34 hits, but returns blank data. Doing a reset of the search content, a full crawl, everything works for a day or so, then it gets corrupted again. Full crawl at 02:00, incremental crawl every 20 minutes, MOSS v12.0.0.6300 on Win2003 x86. The crawl log files says nothing of interest.

Anyone has any ideas?

share|improve this question
    
Have you checked the Event Log on the index server? –  MattB Jun 17 '09 at 15:11

2 Answers 2

up vote 1 down vote accepted

So, it seems that I have found the solution, or a fix. A little bird whispered in my ear to apply the latest MOSS Service Pack, which I did.

Now the site(s) has been running for over 20 days without any search corruptions, so I can almost certainly say that SP2 fixed the issue.

share|improve this answer

It could be corruption in the underlying SQL Server search database (most likely caused by I/O subsystem issues). Try running the following SQL Server command on the search database - if it gives any results, you have corruption problems (post the results and I can interpret them for you - I wrote DBCC CHECKDB).

DBCC CHECKDB (searchdbname) WITH ALL_ERRORMSGS, NO_INFOMSGS

Hope this helps (and isn't your problem :-)

share|improve this answer
    
Hi Paul. Well, this has now been identified on two completely isolated separate configurations, so I would be very, very surprised if this is a DB corruption error. (Love your blogs and podcast appearances BTW). I'm more into some type of SharePoint issue. –  Magnus Jun 24 '09 at 15:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.