?
Solved

Unable to search on Sharepoint portal

Posted on 2013-06-30
3
Medium Priority
?
832 Views
Last Modified: 2013-07-12
Hi,

I have MOSS 2007 SP3 installed on a single server farm with the SQL database installed on another server. For some reason, the search function stopped returning any results since last week. From the event log, we can see the below error being generated constantly:
Event Type:      Error
Event Source:      Office Server Search
Event Category:      Gatherer
Event ID:      10027
Date:            30.06.2013
Time:            13:59:39
User:            N/A
Computer:      SPT-DC01
Description:
Failed to update committed transaction in SQL, DocID is 3.

Details:
      One or more errors occurred during processing of command.   (0x80040e14)

We tried resetting the crawl index and restarting it using the below steps but it still does not work:
1. Open Central Administration on the SharePoint Server.
2. Click the Shared Service Provider's name on the left hand side.
3. Within the Shared Service Provider's page there is a link called "Search settings". It is under a blue bar title called Search.
4. On the Search Settings page click the "Reset all crawled content" link. It is the 10th bullet down in the "Crawl Settings" section .
5. Select the Reset Now button on the Reset Crawled Content page.
That should result in the "Items in index" to be set to 0.
The next step is to perform a full crawl on your content source(s).
1. Open Central Administration on the SharePoint Server.
2. Click the Shared Service Provider's name on the left hand side.
3. Within the Shared Service Provider's page there is a link called "Search settings". It is under a blue bar title called Search.
4. On the Search Settings pas click the "Content sources and crawl schedules" link. It is the first bullet down in the "Crawl Settings" section.
5.Select the content source you wish to crawl.
6. At the bottom of the content source's page there is a checkbox with the words "Start full crawl of this content source". Check this box and select OK.
Context: Application 'SharedServices001', Catalog 'Portal_Content'

Any clue as to what could be the issue here?

Thanks in advance!
Bejesh
0
Comment
Question by:JYBejesh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39288877
Could be related to your backup (?)
This can happen due to VERITAS backup software that we have.
• It has been documented on Symantec site.

Solution:

• To resolve this issue we have to either reboot the server or upgrade to latest backup edition of VERITAS.
• You can get more information on :
o http://support.veritas.com/docs/294181
http://sharepointsb.blogspot.com.au/
that veritas page is now:
http://www.symantec.com/business/support/index?page=content&id=TECH55559
0
 

Accepted Solution

by:
JYBejesh earned 0 total points
ID: 39306451
Have found the solution. It was due to some windows updates that were installed. I had to install MOSS 2007 service pack 3 and it resolved the issue.
0
 

Author Closing Comment

by:JYBejesh
ID: 39320165
It was the solution that was required.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question