AWA - Analytics Backend throws : Error while collecting data from 'ara_execution'

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

Upon startup of the analytics backend - The below error message can be seen in the logs.

ERROR 2636 --- [CollectorThread-4] 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)

Environment

Release : 21.x

Component: Automation Engine

Functional Area: Analytics Backend

Cause

This happens if the application.properties has the parameter collectors.enabled=true - This enables data collector of both AE and CDA/ARA.

################
## Collectors      ##
################

# Enable/disable all data collectors globally, precedes collector specific switches
collectors.enabled=true

Resolution

If you are using Analytics Backend for AE alone - Update your application.properties to either of the below combinations to exclude the CDA/ARA data collector.

• collectors.enabled=true and collector.ara.enabled=false 

                                      [or]

• collectors.enabled=false and collector.ae.enabled=true