Endpoint Security Server database fails to load

Support Center > Search Results > SecureKnowledge Details

Technical Level

Solution ID	sk142293
Technical Level
Product	Endpoint Security Server
Version	R77.30.03 (EOL), R80.20
Date Created	11-Dec-2018
Last Modified	29-May-2019

Symptoms

Endpoint Security Server database fails to load.
The user is unable to connect to SmartEndpoint.

Server_messages log states Database not running:

TICKET_NUMBER = 1489442297. COMMAND_NAME = getAllGeneralConfigurationCommand.

        at com.checkpoint.uepm.backend.is.commands.GetCommand.execute(GetCommand.java:81)
        at com.checkpoint.uepm.backend.is.infrastructure.TransactionManager.executeSingleGetCommandActual(TransactionManager.java:550)
        ... 35 more
Caused by: com.checkpoint.uepm.api.epsbackend.is.EpsRuntimeException: Failed to open Read connection.
        at com.checkpoint.uepm.backend.is.infrastructure.DbTxHolderIbatis.getSqlMapSession(DbTxHolderIbatis.java:102)
        at com.checkpoint.uepm.backend.is.dao.DaoAbstractImpl.getSqlMapSession(DaoAbstractImpl.java:32)
        at com.checkpoint.uepm.backend.is.dao.GenericDaoImpl.getBeansCollection(GenericDaoImpl.java:118)
        at com.checkpoint.uepm.backend.is.commands.genericcommands.GetBeansCollectionCommand.executeSpecificGet(GetBeansCollectionCommand.java:58)
        at com.checkpoint.uepm.backend.is.commands.GetCommand.execute(GetCommand.java:72)
        ... 36 more
Caused by: java.sql.SQLException: Database not running
        at com.checkpoint.uepm.db.DbConnectionProviderUSM.getReadConnection(DbConnectionProviderUSM.java:77)
        at com.checkpoint.uepm.backend.is.infrastructure.ConnectionHandler.getReadConnection(ConnectionHandler.java:104)
        at com.checkpoint.uepm.backend.is.infrastructure.DbTxHolderIbatis.getSqlMapSession(DbTxHolderIbatis.java:100)
        ... 40 more

Cause

The issue is caused by a corrupted deployed_rule_base_entry table.

Solution

Note: To view this solution you need to Sign In .