While working on a migration project of a SharePoint 2010 to SharePoint 2013 site collection using BI, I found quite a few bugs. One of them is that, when you go in “All Site Content”, the PowerPivot Gallery doesn’t show the image, or better said, cannot show the image.

No image for PowerPivot Gallery in SharePoint All Site Content

It’s not the biggest SharePoint bug, however it can be annoying especially for end users. I opened up Chrome Dev tools, and I found out the source of the bug… the developers did a spelling mistake in the image reference. Instead of PowerPivot… meet the new LowerPivot.

It’s pretty hard to change the code that brings this bug and given the importance of it, it won’t probably be fixed by Microsoft soon, so here is how you can easily fix it in your farm. Navigate to “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\TEMPLATE\IMAGES\PowerPivot” and no, 14, is not a spelling mistake! Even if we are in SharePoint 2013, the picture still resides in the 14 hive.

Copy the “powerpivot_32_32.png” image, and name it “lowerpivot_32_32.png”. You will now have to exact images with different names in the layouts folder.

At the end, everything should work well and you will see the pretty PowerPivot Gallery image!

Drop a comment if this helped!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

Last month, I created a step by step tutorial on how to Create a SharePoint 2013 Farm in Azure Step by Step by using the new “SharePoint Farm” template in the new (and still beta) Azure portal.

One of the most popular questions I got is how much does a farm in azure cost? So, I decided to sacrifice my monthly Azure credits for the community in order to give you the exact answer.

SharePoint farm in Windows Azure cost

So by using the same step by step I started to create my farm at exactly 1PM on Day 0. I created a SharePoint farm that respects the SharePoint Minimum requirements and should be able to run a good development environment without any problems. At the moment of starting the wizard, I had exactly 157.48$ left on my MSDN Subscription.

DC SQL SharePoint
VM Template A1 A5 A4
RAM 1.75 GB 14 GB 14 GB
Number of Cores 1 2 8

 

The SharePoint Farm was successfully deployed at 2:18 PM on Day1 and I used it very lightly for about one hour.

In order to determine when exactly my credits finished, I used the email that Azure sends when your credits run out. So, I received the email at 4:48 PM on Day 8. Therefore, 157$ gives us about 194.5 hours of a SharePoint farm in Azure. So, if you work about 9h per day, for 20 days a month, that makes 180h so, provided you turn off your Virtual Machines at night, you should have enough time to run your SharePoint farm for free in Azure!

However, please note that under heavy usage, you might have a lot more bandwidth & storage usage than I did on the farm I barely even played it, so you might get a little less time than I got in this test.

If anyone has other metrics that they took from their experiments with SharePoint in Azure or tips on how to make your SharePoint farm last longer on the credit, please do not hesitate to share!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

Microsoft Virtual Academy is a website created by Microsoft that has a ton of free learning material about its products. Since Office 365 is a growing trend, I decided to create a list of some SharePoint related MVA Courses you can watch whenever you want!

SharePoint Microsoft Virtual Academy

DEV:

IT Pro:

Office 365

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

To welcome to New Year, Microsoft Learning brought back the very popular Second Shot Offer for MCP exams! For those who are not aware, the Second Shot offer allows you to retake an exam if you failed it the first time between January 5th 2015 and May 31st 2015!

Second Shot Offer

Since Microsoft stopped dealing with Prometric, all exams are now taken at Pearson Vue testing centers and scheduled directly from your MCP portal and there is no coded needed! Here is some information about the Second Shot offer:

What exams are included in this offer?

All of the Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE), Microsoft Certified Solutions Developer (MCSD), and Microsoft Specialist certification exams are eligible. Microsoft Technology Associate (MTA) exams and Microsoft Office Specialist (MOS) exams do not qualify for this promotion.

How do I get my free retake?

When you register to take an MCP exam between January 5, 2015, and May 31, 2015, you become eligible for a free retake if you don’t pass it. You have 30 days from the date you took the initial exam to schedule a retake. To schedule your retake, sign in, select your exam from the exam list, and click Schedule now for free.

You can also read the Frequently Asked Questions(FAQ) over here> https://www.microsoft.com/learning/en-us/second-shot.aspx#dl-ID0EAAABBA

Second Shot Offer

To see the offer, check out the official page over here > https://www.microsoft.com/learning/en-us/second-shot.aspx

After migrating a Site Collection that had a PowerPivot Gallery on it from SharePoint 2010 to SharePoint 2013, I had users complaining that the PowerPivot Gallery was blank and not showing anything. My first reaction when starting to debug was “This still runs on Silverlight?” … and yes it does still run on Silverlight. The code inside the html file looks something like this:

Blank PowerPivot Gallery

Everything seemed ok and it worked in SharePoint 2010, then I realized that Microsoft renamed the “XAP” addin between SharePoint 2010 & SharePoint 2013. As you can see in the following screenshot, in SharePoint 2013 (top) it’s called “Microsoft.AnalysisServices.SPAddin.ReportGallery.xap” while in SharePoint 2010 it was called “Microsoft.AnalysisServices.ReportGallery.xap”.

Because the XAP file name is hard coded into the Silverlight file for the PowerPivot Gallery, SharePoint does not find it and therefore shows a blank gallery. To fix it, simply change the name in the HTML file for your gallery. It should look something like this in the end.

Afterwards, you save it and your Gallery should work again!

Drop a comment if this helped!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

Top 10 Most Popular Blog Posts of 2014

Categories: Other
Comments: No

With the year almost over, I always take some time and look back what where the most popular posts of the year in order to see what SharePoint users all over the world are interested in reading. Without further talking, here are the top 10 Blog Posts on my blog on 2014.

Top 10 Most Popular Blog Posts of 2014

1 – SharePoint 2013 Service Accounts Best Practices Explained – 41,562 Views

Service Accounts are a very big part of installing almost every version of SharePoint, however everyone has a different way of setting them up. And once you install your SharePoint with a set of service accounts, it’s easier to do a clean install than to change them all. In this blog post you will learn what the best practices are for a successful SharePoint Installation. Read it here > http://absolute-sharepoint.com/2013/01/sharepoint-2013-service-accounts-best-practices-explained.html

2 – Install SharePoint 2010 Service Pack 2 the right way- 21,001 Views

This article will be focused on some questions I got from SharePointers from SharePoint-Community.Net and also from friends… How do I patch my SharePoint 2010 farm the right way? Read it here > http://absolute-sharepoint.com/2013/08/install-sharepoint-2010-service-pack-2-the-right-way.html

3- How to move a List from SharePoint 2010 to SharePoint 2013 – 12,275 Views

I recently had a client ask me, how he could migrate only a list from SharePoint 2010 to SharePoint 2013 by keeping the data in it. I tried a quick Google, and nothing came up. I tried to export the list into a .cmp file, and import it into SharePoint 2013, but I got this Error. Importing SharePoint 2010 Files is not supported in SharePoint 2013. Read it here > http://absolute-sharepoint.com/2013/08/how-to-move-a-list-from-sharepoint-2010-to-sharepoint-2013.html

4- The Ultimate Script to download SharePoint Conference 2014 Videos AND slides! – 10,770 Views

After everyone posted about 10 script versions to download the SharePoint Conference 2014 videos I decided to add some extra value before releasing mine! This script has been very popular this year on other blogs as well. Read it here > http://absolute-sharepoint.com/2014/03/ultimate-script-download-sharepoint-conference-2014-videos-slides.html

5 – Microsoft killing some features in Office 365 SharePoint Online – 10,180 Views

In the past few weeks, Microsoft has slowly started to kill some features from SharePoint Online. Before we go on, here are some of the features that you will slowly see disappear from your SharePoint Online tenant…. Read it here > http://absolute-sharepoint.com/2014/09/microsoft-killing-features-office-365-sharepoint-online.html

6-Create a scripted SharePoint 2013 Development Environment Tutorial – 8,817 Views

Creating a SharePoint Development Virtual Machine is something you might have to do quite a few times as a Developer. Even if it’s a pretty easy process, on a slow machine it can easily kill 4-5 hours of your day only to install SQL, SharePoint, Visual Studio and all the others tools you might need to get started. What if you could just script it so it’s all done automatically while you go take coffee, chat on SharePoint Community or whatever else you enjoy doing? In this tutorial we will learn how to build a script that we will keep using for as long as you keep developing on SharePoint 2013. Read it here > http://absolute-sharepoint.com/2013/10/create-a-scripted-sharepoint-2013-development-environment-tutorial-part-1.html

7-Step By Step Guide to configure the “Replicating directory changes” for SharePoint 2010 and 2013 – 7,903 Views

This guide is a step by step guide with Screenshots to give the “Replicating Directory changes” rights to the SharePoint user profile account that will be used to synchronize the user profiles. The screenshots were taken in Windows Server 2012, however the steps are identical or very similar in Windows Server 2008 and 2008 R2. Read it here > http://absolute-sharepoint.com/2012/12/step-by-step-guide-to-configure-the-replicating-directory-changes-for-sharepoint-2010-and-2013.html

8- SharePoint 2013 Site Template ID List for PowerShell – 6,564 Views

When creating a new Site Collection or Web Application by PowerShell, we have the option to apply the Site Template Directly. However, for PowerShell to accept it, you must give it the Template ID (EX: #STS1). Here is the SharePoint 2013 Site Template ID List for PowerShell. Read it here > http://absolute-sharepoint.com/2013/06/sharepoint-2013-site-template-id-list-for-powershell.html

9-Step By Step Guide to configure the Managed Metadata Service Application for SharePoint 2013 – 6,530 Views

This guide is a step by step guide with Screenshots to create and configure a Managed Metadata Service Application in SharePoint 2013 as well as a Content Type Hub. It’s a really easy tutorial that should take maximum 30 minutes to complete! Read it here > http://absolute-sharepoint.com/2013/02/step-by-step-guide-to-configure-the-managed-metadata-service-application-for-sharepoint-2013.html

10 – SharePoint 2010 VS SharePoint 2013: Minimum Requirements – 6,336 Views

This post is about the Minimum Requirements for SharePoint 2013. I also contrast them with SharePoint 2010’s Minimum Requirements. This will also help you see if your current SharePoint 2010 Infrastructure is ready for an upgrade to SharePoint 2013. Read it here > http://absolute-sharepoint.com/2012/10/sharepoint-2010-vs-sharepoint-2013-minimum-requirements.html

 

As for the overall stats on my blog, it has been a very good year with almost 300 000 Pageviews and over 170 000 Unique Visitors!

Also, when I compare the stats to last year, I can see that the blog has been a lot more visited, but since I shared a lot more news & quick fixes then last year, some of the stats went down.

I hope you all liked my blog posts in 2014 and I am already preparing some for 2015! Don’t forget that in order to see my blog posts the soonest possible, you can follow me on twitter @vladcatrinescu or like the Absolute SharePoint Blog page on Facebook. If you follow on Facebook, the best way to get notified is to go on the page and choose the “Get Notifications” option. This way you will get a notification every time I post a blog post. Don’t worry about receiving too many since I only do one blog post per week, unless it’s really something important, in which case you won’t want to miss it anyway!

Have a great Holiday Period and looking forward to see you all in 2015 at Ignite!

Today I was at a client for a new SharePoint 2013 installation and I kept having strange errors when running the SharePoint 2013 Prerequisite installer! Here is the error stack I got:

WARNING: 2014-05-28 16:09:48 – Error: Call to StartService function to start the service failed (0X422=1058)

WARNING: 2014-05-28 16:09:48 – Error: [In HRESULT format] (0X80070422=-2147023838)

WARNING: 2014-05-28 16:09:48 – Error: Unable to start windows update service (0X422=1058)

WARNING: 2014-05-28 16:09:48 – Error: The tool was unable to install Windows Server AppFabric.

WARNING: 2014-05-28 16:09:48 – Last return code (0X422=1058)

It took me a while to find the fix, but it was easy! To fix this error, you simply have to make sure that your Windows Update service is not set to disabled! Just set it to Start Automatically and start it, and your prerequisite installer will run with no problems afterwards!

Leave  a comment and don’t forget to like the Absolute SharePoint Blog Page on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

Next Tuesday, December 2nd 2014, I will be hosting a webinar together with Datapolis to talk about workflows, and more particularly SharePoint Designer Workflows. Here is the info:

Process automation is one of the most wanted benefits that SharePoint offers. In this session we will look at three must have workflows for SharePoint by using SharePoint Designer as well as a lot of useful tips and tricks that can be used in any SharePoint 2010 & SharePoint 2013 workflows.

 

Agenda

 

During this webinar you will learn how to:

- Improve business processes with workflow logic

- Select the workflow which meets your process requirements

- Choose between SharePoint Designer and other solutions depending on your needs

 

Duration

 

60 minutes

 

Speaker

Vlad is a SharePoint Consultant with more than 5 years in IT specializing in analyzing and deploying your perfect SharePoint infrastructure. He is currently working as a President and Senior Consultant at his own company: vNext Solutions. Vlad is currently the youngest SharePoint MVP in the world and is known in the community for his technical abilities and for founding the biggest and most active SharePoint Community that you can find at www.SharePoint-Community.net. Vlad also has his own blog at http://www.absolute-sharepoint.com and he often shares his knowledge by speaking at local conferences and community events.

 
 

Please note the event is at 10AM Eastern Time on the registration page of the webinar you can switch timezone to be able to see them in your timezone.

 

Register here: https://attendee.gotowebinar.com/register/1271680118121811714?source=spcommunity

Today I was at a client and we wanted to create a new Managed Property called “EntityName”. It looked simple, just create a new manage property, set your options, click OK and it’s done! However, we got this strange error:

internal problem connecting to or querying the database

“The settings could not be saved because of an internal error: There was an internal problem connecting to or querying the database.”

After reading the error message, my first reaction was checking if the SQL was up and I didn’t have any Access Denied errors in the Event Viewer. However, everything looked up. I then looked up in the ULS and found the following log:

SqlError: ‘Violation of PRIMARY KEY constraint ‘PK_MSSManagedProperties’. Cannot insert duplicate key in object ‘dbo.MSSManagedProperties’. The duplicate key value is (EntityName, 0).’ Source: ‘.Net SqlClient Data Provider’ Number: 2627 State: 1 Class: 14 Procedure: ‘proc_MSS_AddManagedPropertyEx’ LineNumber: 52 Server: SQLSERVER,1433′

SqlError: ‘The statement has been terminated.’ Source: ‘.Net SqlClient Data Provider’ Number: 3621 State: 0 Class: 0 Procedure: ‘proc_MSS_AddManagedPropertyEx’ LineNumber: 52 Server: SQLSERVER,1433′

According to the log, there is already a managed property called “EntityName” in Managed properties, however when I do a Search for it, it doesn’t show up!

I wanted to know more on the problem, so I went to SQL Database (PS: Microsoft doesn’t recommend you to do this!) and looked what’s inside the ‘dbo.MSSManagedProperties’ table. I then found something really interesting, there is a field called “Hidden”! And no surprise, my “EntityName” was in there:

So, to help you in the future, here are all the hidden Managed Properties in SharePoint 2013:

PID FriendlyName PID FriendlyName
0 All

2147418060

ows_taxId_SPLocationSite
2147418028 AnchorLink

2147418054

PHFlags
2147418033 BaseHref

69

PluggableSdid
2147418035 ChangeID

2147418042

PluggableSecurityBlob
2147418048 ChangeIDEnd

2147418089

PluggableSecurityTrimmerId
9 ContentExcludeFromSummaries

99

QIRExternal
2147418058 CrawlLogLevel

2147418057

RankPrecalBottom
2147418036 CrawlObjectID

2147418056

RankPrecalTop
2147418090 CrawlUrl

2147418019

RedirectedURL
2147418034 CRC

2147418018

Robots
2147450879 DefaultProperties

330

SameEnumDepthProps
2147418016 DirLink

2147418080

Scope
2147418021 DirLinkSecurityUpdate

2147418027

SecurityBlob
2147418020 DirLinkWithTime

2147418053

SecurityId
2147418026 EndAnchor

2147418031

SecurityProvider
2000000001 EntityName

2147418038

SiteContainer
2000000002 EntityNamespace

2147418088

SocialDistance
2147418022 FollowAll

2147418091

Summary Description
2147418023 FollowNone

70

TAUCCLICK0
12 IndexDocId

71

TAUCCLICK1
2147418037 IndexRare

72

TAUCCLICK2
183 InternalExpiresInDays

73

TAUCCLICK3
674 IsPartiallyProcessed

74

TAUCCLICK4
2147418039 LinkHRef

2147418049

TAUCCLICKNOTIFY
2147418040 LinkOfficeChild

2147418051

TAUCDISPLAYURL
2147418041 LinkOfficeChildList

2147418050

TAUCTITLE
2147418043 NonDocument

2147418046

TempAuthor
2147418024 NormalizedForwardURL

2147418062

TempLastModifiedTime
2147418025 NormalizedURL
68 NtSdid
2147418044 ows_MetadataFacetInfo
2147418045 ows_SPLocationInfo
2147418059 ows_taxId_SPLocationInfo
2147418061 ows_taxId_SPLocationList

So, to fix this problem, make sure you name your new Managed Property something that is not in the columns above!

Leave  a comment and don’t forget to like the Absolute SharePoint Blog Page on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

I was working at a client that was configuring Business Connectivity Services to bring data from an ERP into SharePoint. Of course, the main benefit of bringing it to SharePoint was being able to Search information using the powerful SharePoint 2013 Search Engine.

As you see in the following screenshot, I had 4 External Content Types from which I wanted to bring information in SharePoint. This guide assumes your profile pages for your External Content Types were already created!

First of all I created a new Content Source, setup all the options and run my full Crawl, I was able to search the data in SharePoint! Great!

However, the benefit of SharePoint Search is that you can heavily customize the search in order to bring results that really matter to the user. So, in my Enterprise Search Center, I wanted to add tabs that would only show me results from Projects or Clients. So, I created a new Search Page by clicking on the “Add Page” link in the Search Center and naming it “ClientResults”.

I then went into Site Settings > Search Settings and added a new “link”. I pointed it to “/search/Pages/ClientResults.aspx”

So Now, I did the same for “Projects” As well, so now when I go into my Search Center and click the arrow, I got the “Projects” and “Clients” choices!

But, whenever I Search, it doesn’t filter anything! It’s basically the same as “Everything”. We got to go change this! I will show the screenshots from the point of a SharePoint Administrator, however you can do this even if you don’t have access to the Central Administration! If you are a Power User, you can follow the tutorial from Site Settings > Search. We will use the “Schema” and “Result Sources” option.

Back to Central Administration > Service Applications
> Search Service Applications , on the bottom left, you will click on the “Search Schema“. And then Create a New Managed Property

Here are the Details I gave it:

 

 

Now, in the Mappings to crawled properties part, click on “Add a Mapping

In the “Business Data” Category, choose the “EntityName” crawled property and select OK.

 

Now, just click on the OK button and the managed property will be created!

 

Now that we got our managed property, we will need to do a full crawl of both the BCS and the SharePoint Content Sources! This will make sure that the data is crawled, as well as the search schema is updated!

After the full crawl is done, we will go in the Search Service Application > Result Sources and then click New Result Source.

After you fill the initial information, launch the “Query Builder

Create a Result Source for a BCS Entity

 

In the Query Builder, we will focus on the “Property Filter” part. First of all, click on the “Select Property” dropdown, and choose to “Show all managed properties”


Afterwards, reclick on the dropdown, select the BCSEntityName managed property we just created. The operation must be “Equals“. And then you will choose “Manual Value“. In the textbox right under, insert your database name, in my case it’s “client“. And then click on “Add property Filter“.

We will then click on the “Test Query” button. If everything is ok, you will see a bunch of your records and they are pointing to the good URL of your Profile Page!

Once that works , click on Ok to close the Query Builder, and then OK again to save your new Result Source!

Now, all we have to do is modify the Search Page to show us the right stuff! Navigate to your Search Center, Search for something random and go to the “Clients” Tab. Then, click on the settings wheel and click on “Edit Page”

Then, Edit the Search Results WebPart.

Click the “Change query” button.

 

In the Select a Query dropdown, choose the ClientBCS option! You can then customize it further in the Refiners & Sorting options, however we won’t go there in this tutorial. Click OK.

 

Afterwards, click OK on the “Edit WebPart” window.

Afterwards, check in the page and publish it! Now when you search in Clients, you should only find Client Names and nothing else! You are done!

Leave  a comment and don’t forget to like the Absolute SharePoint Blog Page on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.