SharePoint By Yagya Shree

Posts Tagged ‘sharepoint

SP2013: Find All search crawl Property

leave a comment »


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

Written by Yagyashree

September 19, 2016 at 8:23 pm

SharePoint 2013: _vti_bin/listdata.svc

leave a comment »


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.

listdata

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/

Written by Yagyashree

September 15, 2016 at 9:54 pm

Posted in sharepoint

Tagged with , , , , ,

Workflow Manager: Farm Creation Error

leave a comment »


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

farm-error

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>

Written by Yagyashree

September 8, 2016 at 8:56 pm

Posted in sharepoint

Tagged with , , , ,

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

Workflow Manager Port 12290 Blocked

leave a comment »


Issue:

While creating a new workflow farm and running the wizard, we are keep getting below error message:

Port number 12290 specified for Workflow Manager Management Port is blocked

WFM_Error_06SEP2017

Resolution:

  1. It seem that someone created a IIS Website on port 12290 on the server
  2. Deleted the website.
  3. Performed IISRESET
  4. Ran the Workflow Manager Configuration Wizard again and it worked

Written by Yagyashree

September 6, 2016 at 5:44 pm

Posted in sharepoint

Tagged with , , , , ,

Preventing me from adding any additional column in existing list and /_layouts/mngfield.aspx extremely slow to load for sub sites

leave a comment »


Issues:

1. Trying to ‘Add from existing site columns‘ to one of my SharePoint lists on a http://SiteUrl
——————————————————————
Error
An unexpected error has occurred.
Correlation ID: GUID

Preventing

—————————————————————–
2. Click on Site Settings->Site Columns ( http://SiteUrl/_layouts/mngfield.aspx ) extremely slow to load for sub sites

Root cause:

Looking up that Correlation ID in the SharePoint 2013 ULS logs I saw this error:

“Error when access /_layouts/15/AddFieldFromTemplate.aspx, Error=No two choices should have the same ID at Microsoft.SharePoint.ApplicationPages.ChoiceComparerWithDefaultGroup.Compare”

Found two Site Columns in http://SiteUrl Site that was using the same internal name, and that Site column was associated with list which is preventing me from adding any additional columns.

By browsing to the Site Collection Site Columns (<Site Url>/_layouts/mngfield.aspx ) I noticed under one of Site Column Group that there were two Site Columns listed with the same “CoulmnName”,

Solution:
We need to remove duplicate Site Columns from that Site Column Group.

Written by bajiraoshinde

April 19, 2016 at 9:00 pm

Posted in sharepoint

Tagged with , , ,

SharePoint Server 2016

leave a comment »


SharePoint Server 2016

https://technet.microsoft.com/en-us/library/cc303422(v=office.16).aspx

 

Link to download SharePoint Server 2016

https://www.microsoft.com/en-us/download/details.aspx?id=51493

 

Language Packs for SharePoint Server 2016

https://www.microsoft.com/en-us/download/details.aspx?id=51492

 

New and improved features in SharePoint Server 2016

https://technet.microsoft.com/en-us/library/mt346121(v=office.16).aspx

 

What’s deprecated or removed from SharePoint Server 2016

https://technet.microsoft.com/en-us/library/mt346112(v=office.16).aspx

 

MinRole overview

https://technet.microsoft.com/en-us/library/mt346114(v=office.16).aspx

 

Description of MinRole and associated services in SharePoint Server 2016

https://technet.microsoft.com/en-us/library/mt667910(v=office.16).aspx

 

What’s new for admins in SharePoint Server 2016

https://channel9.msdn.com/Shows/Mechanics/Whats-new-for-admins-in-SharePoint-Server-2016?ocid=relatedentry

 

SharePoint 2016 RTM and the Future of SharePoint event

SharePoint 2016 RTM and the Future of SharePoint event

 

Data Loss Prevention in SharePoint 2016

https://channel9.msdn.com/Blogs/vladcatrinescu/Data-Loss-Prevention-in-SharePoint-2016?ocid=EntriesInArea

 

What’s new in SharePoint 2016 for IT Pros

https://channel9.msdn.com/Blogs/vladcatrinescu/Whats-new-in-SharePoint-2016-for-IT-Pros

 

Upgrade to SharePoint Server 2016

https://technet.microsoft.com/en-us/library/cc303420(v=office.16).aspx

 

Upgrade content databases to SharePoint Server 2016

https://technet.microsoft.com/en-us/library/cc263299(v=office.16).aspx

Written by Yagyashree

March 30, 2016 at 8:47 pm

%d bloggers like this: