Unique Contraint Failure For The Index (W_EXCH_RATE_GS_U1 ) Using Maximo (Doc ID 1924204.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Symptoms

Background
------------------
Implemented OBIA 7.9.6.4 for five Analytic (Finance, HRMS, Supply Chain, Order Management and Procurement and EAM).
For these four Finance, HRMS, Supply Chain, Order Management and Procurement modules the Source is EBS 11.5.10.2 and for EAM source is Maximo 75.

its DAC error not informatica.
Don't have EAM module in EBS and never implemented EAM in past without Maximo.
In DEV ENV implementing only EAM with maximo, once development will get over after fixing all the errors, will merge the EAM with other analytics.

using Full load

Problem
---------------
While running Full Load getting error -
Unique constraint failure for the index (W_EXCH_RATE_GS_U1 )
Task Name: SDE_MAXIMO_ExchangeRateGeneral
TARGET TABLE : W_EXCH_RATE_GS

In Maximo Exchange Rates are maintained by organization but in datawarehouse is not by organization

DAC_SDE_MAXIMO_ExchangeRateGeneral_MXEAM_DataWarehouse.log:
2014-07-31 15:12:38.652 CREATE INDEX:W_EXCH_RATE_GS:W_EXCH_RATE_GS_U1 has started.
ANOMALY INFO::: Error while executing : CREATE INDEX:W_EXCH_RATE_GS:W_EXCH_RATE_GS_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_EXCH_RATE_GS_U1
..
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:516)

Working
------------
Temporary Resolution applied to go through:
Hardcoded the Org_id = 'KUW' and last updated date is taken as maximum records

eBS based taskes.

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