Issue: Customers may experience the error exception below when installing the TIBCO Cloud Integration - Connect on-premise agent on the same application server with Microsoft SQL Server 2012 (v11.0.7001.0) installed. It appears that there was a change in the Microsoft SQL Server System CLR Types (SQLSysCLRTypes.msi) library between SQL Server 2012 SP2 (11.0.2100.60) and SP3 (11.0.6020.0) and this problem can be fixed by upgrading this package to the latest version corresponding to 2012 SP4 / 11.0.7001.0 at time of writing.

Error from Windows Event Viewer logs:
The type initializer for 'ExtentPlaceholderCreator' threw an exception. 

Error from the TIBCO Scribe Online on-premise agent logs:
--- Inner Exception --- 
Type : DllNotFoundException
Message : Unable to load DLL 'SqlServerSpatial110.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
StackTrace : at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)

**Please note that this only applies to Microsoft SQL Server 2012 (v11.0.7001.0). Also, reach out to your DBA for more information about installation and configuration.**

 

This article explains what the error message 'Unable to load DLL 'SqlServerSpatial110.dll' means and provides the steps on how to resolve it.

To resolve the error, download and install the x86 (32 bit) and x64 (64bit) versions of the CLR types DLL (SQLSysClrTypes.msi) from the Microsoft® SQL Server® 2012 SP4 Feature Pack. 

Microsoft® SQL Server® 2012 SP4 Feature Pack > Microsoft® System CLR Types for Microsoft® SQL Server® 2012 SP4 (SQLSysClrTypes.msi) 
https://www.microsoft.com/en-us/download/details.aspx?id=56041