My Oracle Support Banner

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

Last updated on NOVEMBER 28, 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

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


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