Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
murali23krishna
Contributor III
Contributor III

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

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?

Labels (2)
2 Replies
DesmondWOO
Support
Support

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

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
john_wang
Support
Support

Hello @murali23krishna ,

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

  1. Open Oracle source endpoint
  2. Go to the Advanced tab
  3. Open Internal Parameters
  4. Add a new parameter named truncateTrailingBinaryZerosInChars
  5. Uncheck the box and save the setting, the screenshot sample:
    john_wang_0-1702563183199.png

     

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

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!