SharePoint By Yagya Shree

Posts Tagged ‘exception

SP2013: Search Error – HRESULT: 0x80131904

leave a comment »


ISSUE:

  • When we are trying to click on “Content Sources” OR “Crawl Logs” in our SharePoint 2013 Search service application. We are getting below error:

0x80131904

 

Troubleshooting:

  • ULS gave us below message on Application server:

ManagedSqlSession caught a SqlException executing the following command: ‘proc_MSS_CrawlAdmin’. Connection string was: ‘Data Source=SQL01\SQL01;Initial Catalog=Search_Admin_01;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15’ Original exception message: ‘A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)’ Stack trace ‘
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Office.Server.Data.SqlSession.OpenConnection()
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.Office.Server.Search.ManagedSqlSession.ExecuteNonQuery()’ SQL Errors: Error ordinal: 1 Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified), Class: 20, Number: -1, State: 0

Resolution:

  • Issue was with one server which was hosting “Admin Component” in which event ID 6482
  • We restarted “SharePoint Server Search 15” on the server
  • All three options under Search administration page started working

 

 

Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Server
Date: 9/12/2016 1:09:04 PM
Event ID: 6482
Task Category: Shared Services
Level: Error
Keywords:
User: contoso/user1
Computer: APP1.contoso.com
Description:
Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (9da9526d-52f0-4ab3-8bb6-7464872bdf04).

Reason: Exception from HRESULT: 0x80131904

Technical Support Details:
System.Runtime.InteropServices.COMException (0x80131904): Exception from HRESULT: 0x80131904
at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()
at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

Written by Yagyashree

September 8, 2016 at 5:34 pm

%d bloggers like this: