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

The security validation for this page has timed out. Click Back in your Web browser, refresh the page, and try your operation again.

Problem Description:

The security validation for this page has timed out" error message when a user submits data to Windows SharePoint Services

Guys, this is an informative article this time as I faced this error message with respect to session time out exception while adding webparts.

Error Message:

The security validation for this page has timed out. Click back in your Web browser, refresh the page, and try your operation again.

if you are facing this error message then Microsoft has already published an article on this which is very useful and resolves your issues. Million thanks to Microsoft for publishing this detail information along with root cause.

Thank you Microsoft…

Resolution: http://support.microsoft.com/kb/888828

If you have any 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.

Create Site Collections, Subsites, Custom List by using PowerShell- SharePoint 2010

Creating of subsites, site collections, custom lists, and document libraries can be easily created by using GUI (i.e. Graphical User Interface) – very easy-correct? But let me tell you guys that all this activities are easier if you do it by using PowerShell. That’s why I am sharing the same so that you can use the following things in day to day activities.

What we are going to check in this article?

-Creation of site collections

-Creation of subsites

-Creation of custom list’s

HOW TO CREATE A SUBSITE IN SHAREPOINT 2010 BY USING POWERSHELL?

New-SPWeb –url<new site url> -name <new site name> -template <template name>

SUBSITE CREATION ALONG WITH SOME ADDITIONAL PARAMETERS:

New-SPWeb –url http://sharepoint2010/sites/MOSS2010/SUB2010 -name "All about SUBSITES" -template STS#0 –AddToTopNav –UniquePermissions –UseParentTopNav

HOW TO CREATE SITE COLLECTION IN SHAREPOINT 2010 USING POWERSHELL?

$siteURL = “http://sharepoint2010/sites/MOSS2010;

$owner = “moss2010/SPAdministrator1”

$secondOwner = “moss2010/SPAdministrator2”

$template = “STS#0″

$description = “PowerShell created Site Collection”

New-SPSite $siteURL -OwnerAlias $owner -SecondaryOwnerAlias $secondOwner -name “PowerShell for SharePoint” -Template $template -Description $description

HOW TO CREATE A CUSTOM LIST IN SHAREPOINT 2010 BY USING POWERSHELL?

$SPAssignment = Start-SPAssignment

$SPWeb = Get-SPWeb http://siteURL -AssignmentCollection $spAssignment

$SPWeb.ListTemplates | Select Name, Description

$SPTemplate = $SPWeb.ListTemplates["Custom List"]

$SPWeb.Lists.Add("List Title","Description",$SPTemplate)

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

Deletion of Subsite, Site Collection, Document Library, SharePoint List- SharePoint 2010

Most commonly used entities in SharePoint are Subsite, site collection, list and libraries. 

GUI mode will be the easiest mode to do any functional activities associated with them. In this article, i am more concentrating on the PowerShell mode because its very easy and efficient way to clean the activity directly from the database. 

Let's try to explore some deletion functionalities by means of PowerShell.

How to delete a site collection by using PowerShell?

Remove-SPSite [-Identity] <SPSitePipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-DeleteADAccounts <SwitchParameter>] [-GradualDelete <SwitchParameter>] [-WhatIf [<SwitchParameter>]]

Example: Remove-SPSite -Identity http://SharePoint2010/sites/test2010

Where:

SharePoint2010: web application URL.

Sites: wildcard entry.

test2010: site collection that you want to delete.

Note: The above will completely deletes an existing site collection and all subsites. This operation cannot be undone.

How to delete a Subsite by using PowerShell?

Remove-SPWeb [-Identity] <SPWebPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Recycle <SwitchParameter>] [-WhatIf [<SwitchParameter>]]

Example: Remove-SPWeb -Identity http://SharePoint2010/sites/test2010/subtest2010

Where:

SharePoint2010: web application URL.

Sites: wildcard entry.

test2010: site collection

subtest2010: Subsite that you want to delete.

If you want to delete multiple subsites in a single shot from a site collection then please refer the following site: http://get-spscripts.com/2010/10/delete-sharepoint-sub-sites-using.html

