IP2016 Database Configuration Wizard Fails With ORA-22275 / REPIMEXP-ERR-1124 Errors (Doc ID 2218513.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 16.5 [IP2016] version, Installation

When attempting to configure Siebel Database, the following error occurs during Import Repository Data step:

imprep.log
-----------------------
2016-12-27 14:20:00 Importing table 230: S_RR_IMPORT_OBJ ... imported 29 rows

2016-12-27 14:20:05 SQL Statement:
insert into SIEBEL.S_RR_INT_OBJ (COMPILED_OBJ_DEFN,
CONFLICT_ID,
CREATED,
CREATED_BY,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
LANG_CD,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
NAME,
REPOSITORY_ID,
ROW_ID,
VERSION_NUM) values (?, ?, ?, ?, current_date, 'repimexp', ?, ?, ?, ?, ?, ?, ?, ?)

2016-12-27 14:20:05 [Oracle][ODBC][Ora]ORA-22275: invalid LOB locator specified
2016-12-27 14:20:05
2016-12-27 14:20:05 S1000: [Oracle][ODBC][Ora]ORA-22275: invalid LOB locator specified
2016-12-27 14:20:05
2016-12-27 14:20:05 Array insert failed. Retry this array row by row ...
2016-12-27 14:20:05 Error inserting row 351 into table S_RR_INT_OBJ
2016-12-27 14:20:05 Elmt 0; Column Name: 'COMPILED_OBJ_DEFN'; cbValue: -5887178
...
2016-12-27 14:20:10 REPIMEXP-ERR-1124: Unable to import table "S_RR_INT_OBJ" (UTLOdbcExecute insert).
2016-12-27 14:20:10 REPIMEXP-ERR-1123: Partially imported 350 rows for table "S_RR_INT_OBJ".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. During IP2016 Siebel Database Wizard step, the error above occurs during Import Repository Data step.


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