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:
Siebel Public Sector Service - Version 8.1.1.14 [IP2014] and laterInformation in this document applies to any platform.
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
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 |