REP Adapter To Netezza Abend Error Mapping From CAKULA.ARC_ADDRESS To ADMIN.ARC_ADDRESS ERROR: Attempt to UPDATE a distribution column (Doc ID 2255332.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Big Data Adapter using JDBC to Netezza:

***********************************************************************
Oracle GoldenGate Delivery
Version 12.2.0.1.160823 OGGCORE_OGGADP.12.2.0.1.0_PLATFORMS_161019.1437
Linux, x64, 64bit (optimized), Generic on Oct 19 2016 16:26:25

***********************************************************************
Oracle GoldenGate Java Adapter, 12.3.0.1.0.012
Copyright (c) 2007, 2016. Oracle and/or its affiliates. All rights reserved
Built with Java 1.8.0_92 (class version: 52.0)
***********************************************************************

is abending with:

2017-03-31 18:00:32 INFO OGG-06505 MAP resolved (entry CAKULA.ARC_ADDRESS): MAP "CAKULA"."ARC_ADDRESS", TARGET ADMIN.ARC_ADDRESS_TEST.
2017-03-31 18:00:32 INFO OGG-02756 The definition for table CAKULA.ARC_ADDRESS is obtained from the trail file.
2017-03-31 18:00:32 INFO OGG-06511 Using following columns in default map by name: ARC_ADDR_SEQ, ADDRESS_1, ADDRESS_2, CITY, STATE, ZIP, COUNTRY, ADDRESS_TYPE, PART_REC_SEQ, DOR, DLU, UPDATED_BY, CREATED_BY, EMAIL, TELEPHONE.
2017-03-31 18:00:32 INFO OGG-06510 Using the following key columns for target table ADMIN.ARC_ADDRESS_TEST: ARC_ADDR_SEQ, ADDRESS_1, ADDRESS_2, CITY, STATE, ZIP, COUNTRY, ADDRESS_TYPE, PART_REC_SEQ, DOR, DLU, UPDATED_BY, CREATED_BY, EMAIL, TELEPHONE.
2017-03-31 18:00:32 INFO OGG-03010 Performing implicit conversion of column data from character set we8mswin1252 to UTF-8.

2017-03-31 18:00:32 WARNING OGG-01004 Aborted grouped transaction on 'ADMIN.ARC_ADDRESS_TEST', Database error 1100 ().
2017-03-31 18:00:32 WARNING OGG-01003 Repositioning to rba 2959 in seqno 6.
2017-03-31 18:00:32 WARNING OGG-01154 SQL error 1100 mapping CAKULA.ARC_ADDRESS to ADMIN.ARC_ADDRESS_TEST.
2017-03-31 18:00:32 ERROR OGG-01296 Error mapping from CAKULA.ARC_ADDRESS to ADMIN.ARC_ADDRESS_TEST.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms