Solved

Sharepoint 3.0 / SQL Errors filling SQL log

Posted on 2010-09-06
6
1,490 Views
Last Modified: 2012-05-10
MS Windows 2003 Server SP2
Member server
WSS 3.0

We are having disk space issues on our sharepoint server as the SQL error log in constantly filling up. The errors in event viewer are:

EVENT ID 10027
Failed to update committed transaction in SQL, DocID is 5983.

Context: Application 'Search index file on the search server', Catalog 'Search'

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

For more information, see Help and Support Center at

EVENT ID 10036
 database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 8630 occurred 1 time(s)
Description: Internal Query Processor Error: The query processor encountered an unexpected error during execution.

Context: Application 'Search index file on the search server'




Any ideas of the cause?

0
Comment
Question by:YellowbusTeam
  • 3
  • 3
6 Comments
 

Author Comment

by:YellowbusTeam
ID: 33610788
This is the directory that is filling up with sql errors and sql dumps:

C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG

0
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 total points
ID: 33616900
Looks to me like it's the indexing service in sharepoint trying to crawl some file shares...  Check the index service in Sharepoint central admin
0
 

Author Comment

by:YellowbusTeam
ID: 33625212
Hi,

Where should i be looking to find the Index Service?

we are also recieving a large amount of .mdmp files in the folder of SharePoint SQL, which in our case is the:
C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\LOG

This is in turn making the C drive fill up and then the server crashes, are all these things related to the same issues?

Ta  
0
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!

 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 500 total points
ID: 33627598
On the sharepoint server, in the central administration site.
0
 

Author Comment

by:YellowbusTeam
ID: 33628248
Hi,

Thanks for that.
We have stopped and then started the Search Service, then created a new database for the serches to use. This in turn has stopped the error from being produced in the event viewer.

Thanks for your Help
0
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 500 total points
ID: 33629122
Excellent - You'll want to double check the search crawling settings to make sure the search credentials are correct etc.  

Search for "Sharepoint search service config" on google and you'll find help for that.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Backup of Sharepoint Online 3 97
Sharepoint 2010 Audit Logs 11 101
2003 File Server upgrade 11 62
Find data in a column which is not in  a date format 29 30
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now