SharePoint 2013 business data web parts missing

March 26, 2015 Leave a comment

Like you I was puzzled because Business Data Web Part was Missing in our SharePoint 2013 Farm. We did all that is required for these web parts to show.

  1. Our Farm License is Enterprise License
  2. SharePoint Server Enterprise Site Collection features” is activated at the Site Collection level
  3. We even tried activating Enterprise Site Collection Feature from Central Administration Central Administration > Operation > Upgrade and Migration > Enable Enterprise Features.
  4. Though we got a Category “Business Data” Only Indicator web part was listed there.
  5. We again tried to activate BizAppsSiteTemplate   Enable-SPFeature “4248E21F-A816-4c88-8CAB-79D82201DA7B” -URL http://<your-site&gt;
  6. Still no luck.

After activating SharePoint Server Enterprise Site Collection Features , I could see .webpart and dwp files in Web Part Gallery.

So I guessed the issue is no about the missing Feature but some Sort of security filtering. A quick look at the WebPartAdder class in reflector confirmed my theory (Web Part list is rendered based on Licencing), Though we have enterprise licencing, I remember we added a new set of Licencing to our Farm for our Office Web Apps Installation.

So I turned to powershell and ran this command, which listed all Licenses we have

PS C:\Users> Get-SPUserLicense


Then when I ran Get-SPUserLicenseMapping, I figured OfficeWebAppsEdit was set to the Farm for Domain Users, I guess this happened when we were configuring Office Web Apps. Sp I tried adding Enterprise License to all Domain Users using following command. Which fixed the issues.

$a = New-SPUserLicensing -SecurityGroup “Domain Users” -license Enterprise

Add-SPUserLicenseMapping -mapping $a

Hope this helps someone.

Categories: Uncategorized

One or more ActiveX Controls could not be displayed–InfoPath Ink Control Not working

December 5, 2013 Leave a comment

Today I was debugging an error in InfoPath Form, in particular InfoPath 2010 installed in an typical SharePoint Farm. Error was more generic and could deviating you from actual solution.

Error was

One or more ActiveX Controls could not be displayed because either:

1) Your current security settings prohibit running ActiveX controls on this page, or
2) You have blocked a publisher of one of the controls.

As a result, the page might not display correctly.


With this when you start you will obvious end up in links that will suggest some registry changes. And few links suggest you add web URL as trusted Site etc. After all these you will see the issue still.

After few tries you may change the query to see “Ink Control not working” which will lead you to results of articles taking about Ink Control not supported in browser enabled InfoPath forms.

At this point I figured, that It was something related to missing ActiveX control, Usually when you have Custom ActiveX control you need to deploy it to the system that will fill InfoPath forms, refer this link for details.But Ink Control is out of the box control and it should be part of system that has InfoPath Installed.

That is when I figured out that Ink Control is not for regular PC but it is intended to be used by Tablet PC users. So in fact error is right InfoPath filler could not locate the Ink Control Active X dll. How do we fix it, easy Install the Ink Control, which is part of Microsoft Windows XP Tablet PC Edition Software Development Kit 1.7. Once you Install InfoPath with Ink Control will just work fine.

Couple of take away here.

  1. You cannot expect end user system to have this SDK installed nor it is a corrective measure.
  2. Reason I said it is not a corrective measure is because of the fact, Ink Control was to help user draw something , not  to capture user signature (what most people think and use this for)
  3. Refer this to see an example of how it is used also Microsoft suggest that we use Digital signature not Ink Control for capturing Signature (because of security).
  4. If you have a pressing need then you can package the ActiveX control and deploy as part of the solution.

Let me know your thoughts.

Categories: InfoPath, SharePoint

New Release

February 18, 2013 Leave a comment

Yes, on eighteenth October of two thousand nine, my wife and me blessed with a baby girl. We had named her Diya. Last two weeks was very though as they both had few complication after birth, and by god grace it all went well now. So not to mention now I have an added responsibility.Definitely it is a different feeling to be a dad. Here is how she looks.


Diya I know some day you will read this Post and I wanted to let you know that as always I  love you so much.

Categories: Uncategorized

Join Two Array – Zipping

February 18, 2013 Leave a comment

Last week I had a requirement where I need to Join two array,there was no relation that I could use to  join LINQ.

Int32[] iArrayOne = {12,34,45,89};

String[] sArrayTwo= { “Value1”,”value2”,”value3”,”Value4”}

