ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CDA: Invalid column name 'execution_id'.

book

Article ID: 146008

calendar_today

Updated On:

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'.

 

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

Environment

Release : 12.3

Component : RELEASE MANAGER

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