Browse FAQs

Power Monitoring Expert - All Dashboards return no data. I see an error like 'sqlserverSpatial110.dll' in the Diagnostics.LogEventView in the Applications Modules database

Published date: 13 September 2019

Issue

After logging into Web Applications, all dashboards state "no data returned". In the Application Modules Database, in the Diagnostics.LogEventView table the following message is returned from Data Source Bus:

Message:
An unexpected error has occurred. Please consult the system diagnostic information.

Extended Information:
LogClientExtendedInformation: ApplicationModule: Data Source Bus
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) 

Product Line

Power Monitoring Expert 8.x

Environment

Web Applications - Dashboards

Cause

Under some conditions, applying SP3 to SQL Server 2012 breaks compatibility between SQLServerSpatial110.dll and the Microsoft.SQLServer.Types library. Should his happen, the DataSourceBus cannot successfully initialize which prevents all of the Web Applications expect for Diagrams and Reports from working. If this condition exists on a server on which PME is being installed or upgraded, the install/upgrade fails on 'Configuring Web Framework'.

Further details on the Microsoft SQL Server compatibility is available at this link:

https://connect.microsoft.com/SQLServer/Feedback/Details/2139143

Resolution

*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).

Look in "C:\Windows\assembly" to identify which versions of "Microsoft.SqlServer.Types.dll" exist (see attached screen capture).
We hope to see "10" and "11".  If so, then we can potentially force a “down-rev” for our AppMods services.
Assuming version 10 exists,
  1. Stop the ApplicationModules services
  2. Edit the file \Applications\bin\Framework.ServiceHost.exe.config by copying in the xml fragment below just above the </configuration> tag at the end of the file

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
         <dependentAssembly>
            <assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" />
            <bindingRedirect oldVersion="1.0.0.0-12.0.0.0" newVersion="10.0.0.0" />
          </dependentAssembly>
    </assemblyBinding>
  </runtime.>
  1. Start the ApplicaionModules services
  2. Monitor the Diagnostics.LogEventView table to verify that the Data Source Bus initializes properly. If you have been successful, you should see a message like:
    "Completed data source initialization. The data source was assigned ID 1."


Additional Information

This workaround forces the ApplicationModules services to use version 10 of the Microsoft.SQLServer.Types library.. This problem has been addressed in Power Monitoring Expert 8.2. PME 8.2 uses version 12.0.0.0 of this library which does not have this problem which we force it to use via the web.config file.


 

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.