Azure Synapse Pipeline error - Generic Error

Question

Hi

I am trying to copy data from Gen 2 to table created in dedicated sql pool inside synapse sql pool. I am getting below error during pipeline execution in sink side.. could you please help?

"Message": "Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''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.,},],'",

Answer 1

Hi @Sangeetha ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your issue, you are getting error 'PdwManagedToNativeInteropException' while trying to copy data from ADLS to dedicated sql pool and you want to get rid of this error. Please let me know if my understanding is incorrect.

This error occurs when one or more columns of destination have defined size lesser than the data which you are trying to copy. Try increasing the size of the columns .

Below is the snippet query to increase the size of the column in DW:

alter table table_name alter column columne_name datatype NULL

Note - 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.

Reference: Copy Activity is failing with the following error

Hope this will help. Please let us know if any further queries.

---

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators