search cancel

Caused by: java.lang.IllegalArgumentException: URL must start with 'jdbc'

book

Article ID: 252948

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Analytics fails to start with the following errors:

20221006/141147.361 - 1      org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'ahSqlAdapter' defined in URL [jar:file:/C:/Automic/Analytics/backend/analytics-backend.jar!/com/automic/analytics/backend/data/ae/collector/AhSqlAdapter.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds_ae' defined in class path resource [com/automic/analytics/backend/config/datasource/DataSourceConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.automic.analytics.backend.data.common.CollectorDataSource]: Factory method 'aeDataSource' threw exception; nested exception is java.lang.IllegalArgumentException: URL must start with 'jdbc'
 

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds_ae' defined in class path resource [com/automic/analytics/backend/config/datasource/DataSourceConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.automic.analytics.backend.data.common.CollectorDataSource]: Factory method 'aeDataSource' threw exception; nested exception is java.lang.IllegalArgumentException: URL must start with 'jdbc'
 

Caused by: java.lang.IllegalArgumentException: URL must start with 'jdbc'

Environment

Release : 21.0.3

Resolution

1. Edit application.properties file

2. Make sure the connection string included 'jdbc'. For example:

# JDBC connection string pointing at the Automation Engine database
datasource.ae.url=jdbc:sqlserver://sample:14433;databaseName=AE_DB