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".

CauseThe 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:

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.