Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,118 questions
Error while loading data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gunti, Srikanth
0
Reputation points
Getting below error message while loading data using Pipeline.
Failure happened on 'Source' side. ErrorCode=DB2DriverRunFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error thrown from driver. Sql code: '-204',Source=Microsoft.Connectors.Db2,''Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=SQLSTATE=42704 SQLCODE=-204,Source=Microsoft.HostIntegration.Drda.Requester,'",
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu 18,965 Reputation points Microsoft Vendor2025-01-08T14:44:22.17+00:00 Welcome to Microsoft Q&A platform and thanks for posting your query here.
Looks like related to data issue in your table. Kindly use fault tolerance settings to skip incompatible rows and log them to some storage and have review on that incompatible row internally to take a call.
Please check below link to know more about "Fault tolerance of copy activity in Azure Data Factory" https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance
I hope this helps! Let me know if you have any further questions.
-
Nandan Hegde 33,241 Reputation points MVP2025-01-08T16:48:11.9066667+00:00 Can you provide the activity and the connection details in which you are getting this error for us to help you out better
-
Smaran Thoomu 18,965 Reputation points Microsoft Vendor
2025-01-09T17:33:16.93+00:00 @Gunti, Srikanth We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer