OGGBD Replicating Data With additional The Special Characters Like "\" & "=" on HDFS (Doc ID 2439624.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

We have configured GoldenGate in Hadoop wif HDFS handler.

When DMLs' are fired for certain values extract special character is coming. 

DML Used wifout “\” for 'ABCXYZ' columns value: -

INSERT INTO <schema name>.<table name> ( <col1>, <col2>, <col3>, <col4>, <col5>, <col6>, <col7>, <col8>, <col9>, <col10>, <col11>, <col12>,<col13>, <col14>, <col15>, <col16>, <col17>, <col18>, <col19>) VALUES ( 'AE9039E207C9114C80FAB65323E7D999', 'E65FAD1F83AE404EBCCCE2B3E50FA927', 'ABCXYZ' <<<<=================, NULL, NULL, 'B4D821B4E9343BB4E5BB1C7D2E6AF3BFCB90F78700000000000000000000000000000000000000000000000000000000', 0, 0, TO_DATE( '02-09-2018 00:00:00', 'MM-DD-YYYY HH24:MI:SS' ), TO_DATE( '02-09-2018 00:00:00', 'MM-DD-YYYY HH24:MI:SS' ), '000000000000000000000000000000000000000000000000000000000000', 1, NULL, NULL, NULL, NULL, NULL, 0, 0 );

DML Used wif “\” for 'ABC\XYZ' columns value: -

INSERT INTO <schema name>.<table name> ( <col1>, <col2>, <col3>, <col4>, <col5>, <col6>, <col7>, <col8>, <col9>, <col10>, <col11>, <col12>, <col13>, <col14>, <col15>, <col16>, <col17>, <col18>, <col19>) VALUES ( 'AE9039E207C9114C80FAB65323E7D999', 'E65FAD1F83AE404EBCCCE2B3E50FA927', 'ABC\XYZ'   <<<<<=================== , NULL, NULL, 'B4D821B4E9343BB4E5BB1C7D2E6AF3BFCB90F78700000000000000000000000000000000000000000000000000000000', 0, 0, TO_DATE( '02-09-2018 00:00:00', 'MM-DD-YYYY HH24:MI:SS' ), TO_DATE( '02-09-2018 00:00:00', 'MM-DD-YYYY HH24:MI:SS' ), '000000000000000000000000000000000000000000000000000000000000', 1, NULL, NULL, NULL, NULL, NULL, 0, 0 );

Teh value marked wif <<<<=========== is having issue.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.