Siebel Upgrade Upgrep Fails With ORA-12899: Value Too Large For Column and REPIMEXP-ERR-1124 On S_ACCELERATOR While Importing the Repository (Doc ID 2019907.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

When attempting to run  (Upgrep + Upgphys) step in Test or Production upgrades, the import repository fails as following. These errors can be seen in imprep_*.log file.

ERROR
-----------------------
2015-05-30 16:44:35 SQL Statement:
insert into SIEBEL.S_ACCELERATOR (BRS_PLATFORM_CD,
COMMAND_ID,
COMMENTS,
CONFLICT_ID,
CREATED,
CREATED_BY,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
DISPLAY_NAME_REF,
INACTIVE_FLG,
KEY_SEQUENCE,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
NAME,
REPOSITORY_ID,
ROW_ID,
SSE_FLG,
SST_FLG,
SSV_FLG) values (?, ?, ?, ?, ?, ?, current_date, 'repimexp', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

2015-05-30 16:44:35 [tp][ODBC Oracle driver][Oracle]ORA-12899: value too large for column "SIEBEL"."S_ACCELERATOR"."INACTIVE_FLG" (actual: 4, maximum: 1)
2015-05-30 16:44:35 REPIMEXP-ERR-1124: Unable to import table "S_ACCELERATOR" (UTLOdbcExecute insert).
2015-05-30 16:44:35 Repository import process fails in table S_ACCELERATOR
2015-05-30 16:44:35 Rollback imported tables ...
2015-05-30 16:44:35 Rollback table 0: S_ACCELERATOR ... deleted 0 rows
2015-05-30 16:44:35 Rollback table 1: S_REPOSITORY ... deleted 1 rows
2015-05-30 16:44:35 Can not import file: C:\Siebel\8.1.1.14.0\ses\dbsrvr/oracle/custrep.dat.
2015-05-30 16:44:35 Error in doImport ().

Cause

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