ORA-02291 integrity constraint Error in Demantra Upgrade process observed in the BAL_BM.log (Doc ID 1206736.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

The following ORA-02291 error occurred during the Demantra Upgrade process*


Snapshot of errors observed in the BAL_BM.log after the Demantra Upgrade failed

2010-09-07 09:32:37,880 [DEBUG] - STDOUT> --------------------------------------------------------------------------------
2010-09-07 09:32:37,880 [DEBUG] - STDOUT> Populating LOCATION default combination
2010-09-07 09:32:37,880 [DEBUG] - STDOUT>
2010-09-07 09:32:37,880 [DEBUG] - STDOUT> 1 row selected.
2010-09-07 09:32:37,880 [DEBUG] - STDOUT>
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> merge INTO location USING (select 0 loc_id from dual) temp ON(loc_id=location_id)
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> *
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> ERROR at line 1:
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> ORA-02291: integrity constraint (DEMANTRA.LOCATION_FK3) violated - parent key
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> not found
2010-09-07 09:32:37,927 [DEBUG] - STDOUT>
2010-09-07 09:32:37,927 [DEBUG] - STDOUT>
2010-09-07 09:32:37,927 [DEBUG] - STDOUT>
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> UPGRADE_INFO
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> --------------------------------------------------------------------------------
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> Populating ITEMS default combination
2010-09-07 09:32:37,927 [DEBUG] - STDOUT>
2010-09-07 09:32:37,927 [DEBUG] - STDOUT> 1 row selected.
2010-09-07 09:32:37,927 [DEBUG] - STDOUT>
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> merge INTO items USING (select 0 it_id from dual) temp ON(it_id=item_id)
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> *
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> ERROR at line 1:
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> ORA-02291: integrity constraint (DEMANTRA.ITEMS_FK1) violated - parent key not
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> found
2010-09-07 09:32:37,974 [DEBUG] - STDOUT>
2010-09-07 09:32:37,974 [DEBUG] - STDOUT>
2010-09-07 09:32:37,974 [DEBUG] - STDOUT>
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> UPGRADE_INFO
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> --------------------------------------------------------------------------------
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> Populating MDP_MATRIX default combination
2010-09-07 09:32:37,974 [DEBUG] - STDOUT>
2010-09-07 09:32:37,974 [DEBUG] - STDOUT> 1 row selected.
2010-09-07 09:32:37,974 [DEBUG] - STDOUT>
2010-09-07 09:32:38,068 [DEBUG] - STDOUT> merge INTO mdp_matrix USING (select 0 it_id, 0 loc_id from dual) temp ON(it_id=item_id and loc_id=location_id)
2010-09-07 09:32:38,068 [DEBUG] - STDOUT> *
2010-09-07 09:32:38,068 [DEBUG] - STDOUT> ERROR at line 1:
2010-09-07 09:32:38,068 [DEBUG] - STDOUT> ORA-02291: integrity constraint (DEMANTRA.MDP_MATRIX_ITEM_ID_FK) violated -
2010-09-07 09:32:38,068 [DEBUG] - STDOUT> parent key not found

*also observed occasionally during Member Management or Add New Item actions.

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