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 reporting data cannot be saved.

book

Article ID: 186638

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

CDA reporting data cannot be saved. The following exception is thrown:

[28(AUTOMIC/100)] ERROR RM.Reporting - Report #350120 - Failed to save reporting data.
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'artifact_name'.
Invalid column name 'artifact_source_customtype'.
Invalid column name 'artifact_source_name'.
Invalid column name 'component_customtype'.
Invalid column name 'component_name'.
Invalid column name 'deployment_target_agent'.
Invalid column name 'deployment_target_customtype'.
Invalid column name 'deployment_target_name'.
Invalid column name 'execution_id'.
Invalid column name 'installation_status'.
Invalid column name 'workflow_customtype'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Ventum.Bond2.Services.ChangeLogging.Impl.DataSinks.ExternalTableReportDataSink.ExecutePersistCommand(ReportEntry entry, DbTransaction transaction) in E:\BuildAgent\work\bondrelease\10.0.1\Projects\Ventum.Bond2.Services.Impl\Services.ChangeLogging.Impl\DataSinks\DatabaseReportDataSink.cs:line 93

 

Environment

Release : 10.0

Component : RELEASE MANAGER

Resolution

This occurred during an upgrade from Release Manager 9 to Release Manager 10. Delete and recreate the reports with the following scripts:

E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA

Connection: MainDatabase
------------------------------------------------------------------------------
            Type name            |          Table name            |  Status
------------------------------------------------------------------------------
Deployment                       |Data4AnalyticsExecution         |Operational
------------------------------------------------------------------------------


E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe delete report -tn Data4AnalyticsExecution -con http://AUTOMIC/ARA -usr 100/ARA/ARA
-pwd ARA

E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA
^C
E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe create report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA -fi E:\Automic\12.3
.1\Release.Manager\ReportDefinitions\Data4Analytics.xml -connection MainDatabase
Error: 27, Table already exists

E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe delete report -tn Data4AnalyticsExecution -con http://AUTOMIC/ARA -usr 100/ARA/ARA
-pwd ARA

E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe create report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA -fi E:\Automic\12.3
.1\Release.Manager\ReportDefinitions\Data4Analytics.xml -connection MainDatabase
Error: 27, Table already exists

E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA

Connection: MainDatabase
------------------------------------------------------------------------------
            Type name            |          Table name            |  Status
------------------------------------------------------------------------------
Deployment                       |Data4AnalyticsExecution         |Activating
------------------------------------------------------------------------------


E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA

Connection: MainDatabase
------------------------------------------------------------------------------
            Type name            |          Table name            |  Status
------------------------------------------------------------------------------
Deployment                       |Data4AnalyticsExecution         |Activating
------------------------------------------------------------------------------


E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA

Connection: MainDatabase
------------------------------------------------------------------------------
            Type name            |          Table name            |  Status
------------------------------------------------------------------------------
Deployment                       |Data4AnalyticsExecution         |Activating
------------------------------------------------------------------------------


E:\Automic\12.3.1\Release.Manager\Utilities\AdminCLI>admin-cli.exe list report -con http://AUTOMIC/ARA -usr 100/ARA/ARA -pwd ARA

Connection: MainDatabase
------------------------------------------------------------------------------
            Type name            |          Table name            |  Status
------------------------------------------------------------------------------
Deployment                       |Data4AnalyticsExecution         |Operational
------------------------------------------------------------------------------