My Oracle Support Banner

Import Data Cartridge Error ORA-02292 Which Were Reported As "Ignored" (Doc ID 1093772.1)

Last updated on SEPTEMBER 12, 2019

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 to 6.3.1 [Release 6.3]
Information in this document applies to any platform.

Goal

During the import of the cartridge following errors appears in a log:

C:\Program Files\p631b221\SDK\XMLImportExport>import ./data/Release4_20100326_07
47_transport_bandwidth_v2.0-04-06.xml ./config/Sol-live.xml -n transport_bandwid
th -v 2.0
********************************************************************************

Order and Service Management XML Import/Export Tool - ver. 6.3.1.221
Copyright (C) 1998, 2007, Oracle.
All Rights Reserved.
www.oracle.com
********************************************************************************


Importing from C:\Program Files\p631b221\SDK\XMLImportExport\data\Release4_20100
326_0747_transport_bandwidth_v2.0-04-06.xml into OMS schema v6.3.1.3.9 at databa
se [jdbc:oracle:thin:@147.149.193.250:1521:omsap1]
Parsing C:\Program Files\p631b221\SDK\XMLImportExport\data\Release4_20100326_074
7_transport_bandwidth_v2.0-04-06.xml...
Scanning for entities in C:\Program Files\p631b221\SDK\XMLImportExport\data\Rele
ase4_20100326_0747_transport_bandwidth_v2.0-04-06.xml...
Processing 1094 entities...
Import 1% complete (14 entities processed: 0 changed, 14 unchanged)
Import 6% complete (68 entities processed: 0 changed, 68 unchanged)
Import 11% complete (122 entities processed: 1 changed, 121 unchanged)
Import 16% complete (176 entities processed: 1 changed, 175 unchanged)
Import 21% complete (230 entities processed: 2 changed, 228 unchanged)
Import 26% complete (284 entities processed: 2 changed, 282 unchanged)
Import 31% complete (338 entities processed: 14 changed, 324 unchanged)
Import 36% complete (392 entities processed: 16 changed, 376 unchanged)
Import 41% complete (446 entities processed: 26 changed, 420 unchanged)
Import 46% complete (500 entities processed: 26 changed, 474 unchanged)
Import 51% complete (554 entities processed: 26 changed, 528 unchanged)
ProxyException [ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_IN
PUT_02) violated - child record found
Nested Exception: ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_
INPUT_02) violated - child record found
] ignored while adding Transition
ProxyException [ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_IN
PUT_02) violated - child record found
Nested Exception: ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_
INPUT_02) violated - child record found
] ignored while adding Transition
ProxyException [ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_IN
PUT_02) violated - child record found
Nested Exception: ORA-02292: integrity constraint (PROVISION631.FK_OM_ORDER_POS_
INPUT_02) violated - child record found
] ignored while adding Transition
Import 56% complete (608 entities processed: 62 changed, 546 unchanged)
Import 61% complete (662 entities processed: 85 changed, 577 unchanged)
Import 65% complete (716 entities processed: 136 changed, 580 unchanged)
Import 70% complete (770 entities processed: 154 changed, 616 unchanged)
Import 75% complete (824 entities processed: 186 changed, 638 unchanged)
Import 80% complete (878 entities processed: 189 changed, 689 unchanged)
Import 85% complete (932 entities processed: 231 changed, 701 unchanged)
Import 90% complete (986 entities processed: 280 changed, 706 unchanged)
Import 95% complete (1040 entities processed: 318 changed, 722 unchanged)
The token [om_ordinst_value_pkg.] in SQL expression for rule [test] contains inv
alid an entity ID [34328]; no entity found in document based on this ID!
Import 100% complete (1094 entities processed: 349 changed, 745 unchanged)
Committing imported entities to database...
Commit complete.
Import complete.
C:\Program Files\p631b221\SDK\XMLImportExport>

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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