SIEBEL REPOSITORY EXPORT ERROR IN DOEXPORT (RTXNDVERIFY) IP16 (Doc ID 2290346.1)

Last updated on AUGUST 06, 2017

Applies to:

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

Symptoms

On : 16.11 [IP2016] version, System Admin

Export repository fail


OS:RHL 6.6 64bit
Siebel Version: 16.11

When try to use export repository to file with command srvrupwiz but get a lot of foreign key error of some table.


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

Table 8, S_APLT_WTI_INTL, row: null has foreign key: 0CW-YS9-7XK has not been defined in parent table S_APLT_WTI_INTL.
Table 8, S_APLT_WTI_INTL, row: null has foreign key: 0CW-YS9-Q9E has not been defined in parent table S_APLT_WTI_INTL.
Table 8, S_APLT_WTI_INTL, row: null has foreign key: 0CW-YS9-KY6 has not been defined in parent table S_APLT_WTI_INTL.
Table 8, S_APLT_WTI_INTL, row: null has foreign key: 0CW-YS9-PB6 has not been defined in parent table S_APLT_WTI_INTL.
Table 8, S_APLT_WTI_INTL, row: null has foreign key: 0CW-YS9-PBC has not been defined in parent table S_APLT_WTI_INTL.

2017-07-14 04:54:25 Error in doExport (RtxNdVerify).

2017-07-14 04:54:25 Error in Main function...


2017-07-14 04:54:25 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Exporting siebel repository
repimexp /a E /u SADMIN /p ***** /c DEVP_DSN /d SIEBEL /r "Siebel Repository" /f /u01/app/siebel/dbsrvr/oracle/customer_dev.dat /v Y /l /u01/app/siebel/siebsrvr/log/exprep/output/exprep.log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users not able to export siebel repository to take backups.

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