IE HANGS AFTER DML WITH UNSUPPORTED DATATYPE - TIMESTAMP WITH TIME ZONE

(Doc ID 2346753.1)

Last updated on JANUARY 09, 2018

Applies to:

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

Symptoms

IE hang after getting an unsupported datatype "TIMESTAMP WITH TIME ZONE" in
an object.

Though the IE gives the error stack, it does not abend and lingering in OS.

Test Info
-----------

Env : 2-Node OEL6.UEK.X64 servers
Oracle DB : RDBMS_MAIN_LINUX.X64_131111
OGG : OGGCORE_MAIN_PLATFORMS_131111.1404
Setup : 2-Node RAC SRC-DB (custdb) and 2-Node RAC DEST (WEBDB),
1-Way Replication, all Oracle Instances on Linux.64
Test : OGG CROSS VERSION

Error Stack
-----------

Source Context :
SourceModule : [ggdb.ora.udt]
SourceID :
[/scratch/aime1/adestore/views/aime1_adc4150349/oggcore/OpenSys/src/g
glib/ggdbora/ociudt.c]
SourceFunction : [get_param_type_info]
SourceLine : [952]
ThreadBacktrace : [29] elements
:
[/scratch/dhrpatha/ggsrc/libgglog.so(CMessageContext::AddThreadContex
t()+0x26) [0x7fa68ae8af16]]
:
[/scratch/dhrpatha/ggsrc/libgglog.so(CMessageFactory::CreateMessage(C
SourceContext*, unsigned int, ...)+0x2af) [0x7fa68ae8303f]]
:
[/scratch/dhrpatha/ggsrc/libgglog.so(_MSG_ERR_ORACLE_UNSUPPORTED_ATTR
_TYPES(CSourceContext*, char const*, int, char const*,
CMessageFactory::MessageDisposition)+0x57)
[0x7fa68ae37887]]
: [/scratch/dhrpatha/ggsrc/extract() [0x7dac9e]]
:
[/scratch/dhrpatha/ggsrc/extract(OCIUDT_get_udt_def(ggs::gglib::ggapp
::CQualDBObjName<(DBObjType)1> const&,
ggs::gglib::ggapp::CDBObjName<(DBObjType)13> const&, int,
DDLPropertyBuffer*, short)+0x38a) [0x7dbd0a]]
:
[/scratch/dhrpatha/ggsrc/extract(gl_get_col_specs(ggs::gglib::ggapp::
CQualDBObjName<(DBObjType)1> const&, col_def*,
ggs::gglib::ggapp::CDBObjName<(DBObjType)13> const
&, short, char const*, long, long, short, short, short*, int*, int*, int,
DDLPropertyBuffer*, sho
rt, char*)+0xbcd) [0x7a8d6d]]
: [/scratch/dhrpatha/ggsrc/extract() [0x7b442b]]
:
[/scratch/dhrpatha/ggsrc/extract(DBUTIL_ddl_init_query(file_def*, sho
rt, char*, DDLPropertyBuffer*)+0x16) [0x7b94f6]]
:
[/scratch/dhrpatha/ggsrc/extract(DBUTIL_ddl_metadata_change(file_def*
, ggs::gglib::ggapp::CDBObjName<(DBObjType)7>&,
ggs::gglib::ggapp::CDBObjName<(DBObjType)1>&, uns
igned int&, ggs::gglib::ggunicode::UString const&,
ggs::gglib::ggunicode::UString const&, DDLProp
ertyBuffer*)+0x275) [0x7b98b5]]
:
[/scratch/dhrpatha/ggsrc/extract(DDLEXT_getCurrentDDL(file_def*, ggs:
:gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, extractDDL_t*,
int)+0x918) [0x63e758]]
:
[/scratch/dhrpatha/ggsrc/extract(get_extract_source_def(file_def*, gg
s::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&)+0x357) [0x5bba77]]
:
[/scratch/dhrpatha/ggsrc/extract(MAPPING_add_source_file(ggs::gglib::
ggapp::CQualDBObjName<(DBObjType)1> const&, unsigned int*, unsigned int,
recopts_t*, ggs::gglib::
ggunicode::UString const&, int*, int, wc_def*,
ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>&,
int, unsigned int, unsigned int)+0x18cc) [0x598d0c]]
:
[/scratch/dhrpatha/ggsrc/extract(get_map_entry(ggs::gglib::ggunicode:
:UString const&, int, wc_def*, int, unsigned int, unsigned int)+0x269c)
[0x59cc3c]]
:
[/scratch/dhrpatha/ggsrc/extract(wc_def::resolve_wc_entry(ggs::gglib:
:ggapp::CQualDBObjName<(DBObjType)1> const&, int, unsigned int*,
ggs::gglib::ggapp::CQualDBObjNam
e<(DBObjType)1>*, int)+0x278) [0x694768]]
:
[/scratch/dhrpatha/ggsrc/extract(WILDCARD_check_table(ggs::gglib::gga
pp::CQualDBObjName<(DBObjType)1> const*, int, unsigned int*, int, unsigned
int, ggs::gglib::ggapp
::CQualDBObjName<(DBObjType)1>*, int)+0x459) [0x6954a9]]

 

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