Saturday, September 7, 2013

Datasheet view is disabled SharePoint 2010

Client machine attributes:
OS- windows 7
Explorer- IE9, 64-bit
SP version- SP2010

One of my users has reported an issue that he is facing some problems while using datasheet view. Further probing, we know the truth that he has created a custom list and then trying to click on ‘datasheet view’ but the option is disabled i.e. datasheet view is greyed out.

Error message:
This control is currently disabled.

Million thanks to Microsoft for publishing this KB and make it available to us to understand the background as well as resolution on this issue.

As per this article:
You can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the Microsoft download center:

Concrete Fix:
Go for a 32-bit office version, rather than 64 bit.

The list cannot be displayed in DataSheet view – SharePoint 2010

One of my team mate working on the server where windows server 2008 R2 was installed, he tried switching the view from standard to datasheet and he got the following error: list cannot be displayed

If you are facing the above mentioned error message then I would request you to check the installed office version first.

If you have any confusion as how to check the version then please refer the following link:

Why we are checking the office version? Is it necessary?

Yes, it’s very necessary to know the office version we are using whether it is 32 bit or 64 bit.

Microsoft strongly recommends the use of 32-bit (x86) versions of Office 2010, Project 2010, and Visio 2010 applications as the default option for all platforms.

Make sure you use 32 bit version of office.

FAQ: can we install 32 bit office on 64 bit OS? – Yes, absolutely no probs.

Once you install the 32 bit office in such problematic scenarios then I am pretty sure that your issue will be resolved. Thank you.

In case of any issues/queries then please feel free to contact, I would be more than happy to help you as well as resolves your issues.

Product applies to:

SharePoint Server 2010

SharePoint Foundation 2010

Unable to process create message + User Profile + Connection problems + Event ID:6306

Today my client has requested me to setup a new environment for SharePoint which will be used for deployment purpose.

Here is the farm entity:
§  2 WFE’s
§  2 APP servers
§  Windows server 2008 R2
§  SQL Server 2008 R2: active-passive clustering

While trying to create a synchronization connection in the user profile management then we were getting the following error:

Unable to process create message

No exact match was found

Event log contains the following event id:

