Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unnecessary system resources in SHAREPOINT server

Error :

Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unnecessary system resources.

To configure the account use the following command 'stsadm -o setproperty -propertyname portalsuperuseraccount -propertyvalue account -url webappurl'. The account should be any account that has Full Control access to the SharePoint databases but is not an application pool account.

 Additional Data:

 Current default super user account: [MachineName]\system SharePoint 2010 is hosted on this machine.

Scenario :

The IIS APPPool account does not have access permission for the DB/tables and display the result.(in my scenario, SQL Server (SSRS) Reports not accessible).

Solution :

I gave DB_Owner permission for the user APPPool account to the DB.

Get Assembly Name of SP Timer Job

To Get Assembly (.dll) name of particular SP Timer Job use the below command,

Get-SPTimerJob -WebApplication "http://<SPSite>:<Port>" -Identity "<Timer Job Name>" | select Name, DisplayName,TypeName | Format-List

The URL ‘[url]‘ is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web in SharePoint

My Work Env:

 I got the error "The URL ‘[url]‘ is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web"  in SharePoint 2010. The site was working fine, but after few days the SharePoint site got the error.

    In my scenario, the lookup filed does not give this error, because i don't use any lookup field in SP env.
(for ref : http://bernado-nguyen-hoan.com/2011/03/22/sharepoint-evil-1-the-url-url-is-invalid-it-may-refer-to-a-nonexistent-file-or-folder-or-refer-to-a-valid-file-or-folder-that-is-not-in-the-current-web/ ).

  Root Cause:
   My SharePoint site's DB machine has 0bytes free memory.

Solution:
   I freed some space, then site works as normal.

Change outgoing Email settings in SharePoint 2013

I have configured Outgoing Email settings in SharePoint 2013. But the FROM email id in the mail shows another Email ID, what actually I have configured in Outgoing Email settings in SharePoint Central Admin.

Root Cause :

    The web application which triggers the mail has different email ID what we configured in the SP Central Admin.

PowerShell cmd to check OutboundMailSenderAddress,

 (Get-SPWebApplication http://SPWebApp).OutboundMailSenderAddress

Check for both, web app and Central Admin URL.

Solution:

I have updated the OutboundMailSenderAddress mail address using SP Management Shell,

$webApp = Get-SPWebApplication "http://SPWebApp"

$webApp.OutBoundMailReplyToAddress = "no-reply@suglog4.net"

$webApp.OutboundMailSenderAddress = "sharepoint2013@suglog4.net"

$webApp.IncomingEmailServerAddress = "suglog4Mail"

$webApp.Update()

Note : If you have more than one WFE and APP server run the above script line for all the servers and check whether the OutboundMailSenderAddress user has updated.

Now check the both the SP Central Admin and  Web App OutboundMailSenderAddress user's are same.

PowerShell cmd to check,

 (Get-SPWebApplication http://SPWebApp).OutboundMailSenderAddress

Add a crawled property in SharePoint 2013 with sortable/Refinable using Powershell

For Sortable:

New-SPEnterpriseSearchMetadataCrawledProperty -Category SharePoint -IsNameEnum $false -Name "ows_MyCrawledProperty" -PropSet 00130329-0000-0130-c000-000000131346 -SearchApplication "Search Service Application" -VariantType 0

New-SPEnterpriseSearchMetadataManagedProperty -Name "MyCrawledProperty" -SearchApplication "Search Service Application" -Type 1 -Queryable $true -Retrievable $true

$cp = Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication "Search Service Application" "ows_MyCrawledProperty"

$mp = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication "Search Service Application" -Identity "MyCrawledProperty"

$mp.sortable= $true

$mp.update

New-SPEnterpriseSearchMetadataMapping -SearchApplication "Search Service Application" -CrawledProperty $cp -ManagedProperty $mp


For Refinable:

New-SPEnterpriseSearchMetadataCrawledProperty -Category SharePoint -IsNameEnum $false -Name "ows_MyCrawledProperty" -PropSet 00130329-0000-0130-c000-000000131346 -SearchApplication "Search Service Application" -VariantType 0

New-SPEnterpriseSearchMetadataManagedProperty -Name "MyCrawledProperty" -SearchApplication "Search Service Application" -Type 1 -Queryable $true -Retrievable $true

$cp = Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication "Search Service Application" "ows_MyCrawledProperty"

$mp = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication "Search Service Application" -Identity "MyCrawledProperty"

$mp.Refinable= $true

$mp.update

New-SPEnterpriseSearchMetadataMapping -SearchApplication "Search Service Application" -CrawledProperty $cp -ManagedProperty $mp