Later which I posted a question in SO,in fact it was not possible directly in LINQ.Eric has written a Post that solves my requirement. Yes the operation is termed as Zipping. Until .NET 4.0 we need to use the below snippet to achieve it and starting 4.0 we will have that function as part of the .NET.

public static IEnumerable<TResult> Zip<TFirst, TSecond, TResult>
(this IEnumerable<TFirst> first,
IEnumerable<TSecond> second,
Func<TFirst, TSecond, TResult> resultSelector)
if (first == null) throw new ArgumentNullException("first");
if (second == null) throw new ArgumentNullException("second");
if (resultSelector == null) throw new ArgumentNullException("resultSelector");
return ZipIterator(first, second, resultSelector);

private static IEnumerable<TResult> ZipIterator<TFirst, TSecond, TResult>
(IEnumerable<TFirst> first,
IEnumerable<TSecond> second,
Func<TFirst, TSecond, TResult> resultSelector)
using (IEnumerator<TFirst> e1 = first.GetEnumerator())
using (IEnumerator<TSecond> e2 = second.GetEnumerator())
while (e1.MoveNext() && e2.MoveNext())
yield return resultSelector(e1.Current, e2.Current);
Zipping operation is defined as   var qry = from row in iArrayOne.Zip(sArrayTwo, (temp1, temp2) => 
new { ArrayObject1 = temp1, ArrayObject2 = temp2 })
Tags : ,
Categories: .NET 4.0, C# 4.0

SharePoint Getting Started

February 18, 2013 Leave a comment

Few weeks back I saw a question in the Stackoverflow. The question was How to start learning SharePoint. Well at first it seem simple, I couldn’t get an answer straight away. I did a Google but no luck all links I landed up was about some SharePoint books. The user who posted the question specifically mentioned that he doesn’t want go through books to get the hold of it. Well I am of the same kind I hate going through 500+ pages books. Finally I answer the question on how I learnt SharePoint. Below is my answer for the question.

First step is to get created with a SharePoint site, from your System admin.

If you are the one who need to kick start the SharePoint. Then follow the steps and for each of the steps you can find ample number of links using Google

  1. Install SharePoint and Configure it.
  2. Create a Site Collection
  3. Go to the Site and in the Right Corner you will find a Menu called Site Settings
  4. Select that and play around with each and every options out there.
  5. Most of the options can be understood by the Name
  6. If you struck up some where come to SO or Start over again.
  7. Make sure that you always ask the question why this behaves this way & why this implemented this way.
  8. Try creating pages Same Site Settings Menu has option to create page.
  9. There is some thing called Web Part which is actually a Pluggable component UI/ functionally which can be customized as per the user needs.
  10. Try using those web parts (Lost of Out of the Box)
  11. Later move in to Web Part development,create your own, deploy it
  12. Start using the Microsoft.SharePoint.dll to access the SharePoint site using you custom code.

To give you a brief description.

Microsoft Office SharePoint Server 2007 is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive content management and enterprise search, accelerating shared business processes, and facilitating information-sharing across boundaries for better business insight. Additionally, this collaboration and content management server provides IT professionals and developers with the platform and tools they need for server administration, application extensibility, and interoperability.

  1. I call it as Application development platform
  2. For anything you wanted to do there will be a option directly / indirectly in SharePoint
  3. Basically it is a Web Application built on top of ASP.NET 2.0
  4. Main entry point to it is an Web Application (Central Administration Site) you get this once you install SharePoint.
  5. This is where you can Create Web Application (Nothing but a Site in the IIS & Content DB)
  6. Yes you read it right Database,SharePoint stores all its content in Database
  7. Web Application is directly not usable (Its like empty DB and Empty IIS site) you need to have some content to be display to the user.
  8. Then Site collection comes, it give content to the User.You need to at least create Site collection under Web Application (Through Central Admin).
  9. While Creating Site Collection you will be provided with a Site Template (Template is nothing but a Blue print sort of thing that will dictate what your site will look like and what it have) there are template For Project Management,Bug Tracking (has options to track Bug, kind of basic infrastructure that will be needed in any Bug Tracking system).
  10. Next level is Sub site, under site collection you can have Site( here too you have an option to select the template), and under that Site you can have another Sub Site so on.
  11. And there is another important thing in SharePoint called List, its a similar to Table in SQL server but not exactly same (because list content are internally stored in SQL Tables), and List contains Fields (Similar to Column in Table). You can use them to store your custom data. While creating the list also you will have Templates (Say for example to Represent a Announcement you have a template, this will have all the fields that are needed to represent announcement)
  12. And you have a Option to Create your own List Structure as well.
  13. There is a special kind of List in SharePoint called Document Library which can store documents.
  14. One final thing Security, managing Security is out of the Box. You can control who has access to you Site and what they can Access (Only Announcement , only Published documents) and what they can do with the item (Edit/Read-only/Delete) etc.
  15. You can create fine grained permission as you wish.


Categories: SharePoint


February 15, 2013 Leave a comment

It all started three+ years back a point of time when I was nurtured enough to find the information I wanted through Internet search, be it technical or general some way or the other I land up in a blog. Specifically that time SharePoint 2007 was in beta and there was very limited information over internet on the subject, As I saw most of the blog from the SharePoint Product team I was in a perception that blogs are meant to them, Later which I came to know about Blogspot which allows you to have your personal blog, I started one, but as there were so much to learn in SharePoint and have to spent all of my time in R & D to get the things working for my First ever Web CMS site based on SharePoint 2007, which was almost ready when the SharePoint RTM came out. I didn’t find time to update my blog. Another thing I hate about blog is the Editor I didn’t like the editor provided by the Blogspot as it is so small and was not able to type the content with ease. I didn’t know about the tools (Word 2007 / Live writer ) that will help you to do that with ease. Later I got inspired with WordPress for the rich set of tool it provide and the full screen functionality, which is when I started this.I was kind of used to update the blog at least twice a month.

As I started more blogging, I saw some pain points.Wordpress is pretty good at what they do and one limitation I was so concerned with the WordPress/Blogspot is that I don’t have more control on the template and the layout.I wanted to have more control on the website layout. I wanted to have more space for my content and it should be presentable to the user who is reading it. Soon I decided to have a blog for my own. I wanted it to be flexible enough I ran through couple of options, upgrade my WordPress account, but it wont allow me to change the layout even If I upgrade, also WordPress is running on PHP, I wanted my blog to running in something from Microsoft stack, ASP.NET. I was impressed by the theme used by Reza but then it was based on PHP WordPress. I finally know what my blog should look like but I didn’t know how to search for that template. Later I came across Tim site and it was running on ASP.NET. I mailed him and got the information that he uses Subtext Project as the blog engine. I then found that the theme used by Reza was inove from WordPress. Last weekend I spent whole time to get the theme applied in the Subtext. Next item was to chose a good provider and buy a host name. Lot of options, I was looking at everydns for getting a host name for free and net4 to host my site, but everydns didn’t work for some reason and net4 site is itself slow, It didn’t look good. Finally I got all under ZnetIndia, customer support is so cool and got complete thing wired with in 1 Hour. I had to setup the subtext with IIS 7 as you need to configure the App Pool to run in  the Integrated Classic more else you will end up in httpModule issue.

And after all this here is what it looks like. Thanks for reading it through so far and I would like to have a comment if you have one on my blog. I will be happy to share this site theme, if you want  just leave me a comment. Also I have planned to concentrate only on SharePoint SharePoint SharePoint and bit of .NET & ASP.NET.

Categories: Uncategorized

Microsoft SharePoint 2010 – Sneak Peek

July 14, 2009 Leave a comment

    Microsoft has announced the technical Preview for the SharePoint 2010.It is a limited invitation only. But we can have a Sneak Peek of what will be available in the SharePoint 2010.

    Watch the videos in the site, to give you some velocity here is the pictures and highlights from the sneak peek.


  • New Ribbon based UI
  • Support for Silverlight Web parts
  • Rich Theming (Allows you to change the Skin of the SharePoint site to similar to the Office Client)
  • Revamped Central Admin Design.
  • Visual Upgrade (Option to upgrade the 2007 site to 2010 without any UI changes) to change the UI to 2010 it’s a flip of the Switch.
  • Cool tools included in the Visual Studio 2010.(Visual Webpart designer, BCS Designer, Complete integrated option for developing Solutions)
  • LINQ Support.(Implementation of LINQ in SharePoint)
  • Developer Dashboard ( new dashboard for the developer that will help to view the Page loads, SP Request for the page, Web Part events stack etc)
  • Business Connectivity Services (Yes BDC has been renamed and now it supports Read & write as well)
  • External List (This is similar to List but the data are fetched from BCS)
  • Client Object Model (You have Client API to access the SharePoint list using Javascript)

Some more information in the Links from Reza and Info about the Office 2010 Products


Get every new post delivered to your Inbox.