Solved

Unable to search on Sharepoint portal

Posted on 2013-06-30
3
798 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 48

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2010 Versioning 2 57
SharePoint Custom List 2010 Limitation? 1 45
SharePoint 2013 Table Moves 3 28
How to share an InfoPath Form on-line 2 21
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 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