Issue
The PME 8.0 upgrade installer fails in a distributed server environment at the 'Register ENM Alarm Service' step during the system configuration. The error returns the information: "#couldnotregisterenmalarmservice".
Product Line
StruxureWare Power Monitoring Expert 8.0
Environment
Power Monitoring Expert 8
SQL Server 2008 R2
SQL Server 2010
SQL Server 2012
SQL Server 2014
Cause
The installer fails at the Register ENM Alarm Service step during the system configuration as it is unable to find the stored procedure 'Inventory.AddNewServiceDefinition' in the Application Modules Database. The Application Modules database schematic revision should be at least version 6.0.
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.
Verify that the required procedure 'Inventory.AddNewServiceDefinition' can be found in the Application Modules tables using the following procedure:
1. Run SQL Server Management Studio
2. Connect to the PME/ION database instance by typing "SERVERNAME\INSTANCE" in the server name name field, select the applicable authentication type, and type the login credentials.
3. Once the connection is established to the instance, expand "Databases -> System Databases -> ApplicationModules -> Tables" and look for the 'Inventory.AddNewServiceDefinition' table. If the table is not found, follow the steps below to determine the current revision of the Application Modules database.
4. Navigate to File -> New -> Query with current connection:
Executing the following SQL query will return the current revision of the Application Modules database:
SELECT
COALESCE(CONVERT(INTEGER, ROUND(CONVERT(DECIMAL, value), 0)), 0) AS [Version]
FROM
sys.extended_properties
WHERE
class_desc = 'DATABASE'
AND name = 'DatabaseSchemaVersion'
*Note: If the current revision is not at least version 6.0, the application modules database has not been upgraded. Re-run the PME installer and ensure that the upgrade ApplicationModules database step succeeds.
**Note: For distributed systems, the installer must run on the database server first in order to upgrade the database revisions to version 6.
The PME 8.0 upgrade installer fails in a distributed server environment at the 'Register ENM Alarm Service' step during the system configuration. The error returns the information: "#couldnotregisterenmalarmservice".
Product Line
StruxureWare Power Monitoring Expert 8.0
Environment
Power Monitoring Expert 8
SQL Server 2008 R2
SQL Server 2010
SQL Server 2012
SQL Server 2014
Cause
The installer fails at the Register ENM Alarm Service step during the system configuration as it is unable to find the stored procedure 'Inventory.AddNewServiceDefinition' in the Application Modules Database. The Application Modules database schematic revision should be at least version 6.0.
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.
Verify that the required procedure 'Inventory.AddNewServiceDefinition' can be found in the Application Modules tables using the following procedure:
1. Run SQL Server Management Studio
2. Connect to the PME/ION database instance by typing "SERVERNAME\INSTANCE" in the server name name field, select the applicable authentication type, and type the login credentials.
3. Once the connection is established to the instance, expand "Databases -> System Databases -> ApplicationModules -> Tables" and look for the 'Inventory.AddNewServiceDefinition' table. If the table is not found, follow the steps below to determine the current revision of the Application Modules database.
4. Navigate to File -> New -> Query with current connection:
Executing the following SQL query will return the current revision of the Application Modules database:
SELECT
COALESCE(CONVERT(INTEGER, ROUND(CONVERT(DECIMAL, value), 0)), 0) AS [Version]
FROM
sys.extended_properties
WHERE
class_desc = 'DATABASE'
AND name = 'DatabaseSchemaVersion'
*Note: If the current revision is not at least version 6.0, the application modules database has not been upgraded. Re-run the PME installer and ensure that the upgrade ApplicationModules database step succeeds.
**Note: For distributed systems, the installer must run on the database server first in order to upgrade the database revisions to version 6.
Released for:Schneider Electric Ireland
