CDA reporting data cannot be saved.
Article ID: 186638
Updated On:
Products
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
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
------------------------------------------------------------------------------
Feedback
