Technical FAQs

Ask a Question

PME 8.0 Installer fails at Register ENM Alarm Service

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 Base, Data Center Edition

Environment
Power Monitoring Expert 8, SQL Server 2008 R2/2010/2012/2014 Standard/Express

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 be typing "SERVERNAME\INSTANCE" in the servername 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'

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.

For distributed systems, the installer must run on the database server first in order to upgrade the database revisions to version 6.
Was this helpful?
What can we do to improve the information ?