Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

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

    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 tag at the end of the file

     
       
            
               
               
             

       

     
    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.


     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance