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 Powerhouse 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

    In-place upgrade to Power Monitoring Expert (PME8.x) fails at the 'Verify Databases' step

    Issue
    While performing an in-place upgrade to Power Monitoring Expert (PME 8.x), the installer can halt at the 'Verify Databases' step. This will halt the PME installer and the user is unable to click continue.

    Product Line
    Power Monitoring Expert 8.1
    Power Monitoring Expert 8.0


    Environment
    Power Monitoring Expert In-Place Upgrade

    Cause
    There is a more detailed message listed in the ION_Network.log or ION_Data.log file located in the ...\Power Monitoring Expert\Diagnostic folder.
    Below is a possible error message found in the log file:


    Updating SOURCE Table Constraints
    ALTER DisplayName Column to NOT NULL
    Msg 1205, Level 13, State 56, Server HDCSQL23, Line 123
    Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


    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.* 

    To resolve this, run the script called 'NOM12_ChangeDBOwner.sql' manually in SQL Server Management Studio.
    This script can be found in the ...\Power Monitoring Expert\system\scripts directory. To run the script perform the following:

    1. Open SQL Server Management Studio and connect to the instance where PME is located.
    2. In the menu bar Select File -> Open -> File... and select the 'NOM12_ChangeDBOwner.sql'
    3. Select the desired database (ION_Network or ION_Data) to run the script against in the 'Available Databases' dropdown.
    4. Click Execute.

    Note: You can also edit the .sql script with text editor (such as notepad) and manually copy and paste the contents of the script directly into a New Query using SQL Management Studio. This may be desirable if the script does not exist on the machine in which you are running the SQL query.

    After the script completes, rerun the Installer choosing 'Resume' if you have shut down the Installer. If the installer is still running, choose 'Try Again'.

    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