Validation Error While Exporting Repository due to Orphan Records in the repository

(Doc ID 2110366.1)

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

On : 15.5 [IP2015] version,

Error while exporting repository

While exporting repository from one environment (Siebel IP2015, PS5), we were getting below error: Data verification Error,

 

s2016-02-18 07:15:17 /siebel/dit3/siebsrvr/bin/repimexp /a E /u sadmin /p ***** /c icondit3_DSN /d SIEBEL /r "Siebel Repository" /f /siebel/dit3/exprep/SiebelRepbackup_IP2015_latest.dat /v Y /l /siebel/dit3/siebsrvr/log/exprep/output/exprep.log

 

Table 351, S_UI_OBJ_EXP_FL, row: null has foreign key: 1J9-12X has not been defined in parent table S_UI_OBJ_EXP.

2016-02-18 07:21:51 TOTAL TABLES: 393
2016-02-18 07:21:51 TOTAL ROWS : 9691954
2016-02-18 07:21:51 Data verification failed.
2016-02-18 07:21:51 Error in doExport (RtxNdVerify).
2016-02-18 07:21:51 Error in Main function...
2016-02-18 07:21:52 Elapsed time: 6 min 35 sec.
2016-02-18 07:21:52 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)





ERROR
-----------------------

Table 351, S_UI_OBJ_EXP_FL, row: null has foreign key: 1J9-12X has not been defined in parent table S_UI_OBJ_EXP.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. perform repository export/import
2. data verification error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform export/import

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