SharePoint By Yagya Shree

SharePoint 2016: Reduce the size of logging database

leave a comment »


How to reduce the size of logging database and how to purge the old data from Logging Database

When i ran the command in my Sharepoint 2016 farm, it gave me following error:

Get-SPUsageDefinition | ForEach-Object {Set-SPUsageDefinition -Identity $_.name -DaysRetained 1}

 

The above command gave me below error:

Set-SPUsageDefinition : The number of days to keep usage data must be greater than the number of days to keep detailed
data.
At line:1 char:41
+ … Each-Object {Set-SPUsageDefinition -Identity $_.name -DaysRetained 1}
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (Microsoft.Share…UsageDefinition:SPCmdletSetUsageDefinition) [Set-SPUsage
Definition], InvalidOperationException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletSetUsageDefinition

Tried to find if this error is reported in all search engines but unable to find any information.

I did stumble upon this good link which talks about change in how settings are changed in SharePoint 2016.

So i modified my command and ran following:

Get-SPUsageDefinition | ForEach-Object {Set-SPUsageDefinition -Identity $_.name -DaysRetained 1 -DaysToKeepUsageFiles 0}

That’s it!

The command ran successfully and i validated the changes.

I then ran following command to start by timer jobs:

Get-SPTimerJob | Where-Object { $_.title -like “*usage data*” } | Start-SPTimerJob

Advertisements

Written by Yagyashree

July 18, 2018 at 5:44 am

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

%d bloggers like this: