Discover our Clipsal Smart Home packages as seen on the Block

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

    Why are Diagrams not displaying any values from Web Applications/Diagrams but are showing values in Vista in PME 7.2.2?

    Issue:
    When opening a diagram in Web Applications' Diagrams, the diagram shows orange boxes with "..." and no values as shown below.
    The same diagram is displayed correctly in Vista.
          

    Product Line
    Struxureware Power Monitoring 7.0.1
    Power Monitoring Expert 7.2.X

    Environment
    Power Monitoring Expert
    Web Applications
    Diagrams

    Cause
    Struxureware Power Monitoring (SPM) 7.0.1 and Power Monitoring Expert (PME) 7.2.x  Management Console allows the name of devices to include special characters as part of the device name.
    These special characters are known to cause problems with theWeb Applications.

    PME 8.x  does not allow special characters as part of the device name,
    PME 8.X Management console will display the message below not allowing special characters for device name.
            
           
     
    Resolution:
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*  

    Pleae take the following stepst to resolve this problem.
    1. Make a backup of ION_Data and ION_Network Databases from SQL Mangement Studio 
    2. Rename the device in Management Console making sure there are no special characters on the device name.
    3. Stop the Application Modules and all ION Services from Control Panel\Administrative Tools\Services
    4  Copy the SQL query below and paste it as New Query in SQL Management Studio. It should look like the sreen shot 
        below before pressing Execute.
     
        -- This is an example where the device called ION8650test#1 was renamed to ION8650test
         -- The device name needs to be modify to match the desire device name before running this SQL query.
        USE ION_Data
        -- force Name to match DisplayName
        UPDATE Source
        SET Name = 'ION8650test'
        WHERE DisplayName = 'ION8650test'

        USE ION_Network
        UPDATE SRC_Source
        SET Name = 'ION8650test'
        WHERE DisplayName = 'ION8650test'

       USE ApplicationModules
       UPDATE DatasourceBus.DatasourceDevice
      SET DataSourceRepresentation = 'ION8650test'
      WHERE DataSourceRepresentation = 'ION8650test#1'

      UPDATE DatasourceBus.DatasourceDevice
      SET Description = 'ION8650test'
       WHERE Description = 'ION8650test#1'

      UPDATE DatasourceBus.LogicalDevice
      SET Name = 'ION8650test'
      WHERE Name = 'ION8650test#1'

      UPDATE DatasourceBus.LogicalDevice
      SET Description = 'ION8650test'
      WHERE Description = 'ION8650test#1'


     

    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