OGG-02544 ORA-1: unique constraint % violated …..with INSERTALLRECORDS in Replicat

(Doc ID 2356217.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.
For this case customer was trying to create an historical table on target using INSERTALLRECORDS but was working for one table and not for the other.

Symptoms

Replicat abends and the report shows:

 

2018-02-01 17:04:13 WARNING OGG-02544 Unhandled error (ORA-00001: unique constraint (.) violated
ORA-00001: unique constraint (AROYTARGET.PKEY) violated) while processing the record at SEQNO 4, RBA 2437 in Integrated mode. REPLICAT will retry in Direct mode.

2018-02-01 17:04:13 WARNING OGG-01154 SQL error 1 mapping AROYSOURCE.TEST to AROYTARGET.TESTALL OCI Error ORA-00001: unique constraint (AROYTARGET.PKEY) violated
(status = 1), SQL <INSERT INTO "AROYTARGET"."TESTALL" ("ID","TEXT","OPERATION$","BFR_AFT_IND") VALUES (:a0,:a1,:a2,:a3)>.

Source Context :

SourceModule : [er.errors]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [935]
ThreadBacktrace : [15] elements
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x2b1658af1f1b]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x2b1658aec0a4]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition)+0x50) [0x2b1658ae580f]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, std_rec_hdr_def*, char*, file_def*, bool)+0x17ab) [0x5a471c]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(replicate_io(ggs::gglib::ggdatasource::DataSource*, file_def*, ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*, int*, int)+0x3825) [0x628ae5]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(process_record(ggs::gglib::ggdatasource::DataSource*, file_def*&, ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, short&, extr_ptr_def*&, extr_ptr_def*&, int&, int&, int&, bool)+0x2f1) [0x62ceb1]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(ggs::er::ReplicatContext::processReplicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0x10ee) [0x5e48de]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(ggs::er::ReplicatContext::run(ggs::Heartbeat::MapGeneratorParams&)+0x29) [0x5d8b09]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat [0x621b1b]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d9d50]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6dacdd]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6dadc1]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat(main+0x3b) [0x624a6b]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x389bc1d9f4]]
: [/bugmnt10/am/celclnx14/ggs_12.2.0.1/replicat [0x55b0a9]]

2018-02-01 17:04:13 ERROR OGG-01296 Error mapping from AROYSOURCE.TEST to AROYTARGET.TESTALL.

 

 

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