List View Threshold in SharePoint 2010

One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. 

The performance of any SharePoint site, especially one that contains lists and libraries with many items, is directly affected by decisions made when setting up and planning a SharePoint site.

Error Message:

SharePoint list error: lookup and workflow status columns exceed the threshold.

Problem Description:

Users get this error when accessing a SharePoint list:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Resolution:
Follow below steps:

1.    Open the SharePoint Central Administration

2.    Application Management

3.    Manage Web Application

4.    Select Your Web Application

5.    General Settings

6.    Resource Throttling

7.    By default List View Lookup Threshold is 8 change it as per your requirement and

8.    Finally click OK to save it.

If you have any queries/questions then please let me know, thank you.

Product Applies To:

·         SharePoint Server 2010

·         SharePoint Foundation 2010

·         SharePoint Server 2013

How to change the site collection administrators in central administration by means of PowerShell

Few days before, one of my user came to our team and requested to have a list of site collection administrators as well as to change the admins for few site collections.

In fact it's quite easy if you do by means of GUI i.e. Central Administration.

Let me brief some steps so that it would be useful to you.

-Open Central Administration

-Application Management

-change site collection administrator

-change the admins as per the requirements

this will be hectic task if you have to implement the same for more site collections i.e. bulk activity.

so that's why I come up with the solution so that it would be beneficial for everybody.

here is the script that i am talking about:

Set-SpSite "http://sharepointdemo.skylark.com" -owneralias "domain\user1" -SecondaryOwnerAlias "<domain\user2>"

If you wanna add a list of users to the site collection administrators group of every site on your SharePoint 2010 farm then please refer this:

http://basementjack.com/uncategorized/powershell-script-to-add-a-list-of-users-to-the-site-collection-administrators-group-of-every-site-on-your-sharepoint-2010-farm

If you have any queries/questions regarding the above mentioned information then please let me know, thank you.

Product Applies To:

-SharePoint Server 2010

-SharePoint Foundation 2010

References:

Remove a site collection administrator in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

To add a primary or secondary site collection administrator by using Windows PowerShell in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

Change the primary or secondary site collection administrator in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

add a site collection administrator by using Central Administration

http://technet.microsoft.com/en-us/library/ff631156(v=office.14).aspx

To add a site collection administrator by using Windows PowerShell

http://technet.microsoft.com/en-us/library/ff631156(v=office.14).aspx

Remove a site collection administrator

http://technet.microsoft.com/en-us/library/ff631156(v=office.14).aspx

Windows could not start the SharePoint 2010 administration service on local computer.

Infrastructure:

SP Version: Microsoft SharePoint Server 2010-SP1

Server: Windows Server 2008 R2

Problem Description: Not able to start the SharePoint Administration 2010 Service by means of services.msc console.

Error Message: Windows could not start the SharePoint 2010 administration service on local computer.

Issue identified by: Central Administration's Health Analyzer

Troubleshooting done:

- Tried starting the service by means of farm account in the services console with respect to the server where it was failing but got the error message as follows:

Windows could not start the SharePoint 2010 administration service on local computer.

- Tried start the service by means of PowerShell but got the same message as above.

Resolution applied:

Increased the default service time-out

·         Click Start, click Run, type regedit in the Open box, and then click OK.

·         Locate and then select the following registry subkey:

·         HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

·         Right-click Control, point to New, and then click DWORD Value.

·         In the New Value box, type ServicesPipeTimeout, and then press Enter.

·         Right-click ServicesPipeTimeout and then click Modify.

·         Click decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK.

For example, if you want to wait 60 seconds before the service times out, type 60000.

Exit Registry Editor and then restart the computer.

-restarted the server and issue has been resolved.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Product Applies to:

SharePoint Server 2010

SharePoint Foundation 2010

References:

http://technet.microsoft.com/en-us/library/ee513050(v=office.14).aspx

http://blogs.technet.com/b/wbaer/archive/2007/10/15/kb934525-troubleshooting.aspx

http://www.networksteve.com/enterprise/topic.php/SharePoint_Services_don't_start_after_restart/?TopicId=8674&Posts=3

http://stackoverflow.com/questions/8388050/the-windows-sharepoint-services-administration-service-on-local-computer-started

Document set in sharepoint 2010

Normally banks will maintain customer’s information. They will provide customers basic info, internet banking, mobile banking, debit card facilities to their customers, they maintain separate documents for each.

We will use the same feature using Document set in SharePoint 2010.

How to enable Document Sets?

Document sets by default won't be enabled in SharePoint 2010. It's a feature and has to be enabled manualy. Then document sets Content type has to be customized (if required). After that it can be attached to Document libraries. First keep all project document templates (BasicInformation document, PhoneBanking document, InternetBanking Document, Debitcard Document) ready.

Create these documents in my documents folder.

 

Login to SharePoint 2010 site -> Site settings -> Site Administration -> Site Collection Features ->

Document Sets -> Activate.

Site Settings -> Galleries -> Site Content types -> Document Set Content Types -> Document Set.

Select Document Set Settings.

Under Default Content section select the templates. Click "Add new default content" to select and upload more template documents.

Now upload the documents that u created earlier as shown below

Now we'll create new document library. If you want to attach to existing document library then skip this step.

Open the document library -> Library (Tab) -> Library Settings.

Under General Settings select Advanced Settings. We need to enable allow management of content types setting.

Under Content types Select Yes for "Allow management of content types?" and save/Click Ok.

Now in the library settings page Content types section will be shown. Select "Add from existing site content types".

Under "Select Content types" section select "Document Set" and Add. Now click Ok.

 

Repeat the same steps and add another

Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive- SharePoint2010

What is meant by session state? What exactly its functionality? How it works?

Reference: http://msdn.microsoft.com/en-us/library/ms178581%28v=vs.100%29.aspx

Complete Error Message:

Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.

Before you start your troubleshooting, make sure that the State Service service application is running. How you will check this?

-Open your Central Administration

-Manage service applications

- check the service application by the name ‘state service service application’

What exactly I did to resolve this issue? Please refer the following:

2-step resolution:

Make the enableSessionState is set to true, How?-Please refer below:

<pages enableSessionState="true" enableViewState="true" enableViewStateMac="true" validateRequest="false" pageParserFilterType="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" asyncTimeout="7">

Make sure that the remove and add lines exist in the modules section for Session.

<modules runAllManagedModulesForAllRequests="true">

…

<remove name="Session" />

<add name="Session" type="System.Web.SessionState.SessionStateModule" preCondition="" />

…

modules>

After implementing the above changes, the error should have to go away.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you…

Product Applies To:

-SharePoint Server 2010

-SharePoint Foundation 2010

References:

This report failed to load because session state is not turned on" when you try to view Microsoft Access Services reports

http://support.microsoft.com/kb/2419469

State service and session state cmdlets (SharePoint Server 2010)

http://technet.microsoft.com/en-in/library/ee890113(v=office.14).aspx

Manage the State Service (SharePoint Server 2010)

http://technet.microsoft.com/en-us/library/ee704548(v=office.14).aspx