My Oracle Support Banner

To Do(CD_TD) Dimension Failed While Loading Data (Doc ID 2653788.1)

Last updated on MARCH 30, 2020

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Goal

On : 2.7.0.1.0 version, Install / Upgrade

To Do(CD_TD) Dimension failed while loading data

Steps to replicate:
1. Enable the entity.
2. let the job run.
SELECT * FROM B1_JOBS_VW WHERE ENTITY_NAME ='CD_TD';
Select * from dwstage.stg_15654;
Select SRC_TD_ENTRY_ID,count(1) from dwstage.stg_15654 group by SRC_TD_ENTRY_ID having count(1)>1;

3. observed that job is failing with unique constraint error.

Solution

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
Goal
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.