Processing file C:\ProgramData\Flexera Software\Incoming\Inventories\system on x01bopaldb1a at 20210710T181201 (Full).ndi.gz: EXCEPTION: -------------------- System.InvalidOperationException: The given value of type Int64 from the data source cannot be converted to type int of the specif ied target column. ---> System.OverflowException: Failed to convert parameter value from a Int64 to a Int32. ---> System.OverflowE xception: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& 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, TaskCompletionSourc e`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkComman dText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, Ca ncellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, Cancellat ionToken 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(IDataReader reader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(IDbConnection p_DestinationConnection, IDbTransaction p_DestinationTr ansaction, String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_InputDataReader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_Input DataReader) at ManageSoft.Database.Impl.SoftwareFileTable.DeleteObjects(DatabaseObjectCollection`1 p_Objects) at ManageSoft.Database.Impl.DatabaseTableBase`2.ReplaceObjects(IEnumerable`1 p_OldObjects, TCollection p_NewObjects) at ManageSoft.Database.Impl.SoftwareFileTable.ReplaceSubsetByComputerID(Int32 p_ComputerID, SoftwareFileCollection p_Objects) at ManageSoft.Inventory.Importer.DatabaseImport.Commit() at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleEndElement() at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, String sour ceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stats, IDispatcherPrefer ences preferences) ---- Type: 'System.InvalidOperationException' Message: 'The given value of type Int64 from the data source cannot be converted to type int of the specified target column.' Source: 'System.Data' --StackTrace:-- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& 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, TaskCompletionSourc e`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkComman dText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, Ca ncellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, Cancellat ionToken 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(IDataReader reader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(IDbConnection p_DestinationConnection, IDbTransaction p_DestinationTr ansaction, String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_InputDataReader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_Input DataReader) at ManageSoft.Database.Impl.SoftwareFileTable.DeleteObjects(DatabaseObjectCollection`1 p_Objects) at ManageSoft.Database.Impl.DatabaseTableBase`2.ReplaceObjects(IEnumerable`1 p_OldObjects, TCollection p_NewObjects) at ManageSoft.Database.Impl.SoftwareFileTable.ReplaceSubsetByComputerID(Int32 p_ComputerID, SoftwareFileCollection p_Objects) at ManageSoft.Inventory.Importer.DatabaseImport.Commit() at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleEndElement() at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, String sour ceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stats, IDispatcherPrefer ences preferences) -------------------- EXCEPTION: -------------------- System.OverflowException: Failed to convert parameter value from a Int64 to a Int32. ---> System.OverflowException: Value was eith er too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) ---- Type: 'System.OverflowException' Message: 'Failed to convert parameter value from a Int64 to a Int32.' Source: 'System.Data' --StackTrace:-- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) -------------------- EXCEPTION: -------------------- System.OverflowException: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) ---- Type: 'System.OverflowException' Message: 'Value was either too large or too small for an Int32.' Source: 'mscorlib' --StackTrace:-- at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) -------------------- EXCEPTION: -------------------- System.InvalidOperationException: The given value of type Int64 from the data source cannot be converted to type int of the specif ied target column. ---> System.OverflowException: Failed to convert parameter value from a Int64 to a Int32. ---> System.OverflowE xception: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& 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, TaskCompletionSourc e`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkComman dText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, Ca ncellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, Cancellat ionToken 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(IDataReader reader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(IDbConnection p_DestinationConnection, IDbTransaction p_DestinationTr ansaction, String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_InputDataReader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_Input DataReader) at ManageSoft.Database.Impl.SoftwareFileTable.DeleteObjects(DatabaseObjectCollection`1 p_Objects) at ManageSoft.Database.Impl.DatabaseTableBase`2.ReplaceObjects(IEnumerable`1 p_OldObjects, TCollection p_NewObjects) at ManageSoft.Database.Impl.SoftwareFileTable.ReplaceSubsetByComputerID(Int32 p_ComputerID, SoftwareFileCollection p_Objects) at ManageSoft.Inventory.Importer.DatabaseImport.Commit() at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleEndElement() at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, String sour ceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stats, IDispatcherPrefer ences preferences) at ManageSoft.Import.Dispatcher.runImporter_ActualExecution_invokeImporter(ItemProcessingTask processingTask) ---- Type: 'System.InvalidOperationException' Message: 'The given value of type Int64 from the data source cannot be converted to type int of the specified target column.' Source: 'System.Data' --StackTrace:-- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& 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, TaskCompletionSourc e`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkComman dText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, Ca ncellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, Cancellat ionToken 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(IDataReader reader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(IDbConnection p_DestinationConnection, IDbTransaction p_DestinationTr ansaction, String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_InputDataReader) at ManageSoft.Database.Impl.DatabaseLayerBaseSql.BulkCopy(String p_DestinationTableName, Int32 p_BatchSize, IDataReader p_Input DataReader) at ManageSoft.Database.Impl.SoftwareFileTable.DeleteObjects(DatabaseObjectCollection`1 p_Objects) at ManageSoft.Database.Impl.DatabaseTableBase`2.ReplaceObjects(IEnumerable`1 p_OldObjects, TCollection p_NewObjects) at ManageSoft.Database.Impl.SoftwareFileTable.ReplaceSubsetByComputerID(Int32 p_ComputerID, SoftwareFileCollection p_Objects) at ManageSoft.Inventory.Importer.DatabaseImport.Commit() at ManageSoft.Inventory.Importer.Implementation.RootNodeProcessor.HandleEndElement() at ManageSoft.Inventory.Importer.InventoryImporter.Import(String importType, Stream inputStream, Boolean isGzipped, String sour ceIdentifier, String targetFilename, MGSLicenseTermCheckResult licenseCheckResult, ImportProcessingStats& stats, IDispatcherPrefer ences preferences) at ManageSoft.Import.Dispatcher.runImporter_ActualExecution_invokeImporter(ItemProcessingTask processingTask) -------------------- EXCEPTION: -------------------- System.OverflowException: Failed to convert parameter value from a Int64 to a Int32. ---> System.OverflowException: Value was eith er too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) ---- Type: 'System.OverflowException' Message: 'Failed to convert parameter value from a Int64 to a Int32.' Source: 'System.Data' --StackTrace:-- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Bool ean& coercedToDataFeed) -------------------- EXCEPTION: -------------------- System.OverflowException: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) ---- Type: 'System.OverflowException' Message: 'Value was either too large or too small for an Int32.' Source: 'mscorlib' --StackTrace:-- at System.Convert.ToInt32(Int64 value) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) -------------------- File C:\ProgramData\Flexera Software\Incoming\Inventories\system on x01bopaldb1a at 20210710T181201 (Full).ndi.gz: Unexpected exce ption in importer