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 laterInformation 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.
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()]
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 |