JAVA Extract v12.1.2 Getting ABENDED ON Large Transaction Using maxGroupSize=50 (Doc ID 2164814.1)

Last updated on JULY 17, 2017

Applies to:

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

Goal

Java Adapter:

***********************************************************************
Oracle GoldenGate Capture
Version 12.1.2.1.4 20470586 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150303.1209
Linux, x64, 64bit (optimized), Generic on Mar 3 2015 14:52:25

***********************************************************************
Oracle GoldenGate Java Adapter, 12.1.2.1.6.001
Copyright (c) 2007,2015. Oracle and/or its affiliates. All rights reserved
Built with Java 1.7.0_79 (class version: 51.0)
Java user-exit native library: 12.1.2.1.6.001
OGGADP_12.1.2.1.1ADBP_PLATFORMS_151021.1226
EnterpriseServer_R5-U8 [64 (64-bit); Java 7]; GG Java API: 12.1.2.1.6.001
(Build: 20151021_130239)

***********************************************************************

Using:

gg.handler.hl_t1.maxGroupSize=50
gg.handler.hl_t1.minGroupSize=50
default goldengate.userexit.nochkpt=false

is not breaking large transactions and fails with:

2016-05-06 16:39:20 INFO OGG-06509 Using the following key columns for
source table WMPCHRM1.RESV_LOCN_HDR: RESV_LOCN_HDR_ID.
Exception in thread "main" com.goldengate.atg.util.GGException: Unable to
commit transaction, STATUS=ABEND
at
com.goldengate.atg.datasource.UserExitDataSource.commitActiveTransaction(UserE
xitDataSource.java:1404)
at
com.goldengate.atg.datasource.UserExitDataSource.commitTx(UserExitDataSource.j
ava:1338)
Error occured in javawriter.c[752]:
***********************************************************************
Exception received committing transaction:
com.goldengate.atg.util.GGException: Unable to commit transaction,
STATUS=ABEND

2016-05-06 16:39:20 ERROR OGG-01126 Abending at user-exit request.


 

Solution

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