My Oracle Support Banner

ETL Fails After Installing Argus Safety Patch ORA-12899: value too large for column (Doc ID 1679226.1)

Last updated on JUNE 09, 2020

Applies to:

Oracle Argus Mart - Version 1.0 and later
Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.


ETL (Incremental and Initial) fails for Argus Insight and Argus Mart with the following error message after installing

ODI-1217: Session SCN_populate_stage_tables_CASE02 (8913564) fails with return code 20010.
ODI-1226: Step PRC_populate_stage_tables_CASE02 fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_stage_tables_CASE02 execution fails.
ODI-1228: Task PRC_populate_stage_tables_CASE02 (Procedure) fails on the target ORACLE connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-12899: value too large for column "AM_STAGE_USER"."SDLP_CASE_PROD_DEVICES"."CATALOG_OTHER" (actual: 100, maximum: 30)
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 487

-- ERROR while processing sdlp_case_prod_devices at 02-Jun-2014 14:03:12
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 123
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 502
ORA-06512: at line 3


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.