My Oracle Support Banner

OBIA 11g:FA13-1810: FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO fails with Unique Index error (Doc ID 2506447.1)

Last updated on AUGUST 18, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

FA ETL Fails with following errors:
ODI-1226: Step FTS_FUSION_FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO fails after 1 attempt(s).

ODI-1240: Flow FTS_FUSION_FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO fails while performing a Integration operation. This flow loads target table
FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO.

ODI-1227: Task FTS_FUSION_FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO (Integration) fails on the source ORACLE connection FA_SDS_FUSION_11.

Caused By: java.sql.SQLException: ORA-01653: unable to extend table <SDS_FUSION_11_SCHEMA>.I$_118500_15 by 8192 in tablespace <SDS_DATA_TABLESPACE>

CREATE UNIQUE INDEX <SDS_FUSION_11_SCHEMA>.FSC_PR_STNDRDDSTRBBTNPV92047 ON <SDS_FUSION_11_SCHEMA>.FSC_PR_STNDRDDSTRBBTNPV92047("PODISTRIBUTIONID") NOLOGGING
(<type 'java.sql.SQLException'> - java.sql.SQLException: 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!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.