EventContextProvider logs grow uncontrollably citing SQL DLL not found

EventContextProvider logs grow uncontrollably citing SQL DLL not found

Symptom

Customers may experience the error exception below that grows every 5-10 minutes in SQL Server 

Message: Error occurred.\r\nLnl.OG.BusinessLayer.Common.BusinessLayerException: General Business Layer Exception ---> System.TypeInitializationException: The type initializer for 'ExtentPlaceholderCreator' threw an exception. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'SqlServerSpatial110.dll': The specified module could not be found.

Resolution

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

Applies To

OnGuard 7.5 & 7.6

Additional Information

© 2024 Honeywell International Inc. All Rights Reserved.