The following error message may show when accessing the Alerts tab in the Deep Security Manager (DSM) console:
Internal server error. The server encountered an internal error and was unable to complete your request. Please contact support if this error occurs again.
The issue happens due to a table in the DB Alert2Hosts, as shown in the logs below:
SEVERE: ThID:73|TID:0|TNAME:Primary|UID:-1|UNAME:|Exception processing alert all.alertTypes.payloadDriverOffline java.lang.NullPointerException at com.thirdbrigade.manager.core.db.Alert2Host.getName(Alert2Host.java:169)
To resolve the issue:
- Stop the Deep Security Manager service.
- Connect to the database server.
- Open the DSM database and run the following SQL commands:
update alert2hosts set TimeResolved = getdate() where TimeResolved is NULL
update alert2s set TimeResolved = getdate() where TimeResolved is NULL
- Restart the Deep Security Manager service. The console should now be accessible.