2025/6/26 10:06:06 SqlBulkCopyByDatatable ConnectionString：server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999 tableName：SinadealTradeDB.dbo.WorkOrderAttachment
 DataTable:[{"WorkOrderId":"COS20250626100604A16B","AttachmentName":"To help you assess the situation, I’ve uploaded new photos and videos showing the current state of the scooter:","AttachmentURL":"https://drive.google.com/drive/folders/107bgZqdg2Ymnwzuurk7lfeyJXa_ouDAS?usp=drive_link","CreatedUserId":"2739","CreatedTime":"2025/6/26 10:06:06","UpdatedUserId":null,"UpdatedTime":null,"AttachmentLink":null}]
数据处理过程中报错：System.InvalidOperationException: 来自数据源的 String 类型的给定值不能转换为指定目标列的类型 nvarchar。 ---> System.InvalidOperationException: String 或 binary 数据将被截断。
   在 System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
   --- 内部异常堆栈跟踪的结尾 ---
   在 System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
   在 System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)
   在 System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
   在 System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   在 Vayava.Erp.Dal.Product.ProductService.SqlBulkCopyByDatatable(String tableName, DataTable dt) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Product\ProductService.cs:行号 10544
2025/6/26 16:30:01 SqlBulkCopyByDatatable ConnectionString：server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999 tableName：SinadealTradeDB.dbo.OrderShippingRecord
 DataTable:[{"Result":null,"CreatedUserId":"admin","CreatedTime":"2025/6/26 16:30:00","UpdatedUserId":null,"UpdatedTime":null,"MessageID":"472151767803496482","ID":10108916,"PackageID":"8278886","TrackingNumber":"22680A011-250626-0002","OldTrackingNumber":"","TrackingNumberType":"1","TransDate":"2025/6/26 16:28:01","WMSLogisticId":"L1029","WMSLogisticWayId":"N+NLDY","ActualWeight":"35.000","Carriage":"0.00","LogisticsNumber":"","ActionType":"1"}]
数据处理过程中报错：System.Data.SqlClient.SqlException (0x80131904): 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。) ---> System.ComponentModel.Win32Exception (0x80004005): 远程主机强迫关闭了一个现有的连接。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   在 System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
   在 System.Data.SqlClient.SqlBulkCopy.SubmitUpdateBulkCommand(String TDSCommand)
   在 System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
   在 System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   在 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   在 Vayava.Erp.Dal.Product.ProductService.SqlBulkCopyByDatatable(String tableName, DataTable dt) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Product\ProductService.cs:行号 10544
ClientConnectionId:5016148a-ff23-4d5f-ac46-4cc86731781a
Error Number:10054,State:0,Class:20