Error: Invalid object name 'Task4Analytics'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error on the database level regarding Analytics report:

Error:Invalid object name 'Task4Analytics'.

Invalid SQL:

(@P0 datetime2,@P1 datetime2)

SELECT

Id, system_id, system_date_changed, system_is_deleted, task_id, task_name, task_type, task_owner, task_planned_start, task_planned_duration, task_actual_start, task_actual_duration, task_status, task_is_automated, phase_name, plan_id, plan_name, plan_planned_start, plan_planned_duration, plan_actual_start, plan_actual_duration, plan_status, plan_archived, plan_folder, plan_owner

FROM

Task4Analytics

WHERE

plan_actual_start IS NOT NULL AND system_date_changed > @P0 AND system_date_changed < @P1 ORDER BY system_date_changed ASC   

Cause

Configuration

Environment

Release : 12.1, 12.2, 12.3

Component : AUTOMATION ENGINE, CDA

Resolution

The error indicates that one of the required reports Task4Analytics is not installed in CDA.

The report definition cab be found in the file Offering-122.zip\Release.Manager\ReportDefinitions\Task4Analytics.xml.

Resolution: install this report and check if the error is present afterwards.

Example command:

admin-cli create report -con http://CDAserver/cda -usr 100/admin/BC -pwd XXX -fi V122\Task4Analytics.xml -connection MainDatabase

Reference to the documentation: https://docs.automic.com/documentation/webhelp/english/ARA/12.3/DOCU/12.3/CDA%20Guides/Default.htm#Installation_Manual/ARA/Inst_ARAIntegratingaraintoAnalytics.htm%3FTocPath%3DInstalling%7CManual%2520Installation%7CInstalling%2520Analytics%2520and%2520the%2520Event%2520Engine%7C_____7