ULS logs throwing the following error:
Microsoft.ResourceManagement.Service: System.InvalidOperationException: Retrieve schema failed
   at Microsoft.ResourceManagement.ActionProcessor.SyncConfigActionProcessor.Create(String typeName, IList`1 createParameters, Guid creator, Guid cause)
   at Microsoft.ResourceManagement.ActionProcessor.SyncConfigActionProcessor.ProcessInputRequest(RequestType request)
   at Microsoft.ResourceManagement.ActionProcessor.ActionDispatcher.ProcessInputRequest(RequestType request)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.ExecuteAction(RequestType request)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.ExecuteAction[ResponseBodyType](RequestType request)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.DispatchRequest[ResponseBodyType](RequestType request, Guid requestIdentifier, Object redispatchSingleInstanceKey)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.DispatchRequest[ResponseBodyType](RequestType request)
   at Microsoft.ResourceManagement.WebServices.ResourceManagementService.Create(Message request)

Thanks to this following articles (Author- Balasubramanian Murugesan) who helped me to resolve this issue:


Product applies to:
1)   SharePoint Server 2010
2)   SharePoint Foundation 2010

Friday, September 6, 2013

World Clock and Weather Web Part - SP2013

SharePoint is collaborative software intended to bridge the gap between remote locations within an organization or a network of people. This web part delivers a nice GUI display of time and weather and it helps keep all users connected to each others’ environments.

The Bamboo Solutions World Clock & Weather Web Part allows users to display local time and weather for selected major cities around the globe. It addresses a pretty basic need that SharePoint does not have out of the box.

In addition to supporting multiple presentation interfaces and look & feel options, the World Clock Web Part allows you to specify the size of each clock, direction (vertical or horizontal), and whether to display seconds for each clock. You can also re-order the clocks to match your requirements.

Happy to share some good news as Bamboo has released the world clock and weather webpart for SharePoint 2013.

Enjoy and Happy SharePoint to all of you…

Million Thanks 2 Bamboo Solutions!!

Failed to start workflow. This server is not licensed + Nintex 2010 + SP2010

Problem description:
Some users reported that there are workflows with errors. This error occurs it looks like there is some issue with the license on a farm’s server.

Error message:
Failed to start workflow. This server is not licensed.

Probable Possibilities:
The server admins are incorrect; the Nintex licenses are not configured correctly.  If this were true, I would expect the error to occur more frequently, and not just when multiple workflows start.  For example, I would expect a workflow manual start to occasionally throw the error.

There is a problem with the way Nintex checks for licensing when workflows are distributed among front-end servers or queued up for execution.

If you are facing this error then request you to see the following thread and you will get the answers that you are looking for:

Thank you.

Product applies to:
1)   SharePoint Server 2010
2)   Nintex 2010

3)   SharePoint Foundation 2010

Installing Windows 2012 from Windows 7 (32-bit) failed.

Problem:  The version of this file is not compatible with the version of windows you’re running. Check your computer system information to see whether you need an x86 (32-bit) or x64 (64-bit) versions of the program and then contact the software publisher. 

Background: I was trying to install windows 2012 on my Notebook the Dell Latitude Series E6230.   

However realized I came with the 32-bit Windows 7 operating system. As any normal IT Pro first I tried to run the setup.exe and then got the above error. Sooner or later I realized that 32 bit version O.S doesn't support 64 bit versions application. I was not having any DVD or CD drive where I can burn ISO of Windows 2012.

Resolution: I tried a new method; by converting my USB flash drive to bootable flash drive using Windows 7 USB DVD Download Tool downloaded from MS store for free.

You just need to run the set-up.exe and rest the tool do everything for you.
Go to BIOS by pressing F10 or F12 and boot your PC from the Flash/Thumb Drive your set-up will automatically launch.

Thanks for Mr Bob hunt for his reference below:

Other references:

Applies to: Windows 7, Windows Server 2008, and Windows Server 2012.

Thursday, September 5, 2013

Your client does not support opening this list with Windows Explorer + IE10 + Windows 7

The title of this article itself suggesting the exact problem description, still here are the details:

The machine on which windows 7 is running along with internet explorer 10 throws an exception when you select “Open with Explorer” in SharePoint Server 2010.

Error Message#1: Your client does not support opening this list with Windows Explorer.

Error Message#2: We're having a problem opening this location in File Explorer. Add this web site to your Trusted Sites list and try again.

Another Symptom:
You try to map a network drive to the SharePoint Document Library and the operation fails with the following error:

The mapped network drive could not be created because the following error has occurred:
Access Denied. Before opening files in this location, you must first add the web site to your trusted sites list, browse to the web site, and select the option to login automatically.

Let me provide you some update on this / let me give you some good news as Microsoft has released a fix for this issue by means of KB: 2846960

Fix can be downloaded from:

Millions thanks to Microsoft Windows team to find out the root cause behind this and comes up with a concrete fix.

Happy SharePoint to all of you…

How to Open PDF files in a web browser -SharePoint 2010

One of my clients has reported an issue that they are facing some problems while opening PDF files. Further probing reflected the fact that PDF files are opening but they are getting the prompt of Open, Save and Cancel. In contradictory, the actual requirement is PDF files has to open in browser mode directly rather than saving it to the desktop.

Problem description: SharePoint 2010 prompts to save PDF documents when opening.

Now the question is: Is there a way to open a PDF in a web browser, just like Office Web Apps?

This problem is quite annoying as every time we need to save the documents to the desktop!

Started my troubleshooting to explore the options in central administration
Let me tell you the fact why this is happening? In SharePoint 2010, browser handling has been classified into 2 types:
1)   Strict
2)   Permissive

So the next obvious question will be- what are the differences between these above mentioned types? Here are the details:

Strict specifies the MIME types which are not listed in a Web Application’s AllowedInlineDownloadedMimeTypes property (more on this in a bit) are forced to be downloaded.

Permissive specifies that the HTML and other content types which might contain script are allowed to be displayed directly in the browser. In other words, no matter what the type of content, if it lives within SharePoint, the file will open in your browser.

By default, the option is strict in Central administration so that’s why getting prompt is quite obvious.

Resolution#1 / now the question is how to change this?

1)   Open the central administration
2)   Application management
3)   Under web applications- Manage web applications
4)   Select the web application for which you want to change the settings
5)   General Settings (Top-Ribbon section)
6)   This will be open web application general settings
7)   There is a section named as ‘Browser File Handling’
8)   You will see two radio buttons as Strict and Permissive
9)   Change it to Permissive and Click OK

 No needs to do any iisreset so please go ahead and check the results!

-You should be able to open the PDF files directly in browser-

Resolution#2 – Same functionality as Resolution1, only thing is by means of Power Shell:
$webApp = Get-SPWebApplication http://webapplication_URL
$webApp.BrowserFileHandling = "permissive"

If you have some security concerns and don’t want to change the option from strict to permissive then here is the resolution:

By means of Powershell:
$webapp = [Microsoft.SharePoint.Administration.SPWebApplication]::Lookup(“http://web application_URL”)
If ($webApp.AllowedInlineDownloadedMimeTypes -notcontains “application/pdf”)
Write-Host -ForegroundColor White “Adding Pdf MIME Type…”
Write-Host -ForegroundColor White “Added and saved.”
} Else {
Write-Host -ForegroundColor White “Pdf MIME type is already added.”

Now your PDF documents will be displayed in the browser even if Browser File Handling is set to Strict.

One last point, in fact important point is you may face the problem with the list or site templates. How? – We are all aware that site as well as list/libraries can be saved as templates to transfer from one location to another.

I would like to thanks to Nico Martens for publishing this article for all of us:

Thank you.

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.

Happy SharePoint to all of you…

Product Applies to:
1)   SharePoint Server 2010
2)   SharePoint Foundation 2010


Open PDF files in the browser from SharePoint:

Wednesday, September 4, 2013

FAQ by John Savill at Windows IT Pro

Q: Is it OK to create a Hyper-V virtual machine (VM) with an odd number of virtual processors?

A: A VM can have between 1 and 64 virtual CPUs in Windows Server 2012 and later. Typically, VMs are given 1, 2, 4, 8 and so on virtual processors. This matches many physical server configurations.

Although 1 is an odd number, it's not common to see a VM with 3 or 5 virtual CPUs. However, there is nothing to stop you from doing that. Hyper-V and Windows itself have no problem with an odd number of processors, and there's no need to have an even number.
Q. I notice that different guest OSs have different numbers of virtual processors supported with Hyper-V. What happens if you try to assign more than the supported number of virtual processors?

A. Hyper-V in Windows Server 2008 R2 supports up to four virtual processors per virtual machine (VM), but different guest OSs running within those VMs are tested with different numbers of processors—not all guest OSs are supported for use with the full four virtual processors. The full list of OSs and supported number of virtual processors can be found on this Microsoft site.
If you install a guest OS that, for example, is listed as only supporting two virtual processors, but you configure the VM with four virtual processors, it will still boot—there's no hard limit. However, the configuration wouldn't be supported, and there might be valid performance reasons why more virtual processors aren't supported, so you might see poor performance. But there's nothing that would actually stop you.

Q: Can I perform a Live Migration from a Hyper-V host with an Intel processor to a Hyper-V host with an AMD processor in Windows Server 2012?

A: Live Migration allows a virtual machine (VM) to be moved from one Hyper-V host to another without any downtime to the guest OS. A processor compatibility feature allows a VM to be moved between Hyper-V hosts that have different versions of the same brand of processor, such that both servers have Intel or both have AMD-based processors. However, Live Migration even with processor compatibility enabled on the VM can't be used to move between a mix of AMD and Intel servers. Given how different AMD and Intel processors are, the ability to move a VM between servers running AMD and Intel is fairly unlikely.
Q: Is there a hard limit on the number of Hyper-V Replica servers that can be enabled from a specific Hyper-V server?

A: There's no hard limit for the number of Hyper-V Replica servers that can be enabled from a Hyper-V server or to a Hyper-V server. However, you should carefully consider the following when planning the number of Hyper-V replicas and the infrastructure required.
First, for each Hyper-V replica there's additional write activity on the volume containing the virtual hard disks (VHDs) of the virtual machine (VM) for the log files. The write activity isn't doubled, as there are many optimizations used in the log creation. However, it still increases, around 20 percent is fairly typical from my tests, so this would need to be considered and would vary based on the characteristics of the workload running inside the VM.

Second, and still related to storage, is the actual space the log files consume. Normally the log files are sent to the replica every five minutes. After confirmation that the log file has been played into the replica VM, the log file is deleted from the primary. However, if there's a large amount of change on the source VM (also called churn), the log file could grow large, and any interruption in the transmission of the log file would result in multiple log files queuing up on the source server, consuming more disk space.

Third, the log files have to be sent over the network, and depending on the workload of the VM, the log files could be large and require network bandwidth to be sent. The more VMs enabled for Hyper-V Replica, the more bandwidth required. If the network bandwidth between the primary and the replica isn't sufficient, the log files will start to queue up and the replica will start to creep further out of synchronization.

Finally, and a much smaller consideration, Hyper-V Replica will use some additional CPU and memory. However, I haven't seen this to be a big consideration, and the disk and network factors would be more important.
Q. Is the eight virtual processor per logical processor limit in Hyper-V limit enforced?

A. When calculating resource capacity, you should ensure you don't exceed the recommendation of eight virtual processors to each logical processor. Remember that a logical processor is a core, so if you have a quad-core processor, it counts as four logical processors, so up to 32 virtual processors would be supported.
This isn't an enforced limit, so in theory you could exceed eight virtual processors per logical processor. However, if you hit a problem, it would not be supported by Microsoft, and it really isn't recommended. Proper capacity planning is unlikely to recommend more than eight virtual processors per logical processor unless you have extremely light loads.

Q. How do I set a CPU reservation for a Hyper-V virtual machine (VM)?
A. Hyper-V allows you to reserve processor resources for a VM in addition to limiting the amount of processor resource usage. To do so, access a VM's settings and select the Processor node.
Initially, you select the number of logical (virtual) processors that the VM can see, from one to four (assuming the physical host has at least four cores). You can then set various Resource control options, as shown below.

Remove/Delete user from all SharePoint groups in the web application/site collection – SharePoint 2010

This is one of the requirement in which one of our admin changed the project so it means he will no longer be a part of any SharePoint site collection or any web application.

By considering this requirement, we need to remove this specific users across all site collections, all groups, all web applications…

Here is the script for the same:

$site =Get-SPSite($URL)
$web = $site.OpenWeb()
$groups = $web.sitegroups
$user = $web .AllUsers.Item("name of user")
foreach ($spgroup in $groups)

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

Copy/Move a document between Web Applications + Site Collections + subsites - SharePoint 2010

Lists and Libraries are being extensively used in SharePoint as it’s a collaboration product. Common functionalities that we do on regular basis includes create document libraries and lists, uploading documents, create items, manage permissions at the library level / list level / Item level , manage versions and so many things…

Today’s article is based on the same as how to transfer/copy/move items between web applications/site collections/subsites.
Note: Make sure this feature ‘SharePoint Server Publishing Infrastructure’ should be activated before applying the following steps.
How to check this:
<!--[if !supportLists]-->1)   <!--[endif]-->Open the site
<!--[if !supportLists]-->2)   <!--[endif]-->Site actions
<!--[if !supportLists]-->3)   <!--[endif]-->Site settings
<!--[if !supportLists]-->4)   <!--[endif]-->Site collection administration
<!--[if !supportLists]-->5)   <!--[endif]-->Site collection features
<!--[if !supportLists]-->6)   <!--[endif]-->Activate this feature ‘SharePoint Server Publishing Infrastructure’

Note: If you can’t see the site collection administration then it’s because of permissions, you should be listed as ‘site collection administrator’ to view that option. If you don’t have rights then please contact the assigned site collection administrators to activate that feature.
Coming back to the main article where we are going to see the actual process:
Would like to explain this by means of example:
Suppose there are two sites: site A and site B
Site A: Root site and site B: subsite
<!--[if !supportLists]-->1)   <!--[endif]-->Open the site A
<!--[if !supportLists]-->2)   <!--[endif]-->Site actions
<!--[if !supportLists]-->3)   <!--[endif]-->Site settings
<!--[if !supportLists]-->4)   <!--[endif]-->Site administration
<!--[if !supportLists]-->5)   <!--[endif]-->Content and structure
<!--[if !supportLists]-->6)   <!--[endif]-->Select the list or document library from the left hand side- click on it.
<!--[if !supportLists]-->7)   <!--[endif]-->Associated items will be reflected in the right hand side pane.
<!--[if !supportLists]-->8)   <!--[endif]-->Actions
<!--[if !supportLists]-->9)   <!--[endif]-->You will get the options as Move, copy and delete.

As soon as you will click on copy/move, you will get another dialogue box to select the destination site/ site B + library/list.

Select it and click OK

Items will be successfully moved to destination house.
Note: If you have any confusion regarding this process then I would request you to select the COPY option as it will not completely rid-off the source library items and only replicate it to the destination library. Once items will be successfully moved then you can delete the source library/list as per your requirements.

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

This page contains content or formatting that is not valid. You can find more information in the affected sections - SharePoint 2010

Problem description:
You have an ASP.NET control that contains validation controls in the masterpage or page layout for a publishing site (an ASP.NET login control for example). When you try to edit and check in a publishing page you receive the following error.

Error message:
This page contains content or formatting that is not valid. You can find more information in the affected sections.

Million Thanks to Ari Bakker's SharePoint Config blog who helped me to resolve this issue. Please have a look, it’s too fabulous:

Product applies to:
-SharePoint Server 2010
-SharePoint Foundation 2010


Cannot change item-level permissions because this list or document library contains a column that enforces unique values - SharePoint 2010

User wanted to make some permission level changes on the survey. So that Users can read or edit only their surveys.

We went to the advanced settings. Tried to change it to

We got an error

"Cannot change item-level permissions because this list or document library contains a column that enforces unique values"

We then tried researching and then found that one column "Title"

had that option set to yes as below

We tried to make some changes in the same column from choice to single line of text and enforce unique values to no

However we got one more error.

"The type of this column cannot be changed because it is currently being indexed”

Ahhh... Now we first took a backup of the survey list.

We then created a new column which worked fine. Then deleted the Title Column

And we were able to make the changes.

We were able to now make the changes in the advanced settings. As there was only one column which had that option checked.

Product applies to:
SharePoint Server 2010
SharePoint Foundation 2010

"Connect to Outlook" Disabled - SharePoint 2013

As mentioned in my last article, we have been recently migrated to SharePoint 2013, users are still reporting issues and today’s article is one of those issue.

Machine configuration entities where the issue has been reported:
OS: Windows 7, 32-Bit.
IE (Internet Explorer): IE9, 32-bit.
SharePoint 2013
Office 2013
Site permissions: Site collection administrator.
Problem description:
Not able to connect CALENDAR list to Outlook, while doing the specific action i.e. ‘connect to outlook’ is always disabled.

Error message:
This control is currently disabled.

Troubleshooting done:
-checked the office version and its already 32-bit office.
-disabled the protected mode of IE
-reduced the high priority of IE to lesser one
-restarted the web client service
-Cross-checked the IE version and make sure it should not be 64-bit version.
-checked the client-integration option by means of web application settings and its already enabled.

-Open the site collection on which you are not able to ‘connect to outlook’
-site actions
-site settings
-manage site features
-There is a feature called "Minimal Download Strategy"
-Deactivate this feature

Once this feature will be deactivated then try to ‘connect to outlook’ please check the results again…

Pretty much sure that your issue will be resolved.

Happy SharePoint to all of U...

Importance of this feature i.e. Minimal Download Strategy
Minimal Download Strategy in SharePoint 2013 improves rendering performance when browsing content where large parts of the page do not change providing a more fluid navigation experience. 

The Minimal Download Strategy is by default enabled on Team sites, Community sites and a few others in SharePoint 2013. Once this feature (and it's also a Feature, notice the capital F, we'll get back to that later) all pages for that site is rendered "through" the /_layouts/15/start.aspx page.

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 2013

Microsoft Outlook 2013 Tutorial | Connecting SharePoint Calendars To Outlook


snow flakes

blogger widgets Blogspot Tutorial


Related Posts Plugin for WordPress, Blogger...