SharePoint 2016: Microsoft SharePoint Foundation Administration missing

SharePoint 2016: Microsoft SharePoint Foundation Administration missing

PS C:\Users\2016spadmin> Start-SPService -Identity “Microsoft SharePoint Foundation Administration”
Start-SPService : Cannot start or stop the service ‘Microsoft SharePoint Foundation Administration’. It is a system
service.
At line:1 char:1
+ Start-SPService -Identity “Microsoft SharePoint Foundation Administra …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Start-SPService], InvalidOperationException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletStartService

SP2013: Find All search crawl Property

Requirement:

How to find all search crawl property in a TEXT or EXCEL file for a specific site collection using PowerShell

 

Resolution:

1st Phase:

Find the GUID for site collection by running below script from Windows PowerShell ISE on any of the sharepoint servers in farm.

Add-PSSnapin “Microsoft.SharePoint.PowerShell”
$site = Get-SPSite https://sharepoint.contoso.com/sites/SP2013
$siteguid = $site.id
echo $siteguid

2nd Phase

Once you got the GUID for site collection from phase 1, run below script

Add-PSSnapin “Microsoft.SharePoint.PowerShell”
$searchapp = Get-SPEnterpriseSearchServiceApplication
Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication $searchapp -SiteCollection <Site_GUID> -limit All >C:\Temp\crawlproperty.csv

SharePoint 2013: _vti_bin/listdata.svc

ISSUE:

When trying to create a data source connection in excel 2010 to connect to SharePoint list, We are getting below error in Excel:

https://<site>/_vti_bin/listdata.svc

PowerPivot For Excel

Cannot connect to specified feed. Verify the connection and try again. Reason: The remote server returned an error: (401) Unauthorized.

When we tried the same wcf connect in Chrome, We got below message:

HTTP 500

The Webpage can not be displayed

 

RESOLUTION:

• It was identified that in the one of the list had a column name with special character i.e.(# ; : ) 

• We renamed the column name without any specific characters
• Tried the WCF connect again and it worked.

 

Refer: https://blogs.technet.microsoft.com/victorbutuza/2014/06/30/why-would-listdata-svc-return-an-error/

Workflow Manager: Farm Creation Error

ISSUE:

We are trying to create a 3 server Workflow farm but we are getting below error message i.e.

WFMServer1.contoso.com

WFMServer2.contoso.com

WFMServer3.contoso.com

Research:

Looking into the error log, we found below message:

System.Management.Automation.CmdletInvocationException: Could not successfully send message to scope ‘/WF_Management’ despite multiple retries over a timespan of 00:02:07.8300000.. The exception of the last retry is: A recoverable error occurred while interacting with Service Bus. Recreate the communication objects and retry the operation. For more details, see the inner exception..  —> System.TimeoutException: Could not successfully send message to scope ‘/WF_Management’ despite multiple retries over a timespan of 00:02:07.8300000.. The exception of the last retry is: A recoverable error occurred while interacting with Service Bus. Recreate the communication objects and retry the operation. For more details, see the inner exception..  —> System.OperationCanceledException: A recoverable error occurred while interacting with Service Bus. Recreate the communication objects and retry the operation. For more details, see the inner exception. —> Microsoft.ServiceBus.Messaging.MessagingCommunicationException: Identity check failed for outgoing message. The expected DNS identity of the remote endpoint was ‘WFMServer1.contoso.com’ but the remote endpoint provided DNS claim ‘WFMServer3.contoso.com’. If this is a legitimate remote endpoint, you can fix the problem by explicitly specifying DNS identity ‘WFMServer3.contoso.com’ as the Identity property of EndpointAddress when creating channel proxy.  —> System.ServiceModel.Security.MessageSecurityException: Identity check failed for outgoing message. The expected DNS identity of the remote endpoint was ‘WFMServer1.contoso.com’ but the remote endpoint provided DNS claim ‘WFMServer3.contoso.com’. If this is a legitimate remote endpoint, you can fix the problem by explicitly specifying DNS identity ‘WFMServer3.contoso.com’ as the Identity property of EndpointAddress when creating channel proxy.

Resolution:

<In Progress>

SP2013: Search Error – HRESULT: 0x80131904

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:

 

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)