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:
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
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
Repeat step 1 above to validate if the report is deleted successfully
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
Repeat step 1 to check if the report created successfully