Itgenspr019 Column 'txt' does not allow DBNull.Value

Vragen
1

We werken sinds deze week met Data Hub Multi Platform en krijgen nu op alle dataloads de volgende melding:

2023-11-23 20:33:07.584 Exclamation itgencun016:
Exclamation itgenspr019:
Could not bulk insert 49 rows into the table ‘XXX.dbo.dc_event_log’.

De volledige melding is:

Deletion of obsolete facts failed from '141 - Obsoleted v8 (table 18 - ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk, partition 2 - 1334432)' of table '18 - ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk': Invantive.Basics.InvantiveSystemException: itgenspr019: Could not bulk insert 49 rows into the table 'XXX.dbo.dc_event_log'.
 ---> System.InvalidOperationException: Column 'txt' does not allow DBNull.Value.
   at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
   at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)
   at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at Invantive.Data.Providers.SqlServer.SqlServerProvider.InsertBulk(GlobalState owner, ExecutionOptions executionOptions, En...leName, ScriptingLanguageNextStepSpecification& exitSpecification)
   at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String[] arguments)
   at Invantive.Producer.Data.Hub.Program.Main(String[] args)
   at Invantive.Data.Providers.SqlServer.SqlServerProvider.InsertBulk(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, ResultSet inputResultSet, Nullable`1 maxBatchSizeRows, String partitionCode)
   at Invantive.Data.Providers.DataCache.DataCacheProvider.RegisterEvents(GlobalState owner, ExecutionOptions executionOptions, AnsiSqlProviderBase backingDatabaseProvider, ConcurrentQueue`1 eventLogs)
   at Invantive.Data.Providers.DataCache.DataCacheProvider.A(GlobalState , ExecutionOptions executionOptions, Boolean , Boolean )
   at Invantive.Data.Providers.DataCache.DataCacheProvider.A(GlobalState , ExecutionOptions executionOptions, DcEventLog , Boolean )
   at Invantive.Data.Providers.DataCache.DataCacheProvider.DeleteBatchTablePartitionVersionFacts(GlobalState owner, ExecutionOptions executionOptions, String tableName, EntityFieldCollection efc, HashSet`1 tablePartitionVersionGroup, DcTable dcTable, Boolean logWhenNoRowsDeleted, Nullable`1 maxRuntimeDatabaseSec)
   at Invantive.Data.Providers.DataCache.DataCacheProvider.DeleteFactsTablePartitionVersions(GlobalState owner, ExecutionOptions executionOptions, String tableName, IEnumerable`1 tablePartitionVersions, DcTable dcTable, Boolean logWarningWhenAnyFactsDeleted, Boolean logWhenNoRowsDeleted, String context, Nullable`1 maxRuntimeDatabaseSec)
   at Invantive.Data.Providers.DataCache.DataCacheProvider.A(GlobalState , ExecutionOptions executionOptions, DcTablePartitionVersion , Nullable`1 )
   at Invantive.Data.Providers.DataCache.DataCacheProvider.A(GlobalState , ExecutionOptions executionOptions, Nullable`1 ).

Could not bulk insert 49 rows into the table 'XXX.dbo.dc_event_log'.

Column 'txt' does not allow DBNull.Value.

Kan dit verholpen worden?

2

De oorzaak van deze foutmelding is achterhaald. Een oplossing is beschikbaar vanaf release 23.0.111 op https://releasenotes.invantive.com. Deze zal omstreeks 28 november 2023 beschikbaar komen.