SIEBEL REPOSITORY EXPORT ERROR IN DOEXPORT (RTXNDVERIFY) Siebel CRM 16.X (Doc ID 2290346.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

Export repository failing


When trying to export siebel repository to file with srvrupwiz command and getting lot of foreign key errors for 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)

The issue can be reproduced at will with the following steps:

1. Exporting siebel repository with command line by naviging to siebsrvr/bin directory and invoking below command:
repimexp /a E /u <siebeladminuser> /p ***** /c ODBC_DSN /d <Tableownername> /r "Siebel Repository" /f /u01/app/siebel/dbsrvr/oracle/custom_xxx.dat /v Y /l /u01/app/siebel/siebsrvr/log/exprep/output/exprep.log

Cause

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