If mandatory application.properties config setting collector.ara_dbtype is not set when no ARA connection required “WARN 33674” errors result

Document ID : KB000087930
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
WARN 33674 --- [main] o.s.boot.SpringApplication : Error handling failed (Error creating bean with name 'delegatingApplicationListener' defined in class path resource [org/springframework/security/config/annotation/web/configuratio

In the application.properties config file of Analytics (default location: ..\Analytics\backend) the collector.ara_dbtype is mandatory even if there is no ARA connection.  However, the setting is only used when there is an ARA connection, so it should not be a mandatory field unless there is an ARA connection.
 
0EMb0000001UifU.png

If the setting was not set, errors similar to these would be displayed:

=== excerpt of log ===
2017-03-28 16:04:40.355 INFO 33674 --- [main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2017-03-28 16:04:40.357 INFO 33674 --- [main] com.zaxxer.hikari.pool.HikariPool : HikariCP pool HikariPool-0 is shutting down.
2017-03-28 16:04:40.370 INFO 33674 --- [main] o.apache.catalina.core.StandardService : Stopping service Tomcat
2017-03-28 16:04:40.390 WARN 33674 --- [main] o.s.boot.SpringApplication : Error handling failed (Error creating bean with name 'delegatingApplicationListener' defined in class path resource [org/springframework/security/config/annotation/web/configuration/WebSecurityConfiguration.class]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.cache.annotation.ProxyCachingConfiguration': Initialization of bean failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'org.springframework.context.annotation.ConfigurationClassPostProcessor.importRegistry' is defined)
2017-03-28 16:04:40.394 ERROR 33674 --- [main] o.s.boot.SpringApplication : Application startup failed
 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'ahSqlAdapter' defined in URL [jar:file:/net/si0vm4135/fs0/analytics/backend_1_0_0+build.125/analytics-backend.jar!/com/automic/analytics/backend/data/ae/collector/AhSqlAdapter.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.automic.analytics.backend.data.common.collector.CollectorConfiguration]: : Error creating bean with name 'collectorConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private java.lang.String com.automic.analytics.backend.data.common.collector.CollectorConfiguration.araDbType; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'collector.ara_dbtype' in string value "${collector.ara_dbtype}"; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'collectorConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private java.lang.String com.automic.analytics.backend.data.common.collector.CollectorConfiguration.araDbType; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'collector.ara_dbtype' in string value "${collector.ara_dbtype}"
...
Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private java.lang.String com.automic.analytics.backend.data.common.collector.CollectorConfiguration.araDbType; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'collector.ara_dbtype' in string value "${collector.ara_dbtype}"
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
... 37 common frames omitted
Caused by: java.lang.IllegalArgumentException: Could not resolve placeholder 'collector.ara_dbtype' in string value "${collector.ara_dbtype}"
at org.springframework.util.PropertyPlaceholderHelper.parseStringValue(PropertyPlaceholderHelper.java:174) ~[spring-core-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.util.PropertyPlaceholderHelper.replacePlaceholders(PropertyPlaceholderHelper.java:126) ~[spring-core-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.core.env.AbstractPropertyResolver.doResolvePlaceholders(AbstractPropertyResolver.java:204) ~[spring-core-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.core.env.AbstractPropertyResolver.resolveRequiredPlaceholders(AbstractPropertyResolver.java:178) ~[spring-core-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.context.support.PropertySourcesPlaceholderConfigurer$2.resolveStringValue(PropertySourcesPlaceholderConfigurer.java:172) ~[spring-context-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveEmbeddedValue(AbstractBeanFactory.java:808) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1027) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:545) ~[spring-beans-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
... 39 common frames omitted
Environment:
OS Version: N/A
Cause:
Cause type:
Other
Root Cause: Originally the collector.ara_dbtype was a mandatory setting even if there was no ARA connection defined. However, this led to errors and confusion, so the setting was changed and is not required if there is no ARA connection.
Resolution:
Update to a fix version listed below or a newer version if available.

Since requiring the collector.ara_dbtype to always be set led to confusion and errors, the property was modified so that it is no longer mandatory if there is no ARA connection.

Analytics On Premise 1.0.1 is the equivalent to the Automation Engine Release in Version 12.0.2

Fix Status: Released

Fix Version(s):
Analytics On Premise 1.0.1 - Available
Additional Information:
Workaround :
Set the collector.ara_dbtype to the type of the ARA source database. If there is no ARA connection defined, then the setting can be set to any of the below listed values since it will not be used anyway.

Possible values: ORACLE, SQL (for MS SQL)

Example
 
collector.ara_dbtype=SQL