OGG REPLICAT abend Error ORA-12899: value too large for column (Doc ID 1927858.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

v11.2.1 REPLICAT is abending with:

2014-09-16 22:05:59 WARNING OGG-01154 SQL error 12899 mapping JOBAPP.ST_SE_EMPLOYMENT_HST to JOBAPP.ST_SE_EMPLOYMENT_HST OCI Error ORA-12899: value too large for column "JOBAPP"."ST_SE_EMPLOYMENT_HST"."COMP_RAT" (actual: 45, maximum: 30) (status = 12899). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "JOBAPP"."ST_SE_EMPLOYMENT_HST"

The discard file shows the same error and that column displays Raw Data:

COMP_RAT = <Raw Data>
000000: e4 b8 80 e6 9d a1 30 2e 32 e5 85 83 ef bc 88 e5 |......0.2.......|
000010: af 84 e4 bb b6 ef bc 89

The table create DDL on the source and target tables show the DDL for the column COMP_RAT is identical: VARCHAR2(30).


A dump of the row on the source shows Japanese

SELECT COMP_RAT, dump(COMP_RAT)
FROM JOBAPP.ST_SE_EMPLOYMENT_HST
WHERE EMPLOYMENT_HST_ID=9108574;

COMP_RAT
------------------------------
DUMP(COMP_RAT)
--------------------------------------------------------------------------------
一条0.2元(寄件)
Typ=1 Len=24: 228,184,128,230,157,161,48,46,50,229,133,131,239,188,136,229,175,1
32,228,187,182,239,188,137

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