Feeds:
Posts
Comments

Sometimes an event log shows the Cache permission missing, USPA Error, Feed Cache Repopulation needed.

Try to restart the cache cluster by,

PS > Restart-CacheCluster

Check the host are UP and running, monitor for couple of hours – if it continues.

Check the status of Cache memory occupied.

PS > Get-AFCacheClusterHealth

This will list the memory and partitions.

To Add the USPA Service account to Cache

PS > Get-CacheAllowedClientAccounts

=> Will list the accounts are configured, mostly WSS_ADMIN & WSS_WPG

PS > Grant-CacheAllowedClientAccounts -Account ‘Domain\USPA_Service_Account’

 

It will be handy to reset the IIS from one server to all. Save it as ps1 and execute in admin account.

$servers = Get-SPServer | Where {$_.Role -ne “Invalid” }
foreach ($server in $servers) {
Write-Host “Restarting IIS on server $server…”
IISRESET $server.Address /noforce
Write-Host “IIS status for server $server”
IISRESET $server.Address /status
}

To reset the search index

Sometimes, due to disk space issue, you might need to clean up some space in drive. Deleting Index files by selecting all and delete is not advisable. Instead of delete those index files, follow below steps, which will release and erase smooth and safe.

    1. Verify that the user account that is performing this procedure is an administrator for the Search service application for which you want to reset the search index.
    2. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
    3. On the Manage Search Applications page, click the Search service application for which you want to reset the search index.
    4. On the Search Administration page, under System Status, verify that the Administrative status of the Search service application is Running and not Paused.
    5. On the Search Administration page, in the Crawling section, click Index Reset.
    6. On the Index Reset page, verify that the Deactivate search alerts during reset check box is checked, and then click Reset Now.
  • In the confirmation dialog box that appears, click OK to confirm that you want to reset the index.

Execute the cmdlets in SP Shell under farm account,

> $farm = Get-SPFarm

> $farm.Servers |% { Get-SPServiceInstance -Server $_.Name | where { $_.TypeName -like “Excel*” } | select TypeName, Status }

Result will be like,

TypeName                                                                                                                   Status
——–                                                                                                                   ——
Excel Calculation Services                                                                                               Disabled
Excel Calculation Services                                                                                               Disabled
Excel Calculation Services                                                                                               Disabled
Excel Calculation Services                                                                                                 Online
Excel Calculation Services                                                                                                 Online

Modify the Service name according to your need.

The Script helps to backup of previous WSP solutions

Get-SpSolution | forEach-Object {$_.SolutionFile.SaveAs(“C:\SPbackup\$($_.Name)”)}

Steps involved in restart the Cache

To STOP

$instanceName =”SPDistributedCacheService Name=AppFabricCachingService”

$serviceInstance = Get-SPServiceInstance | ? {($_.service.tostring()) -eq $instanceName -and ($_.server.name) -eq $env:computername}

$serviceInstance.Unprovision()

To START

$instanceName =”SPDistributedCacheService Name=AppFabricCachingService”

$serviceInstance = Get-SPServiceInstance | ? {($_.service.tostring()) -eq $instanceName -and ($_.server.name) -eq $env:computername}

$serviceInstance.Provision()

SSRS reports are not working

You will be facing this error in website screen,

Report Server has encountered a SharePoint error. —> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. —> Microsoft.SharePoint.Upgrade.SPUpgradeException: An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177 —> System.Exception: 

and another in inner exception error in SSRS logs

library!ReportServer_0-1!1fd4!11/14/2014-03:43:21:: Call to GetSystemPropertiesAction().

library!ReportServer_0-1!1fd4!11/14/2014-03:43:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. —> Microsoft.SharePoint.Upgrade.SPUpgradeException: An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177

at Microsoft.SharePoint.Administration.SPContentDatabase.ValidateDatabaseSchemaCompatibility()

at Microsoft.SharePoint.SPSite.PreinitializeServer(SPRequest request)

at Microsoft.SharePoint.SPWeb.InitializeSPRequest()

at Microsoft.SharePoint.SPWeb.EnsureSPRequest()

at Microsoft.SharePoint.SPWeb.get_Request()

at Microsoft.SharePoint.SPWeb.InitWebPublic()

at Microsoft.SharePoint.SPWeb.get_ServerRelativeUrl()

at Microsoft.SharePoint.SPWeb.get_Url()

at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpWeb.get_Url()

at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(ItemSpecifier itemSpecifier, UserContext userContext, Boolean returnContent, Byte[]& content)

at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.InternalCheckAccess(UserContext userContext, ExternalItemPath itemPath, RSSPBasePermissions requiredRights)

at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.CheckAccess(UserContext userContext, ExternalItemPath path, CatalogOperation requiredOperation)

at Microsoft.ReportingServices.Library.GetSystemPropertiesAction.PerformActionNow()

at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()

— End of inner exception stack trace —;

If your SSRS reports are not working in SharePoint site, identify in which DB server it is installed – Check the MOSS ServicePacks are installed correctly in that particular report server, if not install it again.

Because, Microsoft.SharePoint.Administration.SPContentDatabase.ValidateDatabaseSchemaCompatibility() means the binaries of schema is not compatible –  so identify the Service Pack with other web server and align it as equal to that server, if not install the Service Pack binaries again.

Stop the SSRS service, stop the IIS

then, start the SSRS and start the IIS too.

Before try above option, execute –

  • psconfig -cmd upgrade -inplace b2b –wait

Check now the SSRS reports are working now 🙂