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.

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

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

	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

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