History DB Error: [810143] Database error 2627: Violation of PRIMARY KEY constraint (4376603)

History DB Error: [810143] Database error 2627: Violation of PRIMARY KEY constraint

With a new History Database, when using an Identity Manager database as a source with more than 1024 columns flagged as IsToWatch or IsToWatchDelete (e.g. Common\ProcessState\PropertyLog\AllDefaultPropertiesForModel was set), instead of the History Database tables SourceDatabase, SourceTable, and SourceColumn getting populated correctly, the export fails in _CreateMetaEntries.

The full error is:
 

[date] [time] ERROR (Jobservice  ) : HdbTransportComponent.HdbTransportComponent - 1ffc2729-8af8-4034-a802-3ed72ec07931: Errors occurred
    [810143] Database error 2627: Violation of PRIMARY KEY constraint 'PK__SourceTa__90083859D6E2A2E6'. Cannot insert duplicate key in object 'dbo.SourceTable'. The duplicate key value is (QER-T-ESet).
    The statement has been terminated.
    [Microsoft.Data.SqlClient.SqlException] Violation of PRIMARY KEY constraint 'PK__SourceTa__90083859D6E2A2E6'. Cannot insert duplicate key in object 'dbo.SourceTable'. The duplicate key value is (QER-T-ESet).
    The statement has been terminated.
       at VI.JobService.ProcessorThread._ExecuteJob(Job job, JobResult result)
       at HdbTransportComponent.HdbTransportComponent.Activate(String task)
       at HdbTransportComponent.HdbTransportComponent._ExportToHdb()
       at HdbTransportComponent.HdbTransportComponent._MoveDataToHdb(IDbSession inSession, IDbSession outSession, CancellationToken ct)
       at HdbTransportComponent.HdbTransportComponent._CopyDataToHdb(IDbSession inSession, IDbSession outSession, CancellationToken ct)
       at HdbTransportComponent.HdbTransportComponent._CreateMetaEntries(IDbSession inSession, IDbSession outSession, CancellationToken ct)
       at HdbTransportComponent.HdbTransportComponent._CopyEntries(IDbSession inSession, IDbSession outSession, String inSql, String outTable, String[] outColumns, CancellationToken ct)
       at VI.Base.SyncActions.Do(Func`1 action)
       at VI.DB.DataAccess.ReadWriteDbSession.BulkImportAsync(String table, IEnumerable`1 columns, IEnumerable`1 values, BulkImportOptions options, CancellationToken cancellationToken)
       at VI.DB.DataAccess.ReadWriteDbSession.IgnoreBrokenConnectionAsync[T](IQueryProvider queryForLogging, Func`1 query, CancellationToken cancellationToken)
    --- End of stack trace from previous location ---
       at VI.DB.DataAccess.ReadWriteDbSession.<>c__DisplayClass28_0.<<BulkImportAsync>b__0>d.MoveNext()
       at VI.DB.DataAccess.PhysicalMsSqlConnection.BulkImportAsync(String table, IEnumerable`1 columns, IEnumerable`1 values, BulkImportOptions options, CancellationToken cancellationToken)
       at VI.DB.DataAccess.PhysicalMsSqlConnection._BulkImportDotNet(String table, IEnumerable`1 columns, IEnumerable`1 values, BulkImportOptions options, CancellationToken cancellationToken)
       ---- Start of Inner Exception ----
       at VI.DB.DataAccess.PhysicalMsSqlConnection._BulkImportDotNet(String table, IEnumerable`1 columns, IEnumerable`1 values, BulkImportOptions options, CancellationToken cancellationToken)
    --- End of stack trace from previous location ---
       at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
       at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
       at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)

 

Product defect

WORKAROUND: 

None

STATUS:

This has been addressed in versions 9.0 LTS CU4, 9.1.3 and 9.2.2 by hotfix number 461832.