SharePoint Error-Lookup and workflow status columns exceed the threshold

You will get the below error sometimes while working with SharePoint 2010 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.".

Actually rather you will say this as an error betther we can say this is a setting provided by SharePoint to improve performance issue. This is related to List throttling which is introduced in SharePoint 2010.

The default value is 8 and that can be increased. To increase this

This User Profile Application's connection is currently not available in SharePoint 2010

I got this error while opening user profile service in SharePoint 2010 "This User Profile Application's connection is currently not available. The Application Pool or User Profile Service may not have been started. Please contact your administrator.".

There can be 2 reasons for this error, either the user profile service is not started or there are some problem in the application pools.

So to verify the 1st cause open the SharePoint 2010 central administration. From the System Settings section go to Manage services on server. This will open the Services on Server list. From there check for the User Profile Service weather it is already started or not. Even if that is started try to stop and Start the User Profile Service again.

If the above approch did not solve the issue. then check all the application pools and check wether all are started or any of them stoped. If any of them stoped they try to restart them and then do an IISRESET and it should work now.

Also you can check out:

- Get icon for different file types in SharePoint 2010

- How to Configure SSRS for SharePoint Integration Mode in SharePoint 2010?

- Different authentication types supported in SharePoint 2013

Bit Rate throttling Module in SharePoint 2010

In this post we will discuss about Bit Rate throttling Module in SharePoint 2010.

Also you can check out:

- Disable default email for approval workflow in SharePoint 2010 

- Image Rendition feature in SharePoint 2013

- Change master page in SharePoint 2013

- Is an IIS extension and can be installed as a single component or also can be installed as a part of IIS media service package.

- Its needs to be installed on each front end web server.

- Bit Rate Throttling module can act at different scopes- server, site, virtual directory, and file.

- Its main features are-

1. Fast Start: It sends the first part of the media file without rate limiting, so that the playback buffer in the player is filled, and playback can begin as soon as possible.

2. Disconnect detection: When the client stops watching the video, the Bit Rate Throttling module detects the connection closure and stops sending the file.

3. Static throttling rates: Built-in support is provided for configuring static throttling rates, as well as detecting the playback rate for several media formats.

Create Custom Theme in SharePoint 2010

Theme is a very good feature in SharePoint by which you can be able to see different visual effects. The logic behind theme is MOSS 2007 and SharePoint 2010 is different. Now you can make SharePoint 2010 Themes by using Microsoft office.

Also you can check out:

- Application page is SharePoint

- What is Document Sets and How to create Document Sets in SharePoint 2010?

- How to deploy farm wsp solution in sharepoint 2010 using PowerShell?

Here we will see how we can make a Theme by using PowerPoint 2010.
Step-1:
Open PowerPoint 2010

Step-2:
From the ribbon go to the design tab and click on Colors and Select Create New Theme Colors
as shown in the figure below.

Step-3:
This will open the Create New Theme Colors dialog box. Change the color and accordingly and Click on Save as shown in the figure below.

Step-4:
Now go to the Design tab and Click on the Font and Select Create New Theme Fonts... as shown in the figure below.

Step-5:
The above step will open Create New Theme Fonts dialog box. Select the fonts and click on Save as shown in the figure below:

-->
Step-6:
Now to save the Theme first click on the button as shown in the figure below.

Step-7:
This will open the a dialog and from there click on Save Current Theme as shown in the figure below.

Step-8:
Browse for a location and save the theme and it is basically a .thmx file. In this step out theme is ready and we can use it in our SharePoint 2010 file.
To see how we can upload the custom Theme in our SharePoint 2010 site view this article.

Change default SearchResultPageURL in Search SharePoint 2010

In this post we will discuss how to Change default SearchResultPageURL in Search SharePoint 2010. Also you can check my previous posts on:

- Query Search with SharePoint 2013 server object model

- Backup and Restore Site Collections in SharePoint 2010 using PowerShell

- Change page layout programmatically SharePoint 2010

By default if you click on search button in SharePoint 2010, it will rediect to osssearchresults.aspx page. But suppose you want to redirect to a different page then there are different ways to do that. Here also I have posted the tread in the forum Change SearchResultPageURL in Search.

