OBIA 7964: Informatica Workflow and ETL Failure - Unique Constraint Violation Errors appear in Multiple Mappings after Informatica Repository Migration (Doc ID 1598499.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

The following Mappings fail with Unique Constraint Violation error messages during a BI Apps 7.9.6.4 Incremental ETL and after an Informatica Repository migration:

1. SIL_GLAccountDimension
2. SIL_GeographyDimension
3. SIL_PositionDimension

An example error message received:

2013-11-05 17:45:35 : ERROR : (27412 | WRITER_1_*_1) : (IS | BIA_IS) : node01_xobtobie : WRT_8229 : Database errors occurred:
ORA-00001: unique constraint (DATA_BIAPPS.W_GEO_D_P1) violated

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO W_GEO_D(ETL_PROC_WID,ROW_WID,CITY,CONTINENT,COUNTRY,COUNTY,REGION,STATE_PROV,ZIPCODE,X_CUSTOM,GEO_COUNTRY_WID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_GEO_D(ETL_PROC_WID,ROW_WID,CITY,CONTINENT,COUNTRY,COUNTY,REGION,STATE_PROV,ZIPCODE,X_CUSTOM,GEO_COUNTRY_WID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2013-11-05 17:45:35 : ERROR : (27412 | WRITER_1_*_1) : (IS | BIA_IS) : node01_xobtobie : WRT_8425 : ERROR: Writer execution failed.
2013-11-05 17:45:35 : ERROR : (27412 | WRITER_1_*_1) : (IS | BIA_IS) : node01_xobtobie : WRT_8114 :
Row # [1] in bad file

2013-11-05 17:45:35 : INFO : (27412 | WRITER_1_*_1) : (IS | BIA_IS) : node01_xobtobie : CMN_1053 : : Rowdata: ( RowType=0(insert) Src Rowid=9295 Targ Rowid=9295
 ETL_PROC_WID (ETL_PROC_WID:Double:): "23060362.00000000"
 ROW_WID (ROW_WID:Double:): "7116294.000000000"
 CITY (CITY:UniChar.120:): "xxxxx"
 CONTINENT (CONTINENT:UniChar.120:): "Unspecified"
 COUNTRY (COUNTRY:UniChar.120:): "US"
 COUNTY (COUNTY:UniChar.120:): "Unspecified"
 REGION (REGION:UniChar.30:): "0"
 STATE_PROV (STATE_PROV:UniChar.120:): "AZ"
 ZIPCODE (ZIPCODE:UniChar.120:): "99999-1832"
 X_CUSTOM (X_CUSTOM:UniChar.10:): "0"
 GEO_COUNTRY_WID (GEO_COUNTRY_WID:Double:): "28029.00000000000"

)

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