OGG Java Adapter abends: Unable to retrieve value for Column (Doc ID 2274465.1)

Last updated on AUGUST 23, 2017

Applies to:

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

Symptoms

 

Oracle GoldenGate Java Adapter, 12.2.0.1.4.001
Copyright (c) 2007, 2016. Oracle and/or its affiliates. All rights reserved
Built with Java 1.7.0_45 (class version: 51.0)
Java user-exit native library: 12.2.0.1.4
OGGADP_12.2.0.1.1BDBP_PLATFORMS_161005.1315
EnterpriseServer_R5-U10 64 (64-bit), Java 7, GG Java API: 12.2.0.1.4.001
(Build: 20161005_134531)
2017-04-26 08:40:00: JAVAUSEREXIT(javauserexit.c:685) [DEBUG]: Done printing
version info...

 

 Error occured in ueutil.c[654]: Error (4) retrieving column value.
.
2017-04-26 08:40:00: JAVAUSEREXIT(javauserexit.c:921) [WARN]: Unable to
retrieve value for Column[2] 'DETAIL'
2017-04-26 08:40:00: UEUTIL(ueutil.c:1167) [ERROR]: Process exiting (ABEND)
Error occured in ueutil.c[1167]: Process exiting (ABEND)
An error has occurred, check the report file and user-exit log files for
details.

 

 

Changes

 The FF output for character columns is ascii. If the input cannot be interpreted, v12.1.2 will abend. But adding:
goldengate.userexit.utf8mode=false

will cause Adapter use the v11.2 functionality which is to skip what it cannot interpret.

When using goldengate.userexit.utf8mode=false, Adapter doesn't perform any explicit character encoding and defaults to the os charset encoding.

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