My Oracle Support Banner

Replicat Start Error OGG-00446 Failed to Insert Entry in Checkpoint Table Using Goldengate for Sybase (Doc ID 2055056.1)

Last updated on JANUARY 08, 2024

Applies to:

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


 The replicat for GoldenGate for Sybase 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>/ [0x7ffff7d4c3d6]]
                         : [<gg_dir>/*, unsigned int, ...)+0x28f) [0x7ffff7d4453f]]
                         : [<gg_dir>/*, 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/ [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.




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

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