Error while loading data

Gunti, Srikanth 0

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,'",

Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-08T14:44:22.17+00:00

Hi @Gunti, Srikanth

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,711 Reputation points MVP

2025-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 19,390 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.
Gunti, Srikanth 0 Reputation points

2025-01-13T19:18:36.1266667+00:00

Thanks for the update. Reviewing the updates, will get back to you shortly.
Gunti, Srikanth 0 Reputation points

2025-01-13T21:53:56.0266667+00:00

Tried changing the settings, but still no luck.

{ "errorCode": "2200", "message": "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,'", "failureType": "UserError", "target": "Extract-Files-to-Blob", "details": [] }
Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-15T18:59:42.7366667+00:00

@Gunti, Srikanth It seems that for some particular string(s) that the error happening. Try to use different encoding options available in your source dataset and see if that resolves your problem. Thank you.
Gunti, Srikanth 0 Reputation points

2025-01-15T23:16:59.5033333+00:00

Hi All,

Thanks for your support.

Issue is resolved. There was typo in settings file, which caused this issue.
Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-16T09:17:32.15+00:00

@Gunti, Srikanth Glad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer
Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-17T08:50:36.7233333+00:00

@Gunti, Srikanth Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-16T09:17:00.7166667+00:00

Hi @Gunti, Srikanth
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Ask: 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,'",

Solution: Issue is resolved. There was typo in settings file, which caused this issue.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error while loading data

1 answer

Your answer