Problem To Import Repository (Doc ID 1579665.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM Service - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

Environment
===========
8.1.1.10 [23021]

Description
=========

1) You have completed IRM in Development environment after upgrading from V8.1.1.9 to V 8.1.1.10

2) After that you have done some configuration changes in the environment in Development.

3) You have then exported the repository.

4) Tring to import the repository into Production environment and the import is failing with the error below

Error
=====
insert into SIEBEL.S_FIELD (BUSCOMP_ID,
CALCULATED,
CALCVAL,
COL_NAME,
COMMENTS,
COMPOSITE_FLG,
CONFLICT_ID,
CREATED,
CREATED_BY,
CURR_CD_FLD_NAME,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
DEST_FLD_NAME,
DISA_SEARCH_FLG,
DISA_SORT_FLG,
EXCH_DT_FLD_NAME,
FORCEACTIVE,
FORCECASE,
HIDDEN,
IMM_POST_CHG_FLG,
INACTIVE_FLG,
INT_PICK_APPLET,
JOIN_NAME,
LAST_UPD,
LAST_UPD_BY,
LINKSPEC,
MODIFICATION_NUM,
MODULE_NAME,
MSG_DISP_MODE_CD,
MULTI_VALUED,
MVG_KEY,
MVLINK_NAME,
NAME,
NOCOPY,
ORASEQUENCEOBJ,
PICKLIST_NAME,
POSTDEFVAL,
PREC_NUM,
PREDEFVAL,
READONLY,
REPOSITORY_ID,
REQUIRED,
ROW_ID,
SCALE,
SSE_FLG,
SST_FLG,
SSV_FLG,
TEXTLEN,
TYPE,
USE_DFLT_SENS,
VALIDATION,
VLDTN_MSG_REF) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_date, 'repimexp', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

2013-08-02 11:23:39 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_FIELD_U1) violated

Impact
======

This issue is occurring in Production and hence is critical.

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