My Oracle Support Banner

OGG MySQL Extract Writes Incorrect Length To Trail For VARCHAR Multibyte Data Causing Replicat To Abend With "ERROR OGG-01163 Bad column length" (Doc ID 2419303.1)

Last updated on AUGUST 16, 2018

Applies to:

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


Oracle GoldenGate Capture for MySQL
Version OGGCORE_12.
Linux, x64, 64bit (optimized), MySQL Enterprise on May 14 2018 02:59:05

Table definition

Trail data

2018/04/30 10:34:30.000.136 Insert Len 26948 RBA 171722866
Name: phenotypes.phenotypic_detail_record (TDR Index: 1)
After Image: Partition 12 m

Column 2 (x0002), Len 25650 (x6432) <== Length

This causes the Replicat to fail with ERROR OGG-01163 Bad column length (25646) specified for column value_text
in table ogg.test_table, maximum allowable length is 6144.




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

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

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