Basically these search box is nothing but a SharePoint feature namely as OSearchBasicFeature which is located in the feature directory. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES. If you will open the folder then you will the SearchArea.xml file.

And there is a tag name as
<PropertyName="SearchResultPageURL">/_layouts/osssearchresults.aspx</Property> which is responsible for the page.

You can make you own custom feature with a sequence less than the out of box feature.
But the simplest way to found it is change from the browser.

Go to Site Actions -> Site Settings. It will open the settings page.

Navigate to the Site Collection Administration and click one Search settings.

From the search settings page in the Site Collection Search Results Page section you can change the path as shown in the figure below.

ECMAScript Object Model SharePoint 2010

You can also view this article to more about Client object model. Also you can check an introduction to SharePoint 2010 object model article here.

This is nothing but a different name to JavaScript object model.

We can use the ECMAScript object model in Application and Site pages, as well as web parts and dialog framework.

Microsoft provides SP.js file to work with, which is presented in the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS folder.

To work with ECMAScript Object Model we have to add SP.js file which will automatically add
SP.Core.js and SP.Runtime.js. There is also a debug version of the js file is present with the name as SP.debug.js.

These files are downloaded to the client browser when a user browsers to a SharePoint page.

To add .js file we have to use the below tag:

<SharePoint:ScriptLink ID="SPScriptLink" runat="server" LoadAfterUI="true" Localizable="false" Name="SP.js" />

LoadAfterUI="true" indicates to loads the script after the code of the UI.
Name="SP.js" indicates the relative path of the .js file to include in the page.

Here is a sample code to work with list.

<script language="javascript" type="text/javascript">

var clientContext;
var web;
var announcementList;

function retrieveContacts() {
this.clientContext = new SP.ClientContext.get_current();
this.web = this.clientContext.get_web();
this.announcementList = this.web.get_lists().getByTitle("My Custom Announcement List");
this.clientContext.load(this.announcementList);
}

</script>

Also you can check some SharePoint 2010 object Model articles here

Error occurred in deployment step 'Recycle IIS Application Pool' SharePoint

I got this error while trying to deploy sharepoint solution. The error message is: Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

You can also follow the forum posts here: Error occurred in deployment step 'Recycle IIS Application Pool'

There can be a lots of reason for this error. I got this error while trying to deploy web part to my SharePoint 2010 site from my Visual Studio 2010.

I will suggest to open the web site and check whether it is opening in the browser or not. In my case it was not opening and I got the error as Cannot connect to the configuration database.

The reason I got this error because I have changed my network password but i have not updated in SQLServer service.

So I followed the below article and changed my SQLServer Service password.
http://www.sharepointdotnet.com/2012/03/service-did-not-start-due-to-logon.html

And after that I started the the MSSQLSERVER service from Services list and it worked for me.

Also you can check out:

- Build hyperlink inside email in SharePoint 2010 designer workflow

- Create Apps using Office 365 development tools Napa

- ECMAScript Object Model SharePoint 2010

Happy Holi !!!

SharePoint error-The password supplied with the username was not correct

Few days back when I am trying to create a web application in SharePoint 2010 I got the below error. The error message is:

The password supplied with the username was not correct. Verify that it was entered correctly and try again.

Also you can check out my previous posts on:

- Attach event receiver to list in SharePoint 2010

- New master pages in SharePoint 2013

- File Not Found error in SharePoint 2010

After getting the above errot, I remembered I have changed my password recently. So now we need to update the password also.

Step-1:
For this Open the command prompt. Then navigate to
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN and then type stsadm -o updatefarmcredentials -userlogin <domainusername> -password <newpassword>

Click on enter

It will give you message as "Operation completed successfully." if successfully executed as shown in the figure below.

Step-2:
In the next step do an IISRESET and then try creating web application, it will work fine.

You can follow below MSDN article for more information. http://technet.microsoft.com/en-us/library/cc263417(office.12).aspx

SharePoint Site Collection video tutorial

This is a video tutorial about site collection in SharePoint 2010. You can also check step by steps to create site collection in SharePoint 2010.