SQL Error -2683 (0xfffff585)][Teradata] Database] Numeric Overflow Occurs Dring Computation - Causes Replicat Abend (Doc ID 1991906.1)

Last updated on MARCH 08, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 12.1.2.1.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Case 1

Replicating a table from an AS/400 to a TeraData database, the following error occurs
OGG-01004 Aborted grouped transaction on 'PRD_USD_OPT.SUNRISE_SFBASLIB_SFCOMH_T', Database error -2683 ([SQL error -2683 (0xfffff585)][Teradata][ODBC Teradata Driver][Teradata Database] Numeric overflow occurred during computation.
Column in question is

On the source table SFBASLIB.SFCOMH
 Phord# DECIMAL(10,0)

On the target table prd_usd_opt.SUNRISE_SFBASLIB_SFCOMH_T
 Phord# DECIMAL(10,0)

Discard file shows the following
Phord# = 1.383E11
000000: 31 2e 33 38 33 45 31 31 |1.383E11 |

logdump shows

Column 0 (x0000), Len 10 (x000a)
 0000 0000 0000 0000 0001 | ..........

has no values but the discard file says it can't update a value of 1.383E11 which has more than 10 digits

Now look at

Column 3 (x0003), Len 10 (x000a)  -> Phord#
 0000 0000 0001 a918 4eaa | ........N.

Convert X (1 a918 4eaa) to digit we get 7,131,909,802 which is 10 digits and matches the source data
 
Case 2:

Replicat abending with SQL error 2683

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