Incremental ETL Failed With the Error 'ORA-12899: value too large for column'
(Doc ID 1590584.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Insight - Version 7.0.2 and laterInformation in this document applies to any platform.
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
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 |