OGG Replicat abends with "ERROR OGG-00868 Executing dynamic sql via CS_EXECUTE for query_id 'dyn0000' on table 'dbo.TEST' (Doc ID 2031226.1)

Last updated on AUGUST 25, 2016

Applies to:

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

Symptoms

OGG Replicat on Sybase abends with the following error -

Client Library (Data Context) error:
severity(0) number(6) origin(3) layer(5)
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
Client Library (Data Context) error:
severity(0) number(50) origin(1) layer(1)
ct_dynamic(): user api layer: external error: The connection has been marked dead.

Source Context :
SourceModule : [ggdb.syb.util]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/gglib/ggdbsyb/sybutil.c]
SourceFunction : [SYBUTIL_check_err]
SourceLine : [777]
ThreadBacktrace : [16] elements
: [/local/sybase/gghome/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7fea44b64e36]]
: [/local/sybase/gghome/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x28f) [0x7fea44b5cf8f]]
: [/local/sybase/gghome/libgglog.so(_MSG_ERR_DB_GENERIC_FAILURE(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7fea44b1ff42]]
: [/local/sybase/gghome/replicat(SYBUTIL_check_err(sybase_context_t*, int, char const*, ...)+0x131) [0x741b61]]
: [/local/sybase/gghome/replicat() [0x734866]]
: [/local/sybase/gghome/replicat(execute_statement(char*, file_def*, short, short*, short, extr_ptr_def*, int*, char*, unsigned long, void*)+0x282) [0x735ed2]]
: [/local/sybase/gghome/replicat(perform_sql_statements(file_def*, short, char*, short*, short, extr_ptr_def*)+0x3e0) [0x5c0000]]
: [/local/sybase/gghome/replicat(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0xbe2) [0x57a1e2]]
: [/local/sybase/gghome/replicat(process_extract_loop()+0x5576) [0x575b86]]
: [/local/sybase/gghome/replicat(replicat_main(int, char**)+0x360) [0x5bb9d0]]
: [/local/sybase/gghome/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x705f3f]]
: [/local/sybase/gghome/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x704dea]]
: [/local/sybase/gghome/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x7062e8]]
: [/local/sybase/gghome/replicat(main+0x4a) [0x5ba6ca]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x341d81ed5d]]
: [/local/sybase/gghome/replicat() [0x4b1969]]



2015-05-26 23:27:26 ERROR OGG-00868 Executing dynamic sql via CS_EXECUTE for query_id 'dyn0000' on table 'dbo.TEST'.

Cause

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