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
Copyright © 2023 Carrier. All rights reserved.