Issue
Event Notification Module v8.3.3 in place upgrade from previous version fails on the step 'Installing Diagnostics Database' Error installing Script
Diagnostic log shows "Error executing file 'C:\Program Files (x86)\Schneider Electric\StruxureWare Solutions\Databases\PLES_Logging.sql'."
Product
Event Notification (ENM) v8.3.3
Environment
ENM installer
SQL Server Management Studio
Cause
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint 'FK_CategoryLog_Category'. The conflict occurred in database 'PLES_Logging', table 'dbo.Category', column 'CategoryID'
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
*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.*
A) If historical logging is not required, delete the PLES_Logging database
1) Stop any ENM services if running
2) Open SQL Server Management Studio and connect to the instance where ENM is installed with user that has sysadmin permission
3) Expand folder Databases in Object Explorer
4) Right Click on PLES_Logging and select option 'Delete', click the 'OK' button
5) Run installer again to have database created.
B) If historical logging is required, detach the database and attach again with a different database name
1) Stop any ENM services if running, and note where the current database files are located
2) Open SQL Server Management Studio and connect to the instance where ENM is installed with user that has sysadmin permission
3) Expand folder Databases in Object Explorer
4) Right click on PLES_Logging and select Tasks -> Detach
5) Move the database files to a new location
6) In SQL Server Management Studio, right click on Databases -> Attach. Select the Add button and select the data file files in a new location
7) In the column 'Attach As' change the name of the database, click 'OK'
8) Run installer again to have new PLES_Logging database created.
Event Notification Module v8.3.3 in place upgrade from previous version fails on the step 'Installing Diagnostics Database' Error installing Script
Diagnostic log shows "Error executing file 'C:\Program Files (x86)\Schneider Electric\StruxureWare Solutions\Databases\PLES_Logging.sql'."
Product
Event Notification (ENM) v8.3.3
Environment
ENM installer
SQL Server Management Studio
Cause
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint 'FK_CategoryLog_Category'. The conflict occurred in database 'PLES_Logging', table 'dbo.Category', column 'CategoryID'
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
*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.*
A) If historical logging is not required, delete the PLES_Logging database
1) Stop any ENM services if running
2) Open SQL Server Management Studio and connect to the instance where ENM is installed with user that has sysadmin permission
3) Expand folder Databases in Object Explorer
4) Right Click on PLES_Logging and select option 'Delete', click the 'OK' button
5) Run installer again to have database created.
B) If historical logging is required, detach the database and attach again with a different database name
1) Stop any ENM services if running, and note where the current database files are located
2) Open SQL Server Management Studio and connect to the instance where ENM is installed with user that has sysadmin permission
3) Expand folder Databases in Object Explorer
4) Right click on PLES_Logging and select Tasks -> Detach
5) Move the database files to a new location
6) In SQL Server Management Studio, right click on Databases -> Attach. Select the Add button and select the data file files in a new location
7) In the column 'Attach As' change the name of the database, click 'OK'
8) Run installer again to have new PLES_Logging database created.
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.
