OGG MYSQL Extract Input Value For SQLEXEC Gets Corrupted During Characterset Conversion

(Doc ID 2341526.1)

Last updated on JANUARY 11, 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.1 OGGCORE_12.3.0.1.0_PLATFORMS_170804.2007
Windows x64 (optimized), MySQL Enterprise on Aug 5 2017 07:13:17

table supportdb.source, SQLEXEC (ID lookup, QUERY 'select research_id from lookup where id=?', PARAMS(p1=id),trace all),tokens (tkn_lookup=@GETVAL(lookup.research_id));


| SQLEXEC test2 error (While executing query there was no data found!
Prepared Statement (ID = 1), Query ('select research_id from lookup where id=?')):

2017-11/15 11:16:57.531 main |ERROR| 1125 er/sp.c

| > p1: ¿¿¿¿¿¿¿¿¿¿¿¿¿¿ <========

The INPUT value for SQLEXEC gets corrupted

Changes

 

Cause

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 hundreds of Community platforms