ADF copy activity failed while extracting data from DB2- Issue found for few records having special characters

Tanvee Gupta 1

I am doing a full extract from a table ABC. In copy activity, I have given a query as

select * from ABC

whereas I am facing issue for few rows (It has special characters - Japanese and Korean)

Error code - 2200

Failure type- User configuration issue

Details - Failure happened on 'Source' side. ErrorCode=DB2DriverRunFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error thrown from driver. Sql code: '-343',Source=Microsoft.DataTransfer.ClientLibrary.Db2Connector,''Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=HISMPCB0001 In BasePrimitiveConverter an exception has occurred. Exception description: Output buffer is smaller than required size 12 SQLSTATE=HY000 SQLCODE=-343,Source=Microsoft.HostIntegration.Drda.Requester,'

The character which is causing the issue is '轎ᆃ '

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2022-04-25T21:52:27.31+00:00

Hello @Tanvee Gupta ,
Thanks for the question and using MS Q&A platform.
What is the data type of the column which is having this value ? Have you tried converting the data type to some more genetic data type and see if that helps .
We will wait to hear from you . .
Thanks
Himanshu
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2022-04-27T20:25:11.543+00:00

Hello @Tanvee Gupta ,
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 back with the more details and we will try to help .
Thanks
Himanshu
Tanvee Gupta 1 Reputation point

2022-04-28T07:54:02.617+00:00

Hi @HimanshuSinha-msft
The datatype is varchar of the column.

I tried to cast it to various CCSID encoding to extract it but it is still not working.

Thanks tanvee
Tanvee Gupta 1 Reputation point

2022-05-12T10:27:01.707+00:00

Hi @HimanshuSinha-msft
I tried casting the column data to Graphic(n). It worked in ADF copy activity but the data is changed while extracting. Even for English characters, it is converting to Japanese which is not correct.

Could you please provide some other way which I can try to extract the data.

Thanks
Tanvee
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2022-05-24T16:50:01.5+00:00

Hello @Tanvee Gupta ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.
Thanks
Himanshu