SharePoint 2010

User Profile Web Service error when accessing from InfoPath Forms Services

In the last couple of weeks, we had to move a custom application from one SharePoint 2010 farm to another. We tested our migration method by moving it to a test farm first, which highlighted a few things that we needed to change, but it was otherwise successful. However, when we moved it to the new production farm, we ran into an error that we hadn’t seen in test. It occurred when we opened an InfoPath form that was calling the User Profile web service. The error presented to the user was a dialog ......

Carolina Code Camp 2013: Introduction to SharePoint Development

I spoke this weekend at the Carolina Code Camp on the CPCC campus here in Charlotte and my topic was an Intro to SharePoint Development for .NET Developers (those that have no knowledge of SharePoint). It’s a topic that I’ve been talking about often with new and experienced devs alike, who want to know everything from how to set up a development environment to how to start coding and what can SharePoint do. From my experience, a lot of the intro presentations given focus on writing those first lines ......

How to delete SharePoint alerts for orphaned (deleted) users–WSS 3.0/SharePoint 2007/2010

An issue came up at my client recently, where our webmaster email account was being flooded with non deliverable email notices. Messages were bouncing back because our SharePoint farm was sending alerts to users and email address that no longer existed. This was on a WSS 3.0 farm, and we don’t have any third party tools (like Axceler’s ControlPoint) to help manage scenarios like this. So, I decided to tackle the problem with PowerShell. Of course the first step in writing a PowerShell script is to ......

WSS 3.0 to SharePoint 2010: Tips for delaying the Visual Upgrade

My most recent project has been to migrate a bunch of sites from WSS 3.0 (SharePoint 2007) to SharePoint Server 2010. The users are currently working with WSS 3.0 and Office 2003, so the new ribbon based UI in 2010 will be completely new. My client wants to avoid the new SharePoint 2010 look and feel until they’ve had time to train their users, so we’ve been testing the upgrades by keeping them with the 2007 user interface. Permission to perform the Visual Upgrade One of the first things we noticed ......

SharePoint Training Resources–Update

A couple of weeks ago I taught a SharePoint Designer 2010 class. During preparation for the class, and working with 2010 for six months, I’ve collected the following training content (some of these might be 2007 related): http://www.sharepoint-video... http://www.youtube.com/user... http://www.microsoft.com/le... http://msdn.microsoft.com/e... ......

Can’t install Transport HUB in Exchange 2010

When building my latest SharePoint 2010 demo virtual machines, I decided to try installing Exchange 2010 as well. Now, I’m not an Exchange admin, but I thought “how hard can this be?” Well, a little more than I thought. Pretty early during the install, I got an error saying that it couldn’t “install Transport HUB”. I double checked that my VM was meeting all of the requirements, both hardware and software, and everything looked fine. After much researching, it turns out that the error was caused ......

SharePoint 2010: Taxonomy feature (Feature ID "73EF14B1-13A9-416b-A9B5-ECECA2B0604C") has not been activated

