Incremental ETL Failed With the Error 'ORA-12899: value too large for column' (Doc ID 1590584.1)

Last updated on JULY 06, 2015

Applies to:

Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Jul-2015***

Symptoms

Incremental ETL failed with the following error:

Oracle Corporation
Argus Insight Application => Automatic Email Generation

Incremental ETL FAILED to complete on database ILSPI01

Total ETL Time => 0 Hours 7 Mins 17 Seconds

ETL Start Time => 08-OCT-2013 04:33:50 AM
ETL End Time => 08-OCT-2013 04:41:07 AM

Error Message = ORA-12899: value too large for column "APR_HIST"."RPT_EXP_INCL_EVENT_HIST"."DESC_REPTD" (actual: 208, maximum: 200)
ORA-06512: at "APR_HIST.PKG_HIST_LOAD", line 72
ORA-06512: at "APR_MART.PKG_HIST_PROCESS", line 45


To review further details, please check following LOG tables:
1) ETL_JOBS
2) STAGING_DATA_INSERT_LOG
3) MART_DATA_INSERT_LOG

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