Cannot export repository after upgrade form Siebel 8.1.1 SEA to IP17 (Doc ID 2457837.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

On : 17.6 [IP2017] version, Upgrade

ACTUAL BEHAVIOR
---------------
The following error occurs during the repository export.
T2018-06-11 23:18:57 SQLstyle is 'Microsoft SQL Server' 

2018-06-11 23:18:58 Process Name: Repository Import/Export Utility, Status: Started, Parameter: , Message  
2018-06-11 23:20:51 Message: DIC-29,
Additional Message: Type 'Applet Web Template Item Prop' parent type id '1-11K8-3ZMBA'

2018-06-11 23:20:51 Message: DIC-29, Additional Message: Type 'Applet Web Template Item Prop' parent type id '1-11K8-3ZMBA'
2018-06-11 23:20:51 Message: DIC-29,
Additional Message: Type 'UI Expression' parent type id '1-11K8-3ZMF5' 

018-06-11 23:25:11   Exporting table                S_APPL_WTMPL_RX ... exported          0 rows
2018-06-11 23:25:11 Table S_APPL_WT_IT_PR's parent table is unavailable.
2018-06-11 23:25:11 Error in doExport (<null>).
2018-06-11 23:25:11 Error in Main function...
2018-06-11 23:25:11 Table 0, S_ACCELERATOR, row: null has foreign key: 1-11K8-11 has not been defined in parent table S_COMMAND.
2018-06-11 23:25:11 Table 0, S_ACCELERATOR, row: null has foreign key: 1-11K8-13 has not been defined in parent table S_COMMAND.
2018-06-11 23:25:11 Table 0, S_ACCELERATOR, row: null has foreign key: 1-11K8-15 has not been defined in parent table S_COMMAND. 

2018-06-11 23:25:13 Total: 214 rows have not been defined in table S_COMMAND.
2018-06-11 23:25:13 Table 9, S_APPLET, row: null has foreign key: 1-11K8-OEV has not been defined in parent table S_PROJECT.
2018-06-11 23:25:13 Table 9, S_APPLET, row: null has foreign key: 1-ZUVG5 has not been defined in parent table S_PROJECT.
2018-06-11 23:25:13 Table 9, S_APPLET, row: null has foreign key: 1-ZUVG7 has not been defined in parent table S_PROJECT. 
2018-06-11 23:25:21 Total: 1367 rows have not been defined in table S_PROJECT.
2018-06-11 23:25:21 Table 0, S_ACCELERATOR, row: null has foreign key: 1@239161 has not been defined in parent table S_WORKSPACE.
2018-06-11 23:25:21 Total: 1 rows have not been defined in table S_WORKSPACE.
2018-06-11 23:25:21 Elapsed time: 6 min 24 sec.
2018-06-11 23:25:21 (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)
EXPECTED BEHAVIOR
-----------------------
The repository exported should be done successfully.

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

1. Upgrade from Siebel 8.1.1 SEA to 17.6
2.Run the command to export the repository, the error occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, development repository can not be exported for production-test and production upgrades.

Changes

Cause

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