ARA- Analytics Backend throws Error while collecting data from 'ara_execution'

Products

• CA Continuous Delivery Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

The following error message and exception may appear in the Analytics backend log file when running Analytics with ARA/CDA.

ERROR 11908 --- [CollectorThread-14] c.a.a.b.data.ara.collector.AraCollector  : Error while collecting data from 'ara_execution'
 
java.lang.NullPointerException: null at com.automic.analytics.backend.data.ara.collector.AraSqlAdapter.readInterval(AraSqlAdapter.java:105)
at com.automic.analytics.backend.data.common.collector.ChannelAwareSqlAdapter.collectWithin(ChannelAwareSqlAdapter.java:41) 
at com.automic.analytics.backend.data.common.collector.DefaultSqlAdapter.collect(DefaultSqlAdapter.java:35)
at com.automic.analytics.backend.data.common.collector.IntervalBasedCollector.collect(IntervalBasedCollector.java:65) 
at com.automic.analytics.backend.data.common.collector.ScheduledCollector.lambda$run$2(ScheduledCollector.java:134) 
at net.jodah.failsafe.Functions$10.call(Functions.java:252) 
at net.jodah.failsafe.SyncFailsafe.call(SyncFailsafe.java:145) 
at net.jodah.failsafe.SyncFailsafe.run(SyncFailsafe.java:81) 
at com.automic.analytics.backend.data.common.collector.ScheduledCollector.run(ScheduledCollector.java:132) 
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) 
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) 
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) 
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) 
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) 
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) 
at java.base/java.lang.Thread.run(Thread.java:834)

Environment

Release: v21.x

Usage:  Analytics for ARA/CDA

Cause

This error is anticipated to arise when users migrate from v12.3.x to v21, primarily as a result of a configuration mismatch.

Resolution

ARA/CDA v21 consolidates all client data into a single database, diverging from v12.3, which required a separate CDA database for each client.

As a result, it is necessary to exclude the client number from the connection string in the application.properties file.

For v12.3.x:

datasource.ara[<clientnumber>].url=jdbc:sqlserver://<servername>:<port>;databaseName=<databasename>

For v21.x:

datasource.ara.url=jdbc:sqlserver://<servername>:<port>;databaseName=<databasename>