Replicat Start Error OGG-00446 Failed to Insert Entry in Checkpoint Table Using Goldengate for Sybase 12.1.2.0.2
(Doc ID 2055056.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle GoldenGate - Version 12.1.2.0.2 and laterInformation in this document applies to any platform.
Symptoms
The replicat for GoldenGate for Sybase 12.1.2.0.2 fails to start and gives the error -
Database Language and Character Set:
CLIENT CHARACTER SET = "utf8"
SERVER CHARACTER SET = "iso_1"
LOCALE INFORMATION = "us_english"
DATABASE COLLATION = "casesensitive"
Server message (Data Context):
number(233) severity(16) state(2) line(1)
The column log_bsn in table <user>."<checkpoint_table>" does not allow null values
Source Context :
SourceModule : [er.common]
SourceID : [<dir>/src/app/er/common.cpp]
SourceFunction : [extract_start_point]
SourceLine : [2496]
ThreadBacktrace : [11] elements
: [<gg_dir>/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7ffff7d4c3d6]]
: [<gg_dir>/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x28f) [0x7ffff7d4453f]]
: [<gg_dir>/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7ffff7d0bdf2]]
: [<gg_dir>/replicat(extract_start_point(time_elt_def*, time_elt_def*)+0x174) [0x53c654]]
: [<gg_dir>/replicat(replicat_main(int, char**)+0x28f) [0x5bd88f]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x70b41f]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x70a2ca]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x70b7c8]]
: [<gg_dir>/replicat(main+0x4a) [0x5ba8ea]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3d5ac1ed5d]]
: [<gg_dir>/replicat() [0x4b2ce9]]
2015-08-14 12:08:49 ERROR OGG-00446 failed to insert entry in checkpoint table '<user>."<checkpoint_table>"' (sql statement: 'INSERT INTO <user>."<checkpoint_table>" (group_name, group_key, current_dir, create_ts, last_update_ts, seqno, rba, audit_ts, version) VALUES ('<group>', <key>, '<current_dir>', '2015-08-13 23:36:05.635', GETDATE(), 0, 0, NULL, 1)')
Failed to process SQL statement - error 233.
2015-08-14 12:08:49 ERROR OGG-01668 PROCESS ABENDING.
CLIENT CHARACTER SET = "utf8"
SERVER CHARACTER SET = "iso_1"
LOCALE INFORMATION = "us_english"
DATABASE COLLATION = "casesensitive"
Server message (Data Context):
number(233) severity(16) state(2) line(1)
The column log_bsn in table <user>."<checkpoint_table>" does not allow null values
Source Context :
SourceModule : [er.common]
SourceID : [<dir>/src/app/er/common.cpp]
SourceFunction : [extract_start_point]
SourceLine : [2496]
ThreadBacktrace : [11] elements
: [<gg_dir>/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7ffff7d4c3d6]]
: [<gg_dir>/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x28f) [0x7ffff7d4453f]]
: [<gg_dir>/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7ffff7d0bdf2]]
: [<gg_dir>/replicat(extract_start_point(time_elt_def*, time_elt_def*)+0x174) [0x53c654]]
: [<gg_dir>/replicat(replicat_main(int, char**)+0x28f) [0x5bd88f]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x70b41f]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x70a2ca]]
: [<gg_dir>/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x70b7c8]]
: [<gg_dir>/replicat(main+0x4a) [0x5ba8ea]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3d5ac1ed5d]]
: [<gg_dir>/replicat() [0x4b2ce9]]
2015-08-14 12:08:49 ERROR OGG-00446 failed to insert entry in checkpoint table '<user>."<checkpoint_table>"' (sql statement: 'INSERT INTO <user>."<checkpoint_table>" (group_name, group_key, current_dir, create_ts, last_update_ts, seqno, rba, audit_ts, version) VALUES ('<group>', <key>, '<current_dir>', '2015-08-13 23:36:05.635', GETDATE(), 0, 0, NULL, 1)')
Failed to process SQL statement - error 233.
2015-08-14 12:08:49 ERROR OGG-01668 PROCESS ABENDING.
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 |
| Cause |
| Solution |
| References |