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

Last updated on FEBRUARY 04, 2016

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.

Symptoms

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

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

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