The Foglight Management Server (FMS) startup fails on a new initial install using Microsoft SQLServer.
Reviewing the FMS log we see some of the errors
WARN [main] org.jboss.system.ServiceController - Problem starting service com.quest.nitro:service=SpringBootstrap.0
org.springframework.beans.factory.access.BootstrapException:
Unable to initialize group definition. Group resource name [classpath*:com/quest/nitro/service/core-beanref.0.ctx.xml], factory key [foglight-core-services]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'foglight-core-services' defined in URL [jar:file:/Foglight/server/default/tmp/deploy/tmp47769foglight.sar!/com/quest/nitro/service/core-beanref.0.ctx.xml]:
Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException:
Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'exporter' defined in class path resource [com/quest/nitro/service/common.ctx.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.quest.nitro:service=NitroSecurityService' defined in class path resource [com/quest/nitro/service/core-services.0.ctx.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.hibernate.exception.ConstraintViolationException: could not insert: [com.quest.nitro.service.security.auth.SecWord]
On newer versions of the Foglight, e.g. 5.6.10, the following errors have been listed in the FMS log file in DEBUG mode 1:
Violation of UNIQUE KEY constraint 'UQ__topology__DB2FBE5DC0FC4675'. Cannot insert duplicate key in object 'dbo.topology_property_name'. The duplicate key value is (incidentID).
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1160)
ERROR [main] com.quest.nitro.upgrade.db.validation.CharacterSetCollationValidation - The database is using a case-insensitive character set collation which is not supported.