BUG: CLOB contents are translated to different language even though there is an entry made in English

[vnykmr36]

Table desc:

SQL> desc abcd
 Name     Null?    Type
 -------- -------- -------------
 ID       NOT NULL NUMBER(38)
 NAME              VARCHAR2(80)
 IMAG              BLOB
 DESCR             CLOB

Insert statement:

SQL> insert into abcd select rownum, dbms_random.string('p',60), UTL_RAW.CAST_TO_RAW('This is a test insert into blob column'), to_clob('This is a test insert into clob column') from xmltable('1 to 10');

Source DB inserted data:

SQL> select * from abcd where id=10;

        ID NAME                 IMAG                           DESCR
---------- -------------------- ------------------------------ ------------------------------
        10 :"(mjs`j""NsacxJ^N W 546869732069732061207465737420 This is a test insert into clo
           B?qvqClLJ>H;+_#2Ka9E 696E7365727420696E746F20626C6F b column
           g9[B%vAiwe%?~&%,Fu:5 6220636F6C756D6E

Payload in the file:

{"c_scn":410072,"c_idx":11,"xid":"0x0009.01c.000001a4","payload":[{"op":"c","schema":{"owner":"TEST","table":"ABCD"},"after":{"ID":10,"NAME":":\"(mjs`j\"\"NsacxJ^N WB?qvqClLJ>H;+_#2Ka9Eg9[B%vAiwe%?~&%,Fu:5","IMAG":"546869732069732061207465737420696e7365727420696e746f20626c6f6220636f6c756d6e","DESCR":"周楳<2069>猠愠瑥獴<2069>湳敲琠楮瑯<2063>汯戠捯汵浮"}}]}

The issue is true for all 10 rows inserted.

[vnykmr36]

I've used to_clob function while inserting.

[bersler]

Can you please provide reproduction steps:

1. take docker image for OLR + Oracle (preferred: https://github.com/bersler/OpenLogReplicator-tutorials so that the fault can be reproduced on Oracle XE)
2. set configuration of OLR to ... (preferred: json file)
3. run some SQL commands, restart, whatever else
4. achieve fault

or alternatively for other errors:

1. OLR configuration file
2. OLR checkpoint file set
3. set of redo log files which contain error
4. achieve fault

[bersler]

Hi @vnykmr36 . Did you have chance to find a way to reproduce the issue? I have tested CLOB and all works good. To fix it I need either the redo log files or a list of steps to reproduce it. If the problem is not possible to reproduce, I will close the ticket and we can open it back when the problem appears.

[bersler]

I still am unable to reproduce the issue, I plan to close this issue if nothing changes till end of may.

[bersler]

Unable to reproduce the issue, closed. We can reopen when we have a reproduction.