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 Power Monitoring Expert (PME 8.1) upgrade - the database upgrade fails at the 'Verify Databases'

    Issue
    While performing an in-place upgrade to Power Monitoring Expert (PME8.1), the installer can halt at the 'Verify Databases' step.
    The database that fails to upgrade is the ION_Data database. This will halt the PME installer and the user is unable to click continue.

    The following error may also be seen when attempting to upgrade the 'ION_Data' database via the database manager.



    Product
    Power Monitoring Expert 8.1

    Environment
    Power Monitoring Expert In-Place Upgrade

    Cause
    There is a more detailed message listed in the ION_Data_Upgrade.log file located in the ...\Power Monitoring Expert\Diagnostic folder.
    This is the error message that is contained in those logs:
    Msg 3729, Level 16, State 2, Server , line 48
    Cannot TRUNCATE TABLE 'dbo.PQ_Events' because it is being referenced by object 'vPQ_Events'.

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

    The error in the .log file indicates that the presence of the vPQ_Events view which is preventing the truncation of the PQ_Events table and the subsequent upgrade steps.

    Using SQL Server Management Studio, delete the vPQ_Events view from the ION_Data database and restart the installer:

    1.) Log into SQL Server Management Studio with either a SQL or windows account that has access to edit the ION_Data database
    2.) Expand Databases and find ION_Data
    3.) Expand ION_Data and find Views
    4.) Expand Views and find vPQ_Events
    5.) Right click on vPQ_Events and select Delete
    6.) Click OK in the step box that opens
    7.) If the installer is still open click "try again".  If not, start the installer 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