Replicat Start Error OGG-00446 Failed to Insert Entry in Checkpoint Table Using Goldengate for Sybase

(Doc ID 2055056.1)

Last updated on JANUARY 09, 2017

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 dbo."GGS_CHECKPOINT" does not allow null values

Source Context :
 SourceModule            : [er.common]
 SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150319/oggcore/OpenSys/src/app/er/common.cpp]
 SourceFunction          : [extract_start_point]
 SourceLine              : [2496]
 ThreadBacktrace         : [11] elements
                         : [/opt/distadm/ggate_12c/ [0x7ffff7d4c3d6]]
                         : [/opt/distadm/ggate_12c/*, unsigned int, ...)+0x28f) [0x7ffff7d4453f]]
                         : [/opt/distadm/ggate_12c/*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7ffff7d0bdf2]]
                         : [/opt/distadm/ggate_12c/replicat(extract_start_point(time_elt_def*, time_elt_def*)+0x174) [0x53c654]]
                         : [/opt/distadm/ggate_12c/replicat(replicat_main(int, char**)+0x28f) [0x5bd88f]]
                         : [/opt/distadm/ggate_12c/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x70b41f]]
                         : [/opt/distadm/ggate_12c/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x70a2ca]]
                         : [/opt/distadm/ggate_12c/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x70b7c8]]
                         : [/opt/distadm/ggate_12c/replicat(main+0x4a) [0x5ba8ea]]
                         : [/lib64/ [0x3d5ac1ed5d]]
                         : [/opt/distadm/ggate_12c/replicat() [0x4b2ce9]]

2015-08-14 12:08:49  ERROR   OGG-00446  failed to insert entry in checkpoint table 'dbo."GGS_CHECKPOINT"' (sql statement: 'INSERT INTO dbo."GGS_CHECKPOINT" (group_name, group_key, current_dir, create_ts, last_update_ts, seqno, rba, audi
t_ts, version) VALUES ('GGAPX', 990830825, '/opt/dist/ggate_12c', '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.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms