My Oracle Support Banner

Replicat Process Is Abended Due to OGG-01920 When Enabling BATCHSQL (Doc ID 2658529.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Replicat process is abended due to OGG-01920 when enabling BATCHSQL.
Error is recorded in ggserr.log as follows.

2020-04-13T08:42:03.519+0900 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: REPLICAT <REPLICAT> started.
2020-04-13T08:42:03.520+0900 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: Opened trail file <GG_HOME>/dirdat/rt000000003 at 2020-04-13 08:42:03.520719.
2020-04-13T08:42:03.520+0900 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: Setting session time zone to source database time zone '+09:00'.
2020-04-13T08:42:03.521+0900 INFO OGG-06505 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: MAP resolved (entry <SCHEMA>.<TABLE>): MAP "<SCHEMA>"."<TABLE>", TARGET <SCHEMA>.<TABLE>, COMPARECOLS (ON UPDATE ALL, ON DELETE ALL), RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE)), RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)).
2020-04-13T08:42:05.128+0900 INFO OGG-02756 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: The definition for table <SCHEMA>.<TABLE> is obtained from the trail file.
2020-04-13T08:42:05.128+0900 INFO OGG-06511 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: Using following columns in default map by name: <COL1>, <COL2>, <COL3>, <COL4>, <COL5>, <COL6>, ....
2020-04-13T08:42:06.280+0900 INFO OGG-06510 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: Using the following key columns for target table <SCHEMA>.<TABLE>: <COL1>, <COL2>, <COL3>, <COL4>.
2020-04-13T08:42:06.806+0900 ERROR OGG-01920 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: Missing COMPARECOLS column "<COL1>" in before image, while mapping to target table ""<SCHEMA>"."<TABLE>"". Add the column to GETBEFORECOLS.
2020-04-13T08:42:06.814+0900 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, <replicat>.prm: PROCESS ABENDING.

And following stack appears in report file of replicat process.

SourceModule       : [er.cdr]
SourceID             : [/scratch/aime/adestore/views/aime_adc4150324/oggcore/OpenSys/src/app/er/cdr.cpp]
SourceMethod      : [ggIsCDRPredCol]
SourceLine          : [2247]
ThreadBacktrace  : [21] elements
                         : [<GG_HOME>/libgglog.so(CMessageContext::AddThreadContext())]
                         : [<GG_HOME>/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                         : [<GG_HOME>/libgglog.so(_MSG_String_String(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageDisposition))]
                         : [<GG_HOME>/replicat(ggIsCDRPredCol(short, ObjectMetadata*, extr_ptr_def*, short, short*, bool*, bool*))]
                         : [<GG_HOME>/replicat()]
                         : [<GG_HOME>/replicat(DB_prepare_cached_stmt(void*, sql_stmt_params_t*, char*))]
                         : [<GG_HOME>/replicat(BATCHSQL_get_batch_stmt(void*, char*, BATCHSQL_db_params_t*))]
                         : [<GG_HOME>/replicat(DBBATCHSQL_exec_batch(BATCHSQL_ctx_t*, BATCHSQL_db_params_t*))]
                         : [<GG_HOME>/replicat()]
                         : [<GG_HOME>/replicat(Commit_and_Checkpoint(short, bool&, RepCsn&))]
                         : [<GG_HOME>/replicat(ClassicWorker::CommitAndCheckpoint(short))]
                         : [<GG_HOME>/replicat(REP_end_transaction(short))]
                         : [<GG_HOME>/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
                         : [<GG_HOME>/replicat(ggs::er::ReplicatContext::run())]
                         : [<GG_HOME>/replicat()]
                         : [<GG_HOME>/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                         : [<GG_HOME>/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                         : [<GG_HOME>/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                         : [<GG_HOME>/replicat(main)]
                         : [/lib64/libc.so.6(__libc_start_main)]
                         : [<GG_HOME>/replicat()]

Changes

Both BATCHSQL and CDR are enabled.

Cause

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
Changes
Cause
Solution
References


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