Orchestrator Error Occurred While Create Asset Queue Process Trigger And Etc

News Knowledge Base
,
1

Unable to create process , trigger, start job, queue, and etc...

Error:

Orchestrator.tenantId:2.Component:Jobs.Default System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.

---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details.

---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Discriminator'.

at Task<DbDataReader> Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)+(Task<SqlDataReader> result) => { }

at void System.Threading.Tasks.ContinuationResultTaskFromResultTask<TAntecedentResult, TResult>.InnerInvoke()


Resolution:

  1. Check the dbo.AuditLogs table if Discriminator column is present.
  2. If not present, add this column by using below query

ALTER TABLE [dbo].[AuditLogs]

ADD Discriminator nvarchar(128);