Error when Upgrade from Siebel Release 8.1.1.10 To OP15.0 with Patchset 10 (Doc ID 2138791.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 15.10 [IP2015] and later
Information in this document applies to any platform.

Goal

We are upgrading from 8.1.1.10 to IP15 patchset 10 but Dev upgrep upgrade process is failing with following error at Import prior Siebel repository, New siebel repository , Custom siebel repository step when creating s_column table. Please find attached log for more info

ORA-01461: can bind a LONG value only for insert into a LONG column

SR_KEY_SEQUENCE,
VALID_CONDITION) values (?, ?, ?, ?, ?, ?, ?, ?, ?, current_date, 'repimexp', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

2016-05-13 20:42:20 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column


2016-05-13 20:42:20

2016-05-13 20:42:20 S1000: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column

2016-05-13 20:42:20

2016-05-13 20:42:20 Array insert failed. Retry this array row by row ...

2016-05-13 20:42:20 SQL Statement:
insert into siebel.S_COLUMN (ALIAS,
ASCII_ONLY_FLG,
CASCADE_CLEAR,
CASE_MODE,
COMPUTE_EXPR,
CONFLICT_ID,
CREATED,
CREATED_BY,
DATA_TYPE,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
DEFAULT_VAL,
DENORM_PATH,
DESC_TEXT,
DFLT_INSNSTVTY_CD,
EIM_PROC_COL_FLG,
ENCRPKEY_IDX_COL,
FKEY_TBL_ID,
FK_COL_1M_REL_NAME,
FK_COL_M1_REL_NAME,
INACTIVE_FLG,
LAST_UPD,
LAST_UPD_BY,
LENGTH,
LOV_BOUNDED,
LOV_TYPE_CD,
MODIFICATION_NUM,
MODULE_NAME,
NAME,
NO_MATCH_VALUE,
NULLABLE,
PARTITION_SEQ_NUM,
PC_COL_ID,
PC_JOIN_COL_ID,
PC_TBL_ID,
PJ_COL_ID,
PREC_NUM,
PROD_SCRIPT_FLGS,
PR_CHILD_COL,
PR_INTER_TBL_ID,
PR_KEY,
REPOSITORY_ID,
REQUIRED,
ROW_ID,
SCALE,
SEQUENCE,
SEQ_NAME,
SSE_FLG,
SST_FLG,
SSV_FLG,
STAT_CD,
SYS_FLD_NAME,
TBL_ID,
TEST_SCRIPT_FLGS,
TRANSLATE_FLG,
TRANS_TABLE_ID,
TXN_LOG_CD,
TYPE,
USER_NAME,
USE_FKEY,
USR_KEY_SEQUENCE,
VALID_CONDITION)
Please find the attached log
 

Solution

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