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 JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.0 and laterInformation 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.
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 |