My Oracle Support Banner

H2T Execution with SQOOP mode and Load Type Insert Fails (Doc ID 2858961.1)

Last updated on APRIL 03, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7.5 version, Logical Data Model

H2T Load Type

Define a H2T with SQOOP mode and Load Type "Insert".

Below error can be seen in that task execution log:

java.sql.SQLIntegrityConstraintViolationException: ORA-1: unique constraint (OFSAAATM.PK_1723) violated 

Changes

 Define a new H2T task in the environment with SQOOP mode and Load type "Insert"

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.