PME Errors in Application Modules web applications. Dashboards, trends, tables, alarms all do not work properly. Multiple errors logged in Application Modules database.

搜尋常見問題

Issue
1) None of the Application Module based web applications are working. Various errors show up in the ApplicationModules database diagnostics tables. Amongst the error messages a low level error comes from the DataSourceDriver indicating a problem with SQLServer data types.
2) PMALARM service fails to start due to timeout during install time.

In ApplicationModules - Diagnostics Viewer view an error will be logged:

LogClientException: System.ServiceModel.FaultException`1[Framework.Interfaces.Faults.SystemFault]: An error occurred while accessing a system resource or another service. Please try again later. (Fault Detail is equal to Framework.Interfaces.Faults.SystemFault).
LogClient: DataSourceDrivers::DataSourceDrivers.DataSourceInitializationLogger::LogWarningMessage
LogClientExtendedInformation: ApplicationModule: MetadataService
Description: The type initializer for 'ExtentPlaceholderCreator' threw an exception.
State: System.TypeInitializationException: The type initializer for 'ExtentPlaceholderCreator' threw an exception. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
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.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
--- End of inner exception stack trace ---

Product Line
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020

Environment
Web Applications: Dashboards, Trends, Alarms
ApplicationModules database
Install/Upgrade

Cause
An incompatible version of the Microsoft.SqlServer.Types.dll has been installed on the server. PME is attempting to use this incompatible version and crashing.

Resolution
By editing the Framework.Service.Host.exe.config file PME can be forced to use the correct version of Microsoft.SqlServer.Types.dll.

Stop the 3 Application Modules Services. (CoreServicesHost, DataServicesHost and ProviderEngineHost).
Open the Framework.Service.Host.exe.config file in a text editor. It is typically located at C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\applications\bin.
At the bottom of the file just above the closing </configuration> tag edit the following xml to match the latest Microsoft.SqlServer.Types.dll found in "C:\Windows\assembly".

Please note that this may affect different versions of SqlServerSpatial dll.
Therefore is recommended to edit the xml fragment to match the latest Microsoft.SqlServer.Types.dll found in "C:\Windows\assembly".

In this case it should be edit to: <bindingRedirect oldVersion="1.0.0.0-13.0.0.0" newVersion="10.0.0.0" />

Update
This problem can occur in PME2020, but reference SqlServerSpatial120.dll in the error message, rather than SQLServerSpatial110.dll.
The resolution is to edit Framework.ServiceHost.exe.config by changing the Microsoft.SqlServer.Types "newVersion" value from 12 to 10