Load transport throws error.

book

Article ID: 193955

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

Customer unloads 11.2 (Oracle) data and loads it into 12.3 (PostgreSQL). The following error appears:

 

U00003590 UCUDB - DB-Fehler: 'ERROR:  duplicate key value violates unique constraint "pk_table" DETAIL:  Key (table_name)=(ABLOB) already exists.', '', '', ''

U00003594 UCUDB-Ret: '6' Opcode: 'INSR' SQL-Stmnt: 'INSERT INTO UC_TABLE (TABLE_Name, TABLE_Name5, TABLE_Prefix, TABLE_Text, TABLE_Lfd, TABLE_UType, TABLE_Check, TABLE_AvgLen, TABLE_IlmFlag, TABLE_IlmKey, TABLE_LoadAtomic) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The 12.3 system was already created loading the UC_UPD.TXT, therefore the already exists message.

Create the database schema using the uc_ddl.sql and then load the transport case from the older (11.2) version.