topic Re: Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:769) in Qlik Replicate

Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:769)

murali23krishna — Thu, 14 Dec 2023 05:07:31 GMT

I am using Oracle source endpoint and Kafka as the target endpoint, however when I check a few columns' data, I see trailing zeros are truncated and when I look at the log I see the subject message, is there a way to control this behavior?

Re: Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:769)

DesmondWOO — Thu, 14 Dec 2023 07:02:01 GMT

Hi @murali23krishna ,

Thanks for reaching out to the Qlik Community.

Could you send us the column definition and a sample record? I would like to better understand the data structure and content. If possible, please run the following SQL command:

select dump(your_column, 1016) from your_table;

and share the output.

Regards,
Desmond

Re: Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:769)

john_wang — Thu, 14 Dec 2023 14:14:29 GMT

Hello @murali23krishna ,

Besides Desmond's comment, let's try to add an internal parameter to tune Oracle source side behavior:

Open Oracle source endpoint
Go to the Advanced tab
Open Internal Parameters
Add a new parameter named truncateTrailingBinaryZerosInChars
Uncheck the box and save the setting, the screenshot sample:

Re-run the task and let us know if it helps.
Good luck,

John.