My Oracle Support Banner

Teradata replicat- SQLSTATE 22003 native database error -2616. [Teradata][ODBC Teradata Driver][Teradata Database](-2616)Numeric overflow occurred during computation. (Doc ID 2764977.1)

Last updated on MARCH 07, 2022

Applies to:

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

Symptoms

The teradata coordindated replicat failed with

2020-11-04 15:44:38 ERROR OGG-00551 Database operation failed: Retrieving
unique key definitions for <schema>.<Table name>. ODBC error:
SQLSTATE 22003 native database error -2616. [Teradata][ODBC Teradata
Driver][Teradata Database](-2616)Numeric overflow occurred during
computation.

The issue happens when the target Teradata table is more than 2GB in size.
When the target Teradata table is < 2 Gb in size, the replication works all
good and it only fails when Teradata table is > 2 gb.

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
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.