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 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

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

Table definition
"VALUE_TEXT" VARCHAR2(2048 CHAR) COLLATE utf8_unicode_ci DEFAULT NULL

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.

Changes

 

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!


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