My Oracle Support Banner

GG Adapter v12.1.2.1.1 not trimming trailing spaces for CHAR columns. (Doc ID 2032444.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle GoldenGate Application Adapters - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

GG Adapter v12.1.2.1.1 not trimming trailing spaces for CHAR columns.

Looking at the trail in logdump, the <column_name> field has:

Column 6 (x0006), Len 27 (x001b)
0000 4d79 6572 7336 3230 3430 2020 2020 2020 2020 | ..xxxxx
2020 2020 2020 20 |

This is the ascii text "<column_value> ". So the text is followed
by 15 spaces.

Running this trail with v112104 Adapter with the default javaue.properties
results in trimmed spaces:

<col name='column_name' index='6'>
<after><![CDATA[column_value]]></after>
</col>

But processing the same trail with v121211 Adapter with the default
javaue.properties leaves the spaces:

<col name='column_name' index='6'>
<after><![CDATA[column_value ]]></after>
</col>



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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