SOI - soimgr.log logs "Failed to save alert" repeatedly until it fills the disk

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

The soimgr.log, conmgr.log and other logs is logging only this aggresively and repeatdly. Until it fills the disk. 

021-12-20 09:52:29,389 INFO  [pool-13-thread-1] ?.?(?)  - OutageAlerts: Failed to save alert: 8796997/352201
java.lang.IllegalStateException: Session/EntityManager is closed
 at org.hibernate.internal.AbstractSharedSessionContract.checkOpen(AbstractSharedSessionContract.java:375)
 at org.hibernate.engine.spi.SharedSessionContractImplementor.checkOpen(SharedSessionContractImplementor.java:148)
 at org.hibernate.internal.AbstractSharedSessionContract.getNativeQueryImplementor(AbstractSharedSessionContract.java:1090)
 at org.hibernate.internal.AbstractSharedSessionContract.createSQLQuery(AbstractSharedSessionContract.java:1062)

 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

The following steps should help remove this issue:

 

1. Backup the DB

2. Stop all  SOI services.

3. TRUNCATE table OutAgeAlerts;

SQL DROP TABLE, TRUNCATE TABLE (w3schools.com)

4. Execute the following command: C:\Program Files (x86)\CA\SOI\Tools>soitoolbox.exe --purgeOutageAlerts

5. Start the SOI Manager and MQ server

6. Once SOI manager is up (Verify from manager debug page triage test) then start remaining SOI services