Failed to connect to hosts in the cluster – SharePoint 2013

Recently got this error when i try to run the PS command to stop the Distributed cache stop-spdistributedcacheserviceinstance   Eventually it happened because the “Remote Registry” service under the Services was not started in the App server. I started the service then i could able to execute the above command.   Fix your Microsoft Access Issue easily using this Product Continue reading Failed to connect to hosts in the cluster – SharePoint 2013

Group By SPListItem in SharePoint ListItemCollection

The CAML Query does not support group by object collection. The other workaround is to get the object and group by LINQ query try { using (SPSite oSiteCollection = new SPSite(webUrl)) { using (SPWeb oWebsite = oSiteCollection.OpenWeb()) { SPList listName = oWebsite.Lists.TryGetList(“MCS”); if (listName != null) { SPView myView = listName.Views[“GroupBy”]; if (myView != null) { SPQuery qry = new SPQuery(myView); SPListItemCollection myItemsList = listName.GetItems(qry); var results = (from SPListItem item in myItemsList group item by item[“Group Number”] into grp select new { GroupID = grp.Key.ToString(), ListItemsData = grp }); foreach (var listData in results) { MessageBox.Show(listData.GroupID); foreach (var item … Continue reading Group By SPListItem in SharePoint ListItemCollection

jQuery Accordion based Announcement Web Part

A simple announcement web part based on the accordion. The theme can be changed from the below site http://jqueryui.com/themeroller/. To change the theme just download the theme package from the above link and past the css to the layouts folder. Make sure the List which you connecting to the webpart has the same name of the column as in the below picture The web part takes the below properties Sample screenshot below The wsp and the source are in the folder http://sdrv.ms/13OhOjj Continue reading jQuery Accordion based Announcement Web Part

Cache cluster is down, restart the cache cluster and Retry Error–SharePoint 2013

The windows event viewer might have many critical error from Distributed Cache Service. This service will try every 5 min and will throw critical error on the event viewer. The error message may be “Cache cluster is down, restart the cache cluster and Retry “ The root cause of this error may be various reasons. The distributed cache service is very fragile and needs more memory from the server side. Before we Start the Distributed Cache Service please read the article http://technet.microsoft.com/library/jj219572(office.15).aspx The article tells you that we need to enable some firewall ports in the server, especially the application … Continue reading Cache cluster is down, restart the cache cluster and Retry Error–SharePoint 2013

Install-SPRSService is not Recognized Error–SharePoint 2013 SQL 2012 Reporting Services

Sometime even after you install the SQL Reporting Services in SharePoint Mode to the Application Server you might get the below error Install-SPRSService : The term ‘Install-SPRSService’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. The reason might be the wrong version of SQL 2012 Reporting Services for SharePoint is installed. For SharePoint 2013 SQL 2012 SP1 is the requirement. In some cases if you have downloaded the SQL 2012 SP1 installer … Continue reading Install-SPRSService is not Recognized Error–SharePoint 2013 SQL 2012 Reporting Services

Central Admin Warning – InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured

After i complete my SharePoint 2013 setup the above mentioned warning appeared in the central administration. The solution is to run the below PS command to fix it $serviceApp = New-SPStateServiceApplication -Name “State Service”New-SPStateServiceDatabase -Name “StateService DB” -ServiceApplication $serviceAppNew-SPStateServiceApplicationProxy -Name “State Service” -ServiceApplication $serviceApp –DefaultProxyGroup Continue reading Central Admin Warning – InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured

Move Search Components To Different Server in SharePoint 2013

SharePoint 2013 Search components are very scalable. Now you can move the components from the search to different servers which it is running. In SharePoint farm environment usually the Application Server will host all the Services including the Search Application services. The Search Application consists of several Search components like Admin Crawler Content Processing Analytics processing Query Processing Index The movement of the components to another server is not possible from the Central Administration. The Search Topology does not provide any option to move. So these can be done using the PS commands. Farm before movement Farm After Movement Below … Continue reading Move Search Components To Different Server in SharePoint 2013

How to find Concurrent Users for SharePoint and ASP.NET using IIS Logs

This post is about finding the number of concurrent users. The concurrent users helps to do the capacity planning for SharePoint. Below are the main attributes required to do the capacity planning for SharePoint 2010/2013. Average daily RPS Average RPS at peak time Total number of unique users per day Average daily concurrent users Peak concurrent users at peak time Total number of requests per day   One of the main attribute for the planning is the Concurrent users. Below are the steps required to find the concurrent users Enable the IIS Logs in the server Collect the logs for … Continue reading How to find Concurrent Users for SharePoint and ASP.NET using IIS Logs