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'.
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'.
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.