I ran into an error message in SharePoint 2010 that took me a few minutes to figure out. I was working on a demo of SharePoint 2010’s managed metadata and getting an error when I was adding a Managed Metadata column to a library. A little Google research turned up this blog post: The Taxonomy feature (Feature ID "73EF14B1-13A9-416b-A9B5-EC... has not been activated. As Michal Pisarek pointed out last June, you get the error because the Taxonomy feature isn’t activated. Like Michal, I’m not ......

SharePoint 2010 MSDN Labs

Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mss... He also posted other resources as well. I’ve copied his Virtual Lab links here: SharePoint Server 2010 Virtual Labs MSDN Virtual Lab: SharePoint Server 2010: Introduction ......

SharePoint 2010 Client Object Model – CAML Query inaccurate results error

I ran into a frustrating scenario today, while working with SharePoint 2010’s Managed Client Object Model. My application queries a SharePoint document library using the file’s name (the FileLeafRef field). Given that this field is unique, I was expecting only one result with the following code: 1 CamlQuery qry = new CamlQuery(); 2 3 //filter the results to only get back the item with the filename we're looking for 4 qry.ViewXml = string.Format( 5 "<Query><Where>... ......

Error when trying to access SharePoint 2010 via PowerShell in a new environment

I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL ......

Error creating PowerPivot Service Application in SharePoint 2010 (SP1 + June 2011 CU)

A few weeks ago I ran into an error while setting up our test farm. I was creating the service applications and when I got to PowerPivot, I got the following error: I was able to work around this error by using PowerShell to create the service application. Background First, some details of our installation: two web front ends, two application servers, and one SQL server. All are running Windows Server 2008 R2 x64 with Service Pack1. The SQL Server is 2008 R2 with SP1. The SharePoint servers are SharePoint ......

SharePoint 2010 Not Indexing OneNote 2010 files

Our SharePoint team at work noticed that our SharePoint 2010 farm wasn’t returning search results based on the contents of OneNote files that were saved in document libraries. I did a little research and found a solution, by putting together steps from different posts. First, some details: we’re running SharePoint 2010 SP1 (with the June 2011 CU) on Windows Server 2008 R2 SP1. However, this issue was seen before we applied the service packs and cumulative updates, so I’m not sure what effect, if ......

SharePoint 2010 Administrator Training – UPDATE

I wrote a post last August with details about what materials I used in order to study for the two Microsoft SharePoint 2010 Administration Exams (70-667 & 70-668) : http://kellydjones.com/arch... This question still comes up a lot, so I thought I’d post an update with some more learning materials. First, I’ve recently discovered Safari books online. Safari books online has a lot of SharePoint books, including Wrox books – which I’ve found that I keep gravitating to. There’s ......

Automatically setting file name when submitting InfoPath 2010 Form

After creating my InfoPath form and setting it to publish to a Forms Library in SharePoint 2010, I found that I wanted to fine tune the experience that the user has when submitting a form. The first thing to change was the annoying dialog asking the user for a filename. Many users will have no idea what SharePoint is asking them for, or worse, they enter a name that’s already used by another form (and either overwriting it or getting an error). To see what I mean, simply create an InfoPath 2010 form ......

Using InfoPath 2010 with SharePoint 2010 Content Types

There are a couple of ways to integrate Content Types with InfoPath forms libraries. I’m going to cover one scenario, but I’m sure there are more. My scenario is that I want to submit a form to a SharePoint 2010 Forms library and align the data collected on the form to existing columns in my Content Type. Here’s a summary of the steps: · Create a Site Content Type in SharePoint 2010 (my example is HR Forms) · Create a Forms Library in SharePoint 2010 (my example is HR Forms Test) · Add the Site Content ......

Adding Intellisense to Visual Studio 2010 for SharePoint 2010 ECMAScript / JavaScript

Several people have already written about how to add Intellisense to Visual Studio for SharePoint 2010’s Client Object Model (ECMAScript or JavaScript). Here’s one that I followed: http://praveenbattula.blogs... Following those instructions, mine still didn’t work. I finally got it to work after removing the <script> tags in my file ......

SharePoint 2010–Error when deleting Content Type In Use

UPDATE! July 8th, 2011 -- I’ve been reading Chris Poteet’s blog for a while (probably since Day of .Net Ohio in 2008 or 2009) and he recently started a new blog covering odd user interface quirks and inconsistencies with SharePoint. He’s titled the blog, Unexpected Error. Well, today Chris was kind enough to mention me for follow Friday on Twitter and I followed the link to his blog again – and was stunned to see that I had written a post this week that is pretty much the same one he wrote two weeks ......

Illegal characters for SharePoint 2010 Content Type name

Quick tip: you can’t include a backslash in the name of the SharePoint 2010 Content Type. In fact, there are several illegal characters: \ / : * ? " # % < > { } | ~ & , two consecutive periods (..), or special characters such as a tab. What, you didn’t know that after entering one of these characters in the name? Is it because you saw this screen: Oh, that’s right….you need to turn off custom errors in the layouts folder…See this blog post for details and you’ll also need to turn off for ......

SharePoint 2010 Developer Training

I’ve written a couple of posts about SharePoint 2010 Administrator training/learning, so I thought I should follow up with some tips for developer training as well…. Microsoft has two exams for SharePoint 2010 developers. The first is Exam 70-573, Application Development. The second is Exam 70-576, Designing and Developing Microsoft SharePoint 2010 Applications. Those links cover the topics for each exam as well as some Microsoft preparation materials. One of the best sites, and one that I relied ......

SharePoint 2010 Managed Metadata Column limitation – Error 81020030

The Short Story: There is an undocumented (as of this writing) limitation to SharePoint 2010’s managed metadata columns: they only allow ~250 entries into one column, for one item. If you exceed this limit, you’ll most likely get this error: <nativehr>0x81020030&... URL 'SitePages/Test Page.aspx' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. We haven’t identified ......

Site Column names with special characters: Errors in Calculated Columns

I ran into an interesting scenario when a colleague of mine was setting up a list in SharePoint 2010. He was creating a list, with a phone number column, a phone extension column, and a calculated column for phone display. Things were working fine, until he entered some data and the display column didn’t look right. When he opened the settings for the phone display, he saw this in the formula: #NAME?-#NAME?After some tinkering, we got it to work by changing the name of the phone extension column. ......

Quicktip: SharePoint Service Account Username lengths

Here’s a quick tip for something that I ran into again this weekend. I was creating service accounts in my development environment’s Active Directory, and one of the names was a little long. My account name was: AccessServicesAppPool . When I went to SharePoint Central Admin and tried to add my new service account, I kept getting an account not found message. I even cut-n-pasted the user name, but that didn’t work. What I failed to notice was that the “pre-Windwos 2000” login was truncated by one ......

Why won’t my rule work in SharePoint 2010 Content Organizer?

Quick tip: if you are having problems with rules in the new Content Organizer Feature of SharePoint 2010, double check that the Content Type your rule is using is based on a Document Content Type. I discovered this when a co-worker was setting up a demo with the Content Organizer. He had selected a Content Type at random and configured his rule. SharePoint allowed him to do this but when documents were added to the drop box library, the rules wouldn’t be applied. So, I set up a demo on my SharePoint ......

Tip: How to determine which SharePoint web front end you’re hitting

Have you ever set up a SharePoint farm with multiple WFEs (web front ends) and then wondered later which server you were hitting? Ever have a user get an error but you can’t recreate it, only find to find out much later it’s because the user was hitting a different WFE than you were and that particular WFE was the only one with the error? Or have you ever had a misconfigured hardware load balancer that is directing all of the traffic to just one poor overloaded WFE while the others sit there idle? ......

Excel Services REST API in SharePoint 2010–simple sample

I started a new SharePoint 2010 project several weeks ago and one of our first assignments was to create a quick demo to highlight some of the new 2010 functionality. In our discussions about 2010, my Sogeti colleague mentioned that far and away his favorite new 2010 feature was the Excel REST API. I wasn’t that familiar with it, so I offered to set up that part of the demo. I have a SharePoint 2010 server running in a virtual machine, with Excel Services already configured. Please note: if you are ......

SharePoint 2010 Administrator Training

I recently passed both of the Microsoft SharePoint 2010 Administration exams (70-667 & 70-668) and I’ve been asked what I used to study for them. In order to help answer this question in the future, I put this post together. First, here are some free resources that I used: http://sharepoint.microsoft... http://technet.microsoft.co... http://channel9.msdn.com/le... ......

Twitter