OGG for MS SQL Server Replict: OGG-00869 SQLState = 22005 SQLError = 0 SQLErrorHex = 00000000 SQLErrorText = [Microsoft][ODBC Driver 18 for SQL Server]Invalid character value for cast specification. (Doc ID 3041384.1)

Last updated on FEBRUARY 06, 2025

Applies to:

Symptoms

Replicat to MS SQL Server was encountering:

2024-07-11 15:59:25 WARNING OGG-00869 SQLState = 22005 SQLError = 0 SQLErrorHex = 00000000 SQLErrorText = [Microsoft][ODBC Driver 18 for SQL Server]Invalid character value for cast specification.

2024-07-11 15:59:25 WARNING OGG-01151 Error mapping from <schema>.<table> to <schema>.<table>.

Source Context :
SourceModule : [er.replicat.errors]
SourceID : [er/replicat/reperrors.cpp]
SourceMethod : [repError]
SourceLine : [1856]
ThreadBacktrace : [17] elements
: [/oracle_software/sqlgg/gg_ma_home/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/oracle_software/sqlgg/gg_ma_home/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/oracle_software/sqlgg/gg_ma_home/bin/../lib/libgglog.so(_MSG_QualTableName_QualTableName(CSourceContext*, int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::repError(short, int, char const*, extr_ptr_def*, ggs::gglib::gglcr::CommonLCR const*, std_rec_hdr_def*, char*, ObjectMetadata*, bool))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::perform_reperror_after_retry(ggs::gglib::gglcr::CommonLCR const*, std_rec_hdr_def&, char*, extr_ptr_def*, short&, bool*))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::replicate_io(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*, bool, int&, RepCsn&, bool*))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::processRecord(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*&, extr_ptr_def*&, bool&, int&, bool, RepCsn&))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::er::ReplicatContext::run())]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat()]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat(main)]
: [/lib64/libc.so.6()]
: [/lib64/libc.so.6(__libc_start_main)]
: [/oracle_software/sqlgg/gg_ma_home/bin/replicat()]

2024-07-11 15:59:25 ERROR OGG-01296 Error mapping from <schema>.<table> to <schema>.<table>.

Changes

 N/A

Cause

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