EMS not starting - Failures in log

book

Article ID: 196462

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

EMS not restarting - failures in log

Cause

- OutofMemory

Environment

Release : 20.1

Component : UIM - EMS

ems v10.23

Resolution

Renamed the ems db file making ems create a new one. Added more min/max memory to the ems probe.

Additional Information

[nimaccept, ems] Out Of Memory. Exiting probe.
...
[main, ems] Performing EMS database migrations
[main, ems] Migrations complete
[main, ems] Performing EMS database migrations
[main, ems] EMS database schema migration failed!  This may cause ems to not work correctly.
[main, ems] org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: 
Migration V5__umpAlarmAnnotations-username-size.sql failed
----------------------------------------------------------
SQL State  : S0001
Error Code : 5074
Message    : The statistics 'username' is dependent on column 'username'.
Location   : nas-api-service/migrations/sql-server/V5__umpAlarmAnnotations-username-size.sql (E:\CA\UIM\probes\service\ems\file:\E:\CA\UIM\probes\service\ems\lib\event_management-10.2.3.jar!\nas-api-service\migrations\sql-server\V5__umpAlarmAnnotations-username-size.sql)
Line       : 2
Statement  : ALTER TABLE umpAlarmAnnotations
ALTER COLUMN username VARCHAR(255)
...
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'username' is dependent on column 'username'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729)
 at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
 at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
 ... 36 more