My Oracle Support Banner

OBIA 7.9.6.4: Error while CREATE INDEX:W_SALES_BACKLOG_LINE_F:W_SLS_BCK_LN_F_U1 (Doc ID 2385460.1)

Last updated on JUNE 01, 2018

Applies to:

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

Symptoms

ERROR
-----------------------

Execution plan failed with error. Task_Group_Load_BacklogFacts failed.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_SALES_BACKLOG_LINE_F:W_SLS_BCK_LN_F_U1
  MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
  W_SLS_BCK_LN_F_U1
  ON
  W_SALES_BACKLOG_LINE_F
  (
  INTEGRATION_ID ASC
  ,DATASOURCE_NUM_ID ASC
  )
  NOLOGGING
  with error DW_PROD:CREATE UNIQUE INDEX
  W_SLS_BCK_LN_F_U1
  ON
  W_SALES_BACKLOG_LINE_F
  (
  INTEGRATION_ID ASC
  ,DATASOURCE_NUM_ID ASC
  )
  NOLOGGING
  ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.