FMS (Management Server) starts successfully but rules don't load due to an intermittent issue while connecting to the Foglight repository database.
There is no outwards indication this has happened, other than the absence of alarms or notifications.
FMS startup establishes a successful connection to the repository database:
VERBOSE [forge-startup] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Database connection established. Database Name: Microsoft SQL Server; Database version: 13.00.5233; JDBC Driver Name: Microsoft JDBC Driver 6.0 for SQL Server; JDBC Driver Version: 6.0.8112.200
Then, a few connections attempts fail, this message can vary depending on the nature of the issue.
ERROR [BaselineManagementPipeline-IntelliProfile] com.quest.nitro.service.baseline.BaselineManagementService - Baseline engine "IntelliProfile" rejected configuration item of type "IntelliProfileType" for "HostNetwork/packetsReceived" (id: 67a6617a-9751-4564-8cc8-7e55445a2db1).
java.lang.RuntimeException: java.sql.SQLException: Unable to acquire a new connection from the pool
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "foglight" requested by the login. The login failed. ClientConnectionId:11b52762-256b-4b30-9cb8-2259a3fd33e6
VERBOSE [forge-startup] com.quest.nitro.service.rule.service.RulePersistenceService - Loaded 0 rules
VERBOSE [forge-startup] com.quest.nitro.service.rule.service.RuleService - Starting 0 rules
INFO [forge-startup] com.quest.nitro.service.util.TopologyConsumerActivator - com.quest.nitro:service=Rule activated.
This has been identified as FOG-655 and has been fixed in the 6.0 and higher releases of the Foglight Management Server.