Copy Activity is failing with the following error

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" }

Can anyone please let me know the main cause for this error? I am trying to migrate the data from SAP HANA onto Azure SQL Dataware house

Solution

This error occurs when one or more columns of destination have defined size lesser than the data which you are trying to copy. Just increase the size of the columns and your ADF will run smoothly. Sharing the snippet query to increase the size of the column in ADW,

alter table table_name alter column columne_name datatype NULL

Note -

1. You cannot decrease the size of columns in ADW. You can just increase the size.
2. The error message does not give details about the column or row because of which copy activity fails. You need to figure that out manually.

Let me know if this works.

Comments

[Alberto Morillo]

Please verify on the sink side you did not confused SQL Azure Data Warehouse with SQL Azure Database.

[Sam]

No Alberto, I didn't I did double check.

[Muni Mishra]

this answer worked for me. Thanks