New Initial Load Extract Is Abending With ORA-00942: table or view does not exist (Doc ID 2686521.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Newly created initial load Extract is abending with below error.

Source Context :
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
ThreadBacktrace : [19] elements
: [/home/oracle/gg11/libgglog.so(CMessageContext::AddThreadContext())]
: [/home/oracle/gg11/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/home/oracle/gg11/libgglog.so(_MSG_Int32_String_String(CSourceContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition))]
: [./extract(ggs::gglib::ggocicpp::OCIErrorHandler::dpiErr(dpi::Exception&) const)]
: [./extract(ggs::gglib::ggocicpp::OCIStatement::execStatement(int))]
: [./extract(ggs::gglib::ggocicpp::ORAConnection::execStmt(ggs::gglib::ggunicode::UString const*))]
: [./extract(DBOCI_get_tab_property(ggs::gglib::ggocicpp::ORAConnection&, int, unsigned long*, unsigned long*, int*, unsigned int*))]
: [./extract(gl_get_odbc_table_def(ggs::gglib::ggdbconnection::DBConnection*, ObjectMetadata*, short, char*, unsigned short))]
: [./extract(ggs::er::ExtractContext::getSourceObjectMetadata(ObjectMetadata*, ObjectMetadataRequest const&))]
: [./extract(MAPPING_add_source_file(ObjectMetadataRequest const&, unsigned int*, unsigned int, recopts_t*, ggs::gglib::ggunicode::UString const&, int*, int, wc_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>&, unsigned int, unsigned int, ggs::gglib::ggmetadata::TableManager&, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool, unsigned int))]
: [./extract(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, ObjectMetadataRequest const&, unsigned int, unsigned int, ggs::gglib::ggmetadata::MetadataContext&, ggs::gglib::ggmetadata::TableManager&, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool, bool, bool))]
: [./extract(wc_def::resolve_nwc_entry(bool, ggs::gglib::ggmetadata::MetadataContext&, ggs::gglib::ggmetadata::TableManager&))]
: [./extract()]
: [./extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [./extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [./extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [./extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [./extract()]

2020-04-16 23:55:08 ERROR OGG-00664 OCI Error ORA (status = 942-ORA-00942: table or view does not exist
).

2020-04-16 23:55:08 ERROR OGG-01668 PROCESS ABENDING.

Cause

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