How to delete a Document Library by using PowerShell?

Please refer the following code by which you can delete a document library without any issues...

$web = Get-SPWeb urlofweb

$library = $web.lists["listname"]

$library.Delete()

How to delete a SharePoint List by using PowerShell?

Get-SPWeb “site collection link” | % {$_.Lists.Delete([System.Guid]$_.Lists["name of list"].ID)}

The above command will delete the mentioned list without any issues...

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

March Public Update for SharePoint 2013 available

If you are looking for March updates for SharePoint 2013 then please refer the following references:

·        http://blogs.technet.com/b/stefan_gossner/archive/2013/03/21/march-public-update-for-sharepoint-2013-available-and-mandatory.aspx   

·        http://blogs.technet.com/b/praveenh/archive/2013/03/19/march-2013-public-update-pu-for-sharepoint-server-2013-is-here.aspx

·        http://blogs.technet.com/b/mspfe/archive/2013/04/05/sharepoint-2013-march-2013-public-update-required-for-future-cumulative-updates.aspx

·        http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=398

·        http://blogs.msdn.com/b/chhopkin/archive/2013/04/04/sharepoint-2013-updates-as-of-april-2013.aspx

·        http://blogs.msdn.com/b/russmax/archive/2013/04/01/why-sharepoint-2013-cumulative-update-takes-5-hours-to-install.aspx

·        http://technet.microsoft.com/en-us/sharepoint/jj891062.aspx

·        http://www.microsoft.com/en-in/download/details.aspx?id=36987

·        http://support.microsoft.com/kb/2767999

EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'

Problem Description:

 While I am deploying my solution in to SharePoint, it's throwing an exception as follows:

Error Message:

EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'

Logs analysis:

The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject obj, Boolean storeClassIfNecessary, Boolean ensure)

   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject obj, Boolean ensure)

   at Microsoft.SharePoint.Administration.SPPersistedObject.Update()

Root cause: Permissions

This error appears to be an issue with the permissions to the SharePoint configuration database.The general recommendation I found was to ensure that the application pool identity of the web application has sufficient permissions on the config database.

Resolution:

Million thanks to Microsoft's Team who has created this article:

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

Details Steps:

-In order to resolve the issue, I provided Execute permission to the database role “WSS_Content_Application_Pools” into the stored procedure “proc_putObject”. I performed the following steps to do this.

-In the database server, expand SharePoint Config database and naviage to Programmability/Stored Procedures/dbo.proc_putObject using SQL Server Management Studio.

-Right click on the above stored procedure and select Properties.

-On the popup screen, select Permissions on the left and click Search button.

-On the new popup screen, click Search, select [WSS_Content_Application_Pools] database role and click OK.

-Click OK again.

-On the first popup screen, select the role, check Execute permission and click OK.

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

Content databases contain orphaned items

Problem Description:

The SharePoint Health Analyzer detected an error.  Content databases contain orphaned items.

In some situations, a content database that is used by Microsoft SharePoint Foundation may become corrupted. The corrupted database may contain orphaned items. For example, a document may not have a parent document library or a list may not have a parent Microsoft SharePoint Foundation Web site.  Consequently, you may be unable to create new items with the same URL as the orphaned items, and space in the content database will be consumed unnecessarily.

Error Message:

Content databases contain orphaned items

Resolution:

Perfect article provided by Microsoft on this which helps me to resolve this issue:

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

Product Applies To:

SharePoint Server 2010.

SharePoint Foundation 2010.

Redirect a SharePoint site by using the Content Editor Web Part - SP2010

Today one user came up with the requirements that he wanted to redirect his current site to different site collection. This seems to a normal requirement for everybody and can arise at any time.

I have resolved that issue with the use of metatag and thought to share with all of you as how I resolved it.

Please refer the following the following line of code that you need to use it for the redirection purpose.

<meta http-equiv="refresh" content="2;URL=http://sharepoint2007/sites/contentmodification">

Where you need to use it?

-Open the site where you need to set up the redirection

-site actions

-edit page

-add the content editor WebPart

