Analytics Backend will not start in initial setup

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Admin running into the following error when starting the Analytics Backend:

10:51:40.239 [main] ERROR org.springframework.boot.SpringApplication - Application run failed
java.lang.IllegalStateException: Failed to load property source from location 'classpath:/application.properties'
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.load(ConfigFileApplicationListener.java:552)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.loadForFileExtension(ConfigFileApplicationListener.java:503)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.load(ConfigFileApplicationListener.java:470)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.lambda$null$6(ConfigFileApplicationListener.java:451)
        at java.lang.Iterable.forEach(Unknown Source)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.lambda$load$7(ConfigFileApplicationListener.java:450)
        at java.lang.Iterable.forEach(Unknown Source)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.load(ConfigFileApplicationListener.java:447)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.load(ConfigFileApplicationListener.java:336)
        at org.springframework.boot.context.config.ConfigFileApplicationListener.addPropertySources(ConfigFileApplicationListener.java:215)
        at org.springframework.boot.context.config.ConfigFileApplicationListener.postProcessEnvironment(ConfigFileApplicationListener.java:198)
        at org.springframework.boot.context.config.ConfigFileApplicationListener.onApplicationEnvironmentPreparedEvent(ConfigFileApplicationListener.java:185)
        at org.springframework.boot.context.config.ConfigFileApplicationListener.onApplicationEvent(ConfigFileApplicationListener.java:171)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:127)
        at org.springframework.boot.context.event.EventPublishingRunListener.environmentPrepared(EventPublishingRunListener.java:74)
        at org.springframework.boot.SpringApplicationRunListeners.environmentPrepared(SpringApplicationRunListeners.java:54)
        at org.springframework.boot.SpringApplication.prepareEnvironment(SpringApplication.java:338)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:297)
        at com.automic.analytics.backend.BackendServer.run(BackendServer.java:29)
        at com.automic.analytics.backend.BackendRunner.run(BackendRunner.java:19)
        at com.automic.analytics.backend.Agent.startBackend(Agent.java:132)
        at com.automic.analytics.backend.Agent.beforeExecutorStarts(Agent.java:106)
        at com.uc4.ex.ExecutorLifecycle.startExecutor(ExecutorLifecycle.java:384)
        at com.uc4.ex.ExecutorLifecycle.execute(ExecutorLifecycle.java:103)
        at com.automic.analytics.backend.Agent.main(Agent.java:68)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
        at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:593)
Caused by: java.lang.IllegalStateException: Malformed \uxxxx encoding.
        at org.springframework.boot.env.OriginTrackedPropertiesLoader$CharacterReader.readUnicode(OriginTrackedPropertiesLoader.java:237)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader$CharacterReader.readEscaped(OriginTrackedPropertiesLoader.java:219)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader$CharacterReader.read(OriginTrackedPropertiesLoader.java:183)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader$CharacterReader.read(OriginTrackedPropertiesLoader.java:168)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader.loadValue(OriginTrackedPropertiesLoader.java:135)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader.load(OriginTrackedPropertiesLoader.java:92)
        at org.springframework.boot.env.OriginTrackedPropertiesLoader.load(OriginTrackedPropertiesLoader.java:63)
        at org.springframework.boot.env.PropertiesPropertySourceLoader.loadProperties(PropertiesPropertySourceLoader.java:61)
        at org.springframework.boot.env.PropertiesPropertySourceLoader.load(PropertiesPropertySourceLoader.java:47)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.loadDocuments(ConfigFileApplicationListener.java:570)
        at org.springframework.boot.context.config.ConfigFileApplicationListener$Loader.load(ConfigFileApplicationListener.java:526)
        ... 35 common frames omitted

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Automic Admin was running MSSQL 2016 -> updated this value from:

datasource.ae.url=jdbc:sqlserver://<servername>\\<InstanceName>:1450;databaseName=<DB Name>
to:
datasource.ae.url=jdbc:sqlserver://<servername>:1450;instanceName=<InstanceName>;databaseName=<DB Name>