SharePoint By Yagya Shree

Archive for the ‘sharepoint’ Category

How to find site collection creation date

leave a comment »


Please run below script in SharePoint 2013 Management Shell

 

$w = Get-SPWeb https://this_is_Site_Collection_url

$w.Created

Create_date

Written by Yagyashree

July 17, 2017 at 11:28 pm

Posted in sharepoint

Tagged with , , , ,

HOW TO RETRIEVE ALL APPS INSTALLED ON A SHAREPOINT 2013 WEB APPLICATION THROUGH POWERSHELL

leave a comment »


For my reference:

 

Add-PsSnapin Microsoft.SharePoint.PowerShell
$webApp = Get-SPWebApplication "http://sp2013"
foreach($site in $webApp.Sites)
{
    Write-Host $web.Url -BackgroundColor DarkGreen
    foreach($web in $site.AllWebs)
    {
        $appInstance = Get-SPAppInstance -Web $web.Url | select Title,Appwebfullurl,Id
        if($appInstance -ne $null)
        {     
	   $appInfo = $appInstance.Title + " - " + $appInstance.Appwebfullurl     
           Write-Host $appInfo
        }
    }
}

Written by Yagyashree

October 31, 2016 at 6:22 pm

Posted in powershell, sharepoint

Tagged with ,

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 , , , , ,

%d bloggers like this: