SharePoint 2013 geolocation column: a component is not installed

If you have followed the previous post about geolocation fields, probably you will in a “hurry” as the following:

Once you added the Bing maps key, created a custom list and added the geo location column via code to that list. Upon submitting a new listitem, you received an error, mentioning that a component was not installed, to be able to use geolocation. After checking the Diagnostic log, you’ll noticed the following error:

A required component for using a geolocation field is not installed: Microsoft SQL Server System CLR Types

This remembered me that I had read somewhere (this means: It’s not in the geo location MSDN documentation.It’s written in the documenation on mobile apps and geolocation) that the Sql Server System CLR Types needed to be installed on the Web Front End servers. The package that needs to be installed is called “SqlSysClrTypes.msi”, and depending on the version of SQL that is used, one of the following feature pack needs to be installed:

Sql Server 2008 R2 SP1 Feature Pack

SQL Server 2012 Feature Pack

After the installation, I still couldn’t add any items to the list. An IIS Reset didnt work for me but a reboot did the trick.

Source: https://technet.microsoft.com/en-us/library/fp161355.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s