Technical FAQs

Ask a Question

While performing an in-place upgrade to Power Monitoring Expert (PME8), the database upgrade fails at the 'Verify Databases' step

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

Product Line:
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. This is the error message that is contained in those logs:

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 file can be found in the ...\Power Monitoring Expert\system\scripts directory. Then rerun the Installer choosing 'Resume', if you have shut down the Installer, or choose 'Try Again' if the installer is still running.




 
Was this helpful?
What can we do to improve the information ?