OGG-02544 ORA-1: unique constraint % violated …..with INSERTALLRECORDS in Replicat (Doc ID 2356217.1)

Last updated on JANUARY 24, 2023

Applies to:

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 (constraint-name) 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 SCHEMA-NAME.TABLE-NAME to SCHEMA-NAME.TABLE-NAME OCI Error ORA-00001: unique constraint (constraint-name) violated
(status = 1), SQL <INSERT INTO "SCHEMA-NAME"."TABLE-NAME" ("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 SCHEMA-NAME.TABLE-NAME to SCHEMA-NAME.TABLE-NAME.

Cause

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