azure - 复制事件失败并出现以下错误

Question

{ "errorCode": "2200", "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer. DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.',Source=,''Type=System.Data.SqlClient.SqlException,Message=PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown., Source=.Net SqlClient Data Provider,SqlErrorNumber=100000,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=100000,State=1,Message=PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.,},],'", "failureType": "UserError", "target": "hana_ODS_DEV" }

谁能告诉我这个错误的主要原因吗？我正在尝试将数据从 SAP HANA 迁移到 Azure SQL 数据仓库

Answer 1

当目标的一列或多列的定义大小小于您尝试复制的数据时，就会发生此错误。只需增加列的大小，您的 ADF 就会平稳运行。共享代码片段查询以增加 ADW 中列的大小，

更改表table_name更改列columne_name数据类型NULL

注意-

1. 您无法减小 ADW 中列的大小。您只需增加大小即可。
2. 错误消息未提供有关导致复制事件失败的列或行的详细信息。您需要手动解决这个问题。

请告诉我这是否有效。