-Give the reference of this file.

You must be wondering what is meant by reference?

-Created any document library or use the existing one

-Copy the redirection script/line in a notepad

-Upload this notepad in a document library

-click on the notepad direct and copy the link from the browser.

-Go back to the site where you have added the content editor WebPart

-Enter the link inside the WebPart which will take the reference of that notepad.

That’s it. You are done with redirection.

If you have any queries/questions based on the same then please let me know, Thank you.

A positional parameter cannot be found that accepts argument SharePoint 2010

Problem Description:

Let me tell you that you will face this error while executing PowerShell commands. I have experienced the same while executing ‘add solution’ command.

Error Message:

A positional parameter cannot be found that accepts argument

You might laugh when I will tell you the resolutions in reference to the above as it’s so simple.

Resolution:

-Check the literal path that you have provided, most probably that’s the only reason when this command throws an exception.

Make sure that you providing the path in double quotation marks. That’s it.

Please amend the changes and you will successfully execute the command that you are working on.

In case of any queries/questions then please let me know, Thank you.

SharePoint 2013 Distributed Cache service.

This post is meant to give SharePoint Administrators an deeper look into the Distributed Cache along with some links to other resources on the internet.

Background
SharePoint 2013 uses the AppFabric (Caching) by Microsoft. Read here for a background on AppFabric. AppFabric Caching stores serialized managed objects in a ‘cache cluster’. The cache cluster consists of one or more machines (Cache Hosts) that pool their available physical memory. This pooled memory is presented and used by SharePoint as a single source of caching memory.

To read completed article click here.

Cannot browse to All People in SharePoint 2010

We used to normally visit All people in Sharepoint 2007 to Delete the user from the Site collection :)

Where is it in Sharepoint 2010 ?

The “All People” view is the best way to list out all the users having access to the SharePoint site.

When a admin navigates to the “People and Groups” section in a SharePoint 2007 site,

he sees a link called “All People” in the left hand navigation.

Clicking on this link brings up a view of all the users across all the groups in the site.

But this “All People” view is hidden in SharePoint 2010 and the link is also missing in the “People and Groups” section.

However one can still navigate to this view in a SharePoint 2010 by following the below mentioned steps :

 

• Navigate to the “People and Groups” section.
• Click on any of the groups.
• Locate the “MembershipGroupId” query string parameter from Url in the address bar
• Replace the value in the “MembershipGroupId” query string parameter with 0.
• Reload the page and it will populate the “All People” View.

Site menus are hidden behind content editor web part

Issue: Site menus are hidden behind content editor web part.

Background: User added .swf file into content editor web part using iframe.

Code: Client had used the following code in the CEWP.

 

Troubleshooting: We tried with different parameters like, visibility, position, z-index but none of them working but no success.

 

Resolution: You have to add the wmode attribute.

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.

Applies to: SharePoint Foundation / Server 2010.

 

Task Microsoft Exchange Server reported error (0x8004010F)

Error Message: Task 'Microsoft Exchange Server' reported error (0x8004010F): 'The operation failed. An object could not be found.'

Error Code: 0X8004010F

Problem Description: While doing a Send / Receive on an Outlook user was getting the error message that operation failed and unable to resolve recipients.

After researching error message I got to know about the issue, that Offline Address Book was not found while using outlook.

When I checked host location of the user mailbox, found that the user is on Exchange 2010 server.

Found that the OAB was not configured for that DATABASE.

Offline Address Book assignment is very important in order to work send / receive and resolve the objects offline.

Resolution:

Exchange Server 2010

-In Exchange Management Console, expand Organization Configuration, and then clickMailbox.

-In the Database Management window, right-click Properties on the mailbox store.

-Click the Client Settings tab, click Browse, and then click the appropriate offline address book.

-Click on Apply and OK.

Exchange Server 2007

-In Exchange Management Console, expand Server Configuration, and then clickMailbox.

-In the Database Management window, right-click Properties on the mailbox store.

-Click the Client Settings tab, click Browse, and then click the appropriate offline address book.

-Click OK two times.

Thank you.