.Net Framework "geography" error on get latest/commit

datacentricity

Two out of three developers on my team are experiencing the following error when attempting a get latest or /(identify changes to) commit.

A .NET Framework error occurred during execution of user-defined routine or aggregate "geography"

This error has only started happing recently and only on one (out of several) databases. The affected database is the only one that makes use of the geography data type. We have been using SQL Source Control against this database (dedicated model) for the last two years without issue. This has only started occurring in the last few weeks. We have tried submitting this from within SQL Source Control but have not had a response.

Details are as follows:

OS: Windows 7 Enterprise, SP1 64 bit
SQL Sever: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86) Developer Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)
SQL Source Control: Version 4.0.6.179 (also affects 4.1.8.41 and 4.1.13.94)

However, the developer that does not experience this problem is also at v4.1.13.94

Error Details: On the “Commit Changes” and “Get Latest” tabs:

A .NET Framework error occurred during execution of user-defined routine or aggregate "geography":
System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
System.EntryPointNotFoundException:
at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
at Microsoft.SqlServer.Types.SqlGeography.IsValidExpensive(Boolean forceKatmai)
at Microsoft.SqlServer.Types.SqlGeography..ctor(GeoData g, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)

Alex B

Hi datacentricity,

I found the error report with internal reference SOC-7621 so thank you for that! I've found this page which seems to indicate this is an issue with Microsoft.SqlServer.Types.dll v11.0.0 (file version: 2011.110.2011.60 ) which comes as part of MS SQL Server 2012 SP3, but you are indicating only 2012 SP1 is installed.

Can you please check what version of this file you have? Have you installed then removed SP3 from any of these machines?

Kind regards,
Alex

datacentricity

Thanks for the response:

Interestingly, my machine on which SP3 is installed has the following DLL versions including the one that has a problem but does not exhibit this error:

Microsoft.SqlServer.Types Version: 10.0.0.0 File version: 2009.100.2500.0 Product Version: 10.50.2500.0
Microsoft.SqlServer.Types Version: 11.0.0.0 File version: 2011.110.6020.0 Product Version: 11.0.6020.0
Microsoft.SqlServer.Types Version: 12.0.0.0 File version: 2014.120.2000.8 Product Version: 12.0.2000.8

More weirdness... Both the colleagues who have this error were not actually able to install SP3 (obviously not a Red-Gate issue) - when they tried they just got "this product has nothing to update" or some such message. So either some of the DLLs were still deployed during that process, or something else deployed them previously (VS2012 or SSDT/BI updates perhaps?) leading the SP3 installer to believe that SP3 was already present.

My colleagues eventually resolved their problem by rolling back to an earlier service pack so thank you for your help. This is clearly nothing to do with RedGate.

Looks like we'll stick with SP2 for now.

Alex B

Hi datacentricity,

Glad that helped get it sorted! Please let us know if you run into any other issues.

Kind regards,
Alex