OGG Big Data Adapter to HDFS Error: Oracle.goldengate.util.GGException: Unable To Commit Transaction, STATUS=ABEND (Doc ID 2197115.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.

Symptoms

OGG REPLICAT Adapter to HDFS:

***********************************************************************
Oracle GoldenGate Delivery
Version 12.2.0.1.160419 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160430.1401
Linux, x64, 64bit (optimized), Generic on Apr 30 2016 18:07:13

Oracle GoldenGate Java Adapter, 12.2.0.1.1.011
Copyright (c) 2007, 2016. Oracle and/or its affiliates. All rights reserved

is abending:

2016-10-18 08:09:38 INFO OGG-06511 Oracle GoldenGate Delivery, iload.prm: Using following columns in default map by name: DEPTNO, DNAME, LOC.
2016-10-18 08:09:38 INFO OGG-06510 Oracle GoldenGate Delivery, iload.prm: Using the following key columns for target table bdtest.DEPT: DEPTNO.
2016-10-18 08:09:38 INFO OGG-06506 Oracle GoldenGate Delivery, iload.prm: Wildcard MAP resolved (entry ggtest.*): MAP "GGTEST"."EMP", TARGET bdtest.EMP.
2016-10-18 08:09:38 INFO OGG-02758 Oracle GoldenGate Delivery, iload.prm: The definition for table GGTEST.EMP is obtained from definitions file ./dirsql/table.def.
2016-10-18 08:09:38 INFO OGG-06511 Oracle GoldenGate Delivery, iload.prm: Using following columns in default map by name: EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO.
2016-10-18 08:09:38 INFO OGG-06510 Oracle GoldenGate Delivery, iload.prm: Using the following key columns for target table bdtest.EMP: EMPNO.
2016-10-18 08:09:39 ERROR OGG-15051 Oracle GoldenGate Delivery, iload.prm: Java or JNI exception:
oracle.goldengate.util.GGException: Unable to commit transaction, STATUS=ABEND.
2016-10-18 08:09:39 ERROR OGG-01668 Oracle GoldenGate Delivery, iload.prm: PROCESS ABENDING.

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