OBIA 11.1.1.7.1 Encountered Error JBO-26048: Constraint "C_DOMAIN_MEMBER_MAP_FK2" is violated While Importing Setup Data Using BIACM (Doc ID 1909641.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

You are trying to import setup data from a DEVELOPMENT environment to a TEST environment and encountered the following error while importing domain mapping using Business Intelligence Applications Configuration Manager (BIACM)

    oracle.jbo.DMLConstraintException: JBO-26048: Constraint "C_DOMAIN_MEMBER_MAP_FK2" is violated during post operation using SQL
  statement "INSERT INTO C_DOMAIN_MEMBER_MAP(DATASOURCE_NUM_ID,SRC_DOMAIN_MEMBER_CODE,TRG_DOMAIN_MEM_MEMBER_CODE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,SRC_DOMAIN
  _KEY,TRG_DOMAIN_KEY,DOMAIN_PLV_KEY,INACTIVE_FLAG) VALUES  (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)".

 

Changes

Original Data source number in Development environment (exporting Domain mappings from this enviroment) - 5000
Original Data source number in Test environment (importing Domain mappings to this enviroment) - 1000

You then changed the datasource number from 1000 to 5000 on the destination environment and tried importing.

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