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
Configuration
Release : 12.1, 12.2, 12.3
Component : AUTOMATION ENGINE, CDA
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