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'.
Publicado para: Schneider Electric España
¿Necesitas ayuda?
Empieza aquí
Encuentra respuestas ahora. Busca una solución por ti mismo, o ponte en contacto con uno de nuestros expertos.
Contacta con el servicio de asistencia
Ponte en contacto con nuestro equipo de atención al cliente para recibir información, soporte técnico, asistencia para reclamaciones y mucho más.
¿Dónde comprar?
Encuentra fácilmente el distribuidor de Schneider Electric más cercano a tu ubicación.
Buscar preguntas frecuentes
Obtén las respuestas que necesitas examinando las preguntas frecuentes (FAQ) relacionadas con los temas.
Contacto con el servicio de ventas
Comienza tu consulta de ventas on-line y un experto se pondrá en contacto contigo.
