CDA: Invalid column name 'execution_id'.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

After upgrading a CDA instance, you may see in your log.txt the following:

ERROR RM.Reporting - Report #198301 - Failed to save reporting data.System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'execution_id'.

 

Environment

Release : 12.3

Component : RELEASE MANAGER

Cause

This is due to the newer format of DataforAnalytics:

https://docs.automic.com/documentation/webhelp/english/ARA/12.3/DOCU/12.3/CDA%20Guides/Default.htm#CDA/Upgrade/Upgrade_InPlace_121tolatest/Upgrade_Inplace_121toLatest_2UpgradingtheCACDAComponent.htm#link6

Resolution

Add the -force flag when creating the new report:

1. Open the command line and enter the following command to check if the report is installed in the system: admin-cli.exe list report -con http://ARAserver/ara -usr 100/ADMIN/AUTOMIC -pwd XXX
2. Enter the following command to remove the Data4AnalyticsExecution report: admin-cli.exe delete report -tn Data4AnalyticsExecution -con http://ARAserver/ara -usr 100/ADMIN/AUTOMIC -pwd XXX -force
3. Repeat step 1 above to validate if the report is deleted successfully
4. Enter the following command to install the new report. Please use the report definition file included in 10.0.1+build.21568: admin-cli.exe create report -con http://ARAserver/ara -usr 100/ADMIN/AUTOMIC -pwd XXX -fi ..\Release.Manager\ReportDefinitions\Data4Analytics.xml -connection MainDatabase
5. Repeat step 1 to check if the report created successfully