My Oracle Support Banner

OGG Teradata Replicat-Database error -3110 and SQL error -2801 (Doc ID 2697557.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

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

Symptoms

The OGG Teradata replicat(12.3.0.1.x) failed with the following error even with

Reperror -2801, discard

2020-02-18 11:26:03 WARNING OGG-01004 Aborted grouped transaction on <Schemaname>.<tablename>, Database error -3110 ([SQL error -3110

(0xfffff3da)][Teradata][ODBC Teradata Driver][Teradata Database](-3110)The transaction was aborted by the user.[Teradata][ODBC Teradata Driver] (21)

Operation Canceled.[Teradata][ODBC Teradata Driver][Teradata Database](-2801)Duplicate unique prime key error in <Schemaname>.<tablename>.).

2020-02-18 11:26:03 ERROR OGG-01296 Error mapping from <Schemaname>.<tablename> to <Schemaname>.<tablename>.

Changes

The issue was getting reproduced even when using

Database Version:

Teradata

Version 16.20.0901 16.20.09.01

ODBC Version 03.52.0000

Driver Information:

tdataodbc_sb64.so

Version 16.20.00.087

ODBC Version 03.52

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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