Unique Contraint Failure For The Index (W_EXCH_RATE_GS_U1 ) Using Maximo
Last updated on SEPTEMBER 27, 2016
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124 and later
Information in this document applies to any platform.
Implemented OBIA 126.96.36.199 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 188.8.131.52 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
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
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
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:516)
Temporary Resolution applied to go through:
Hardcoded the Org_id = 'KUW' and last updated date is taken as maximum records
eBS based taskes.
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