Hi all,
In the process of setting up extract to send to MSSQL Replicat process, but running into an annoyingly simple issue that I cant resolve.
Things to note:
- TRANDATA has been generated and is present for all tables in schema
- Some tables ins schema are excluded in defgen using TABLEEXCLUDE
My defgen params file:
==================================================================================================================================================================
DEFSFILE /u01/app/oracle/product/ogg_src/dirdef/1pmoracle.def, PURGE
USERID <USER REDACTED> PASSWORD <PASS REDACTED>
TABLE SCHEMA1.*;
TABLEEXCLUDE SCHEMA1.APEX$_WS_HISTORY;
TABLEEXCLUDE SCHEMA1.APEX$_WS_WEBPG_SECTION_HISTORY;
TABLEEXCLUDE SCHEMA1.CAP_DERIVATIVE_SEARCH;
TABLEEXCLUDE SCHEMA1.CAP_FUEL_DELIVERY;
TABLEEXCLUDE SCHEMA1.CAP_METRIC;
TABLEEXCLUDE SCHEMA1.DEFAULT_LOGO;
<... snipped as there are a lot of excludes ...>
==================================================================================================================================================================
Error when running ./defgen paramfile dirprm/defgen.prm:
==================================================================================================================================================================
Retrieving definition for SCHEMA1.DEFAULT_LOGO.
Source Context :
SourceModule : [ggdb.ora.util]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/gglib/ggdbora/orautil.c]
SourceFunction : [ORAUTIL_get_key_columns]
SourceLine : [1704]
ThreadBacktrace : [14] elements
: [/u01/app/oracle/product/ogg_src/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f4a852f47ee]]
: [/u01/app/oracle/product/ogg_src/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x321) [0x7f4a852efb11]]
: [/u01/app/oracle/product/ogg_src/libgglog.so(_MSG_ERR_DB_GENERIC_FAILURE(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7f4a852d6c81]]
: [./defgen(ORAUTIL_get_key_columns(file_def*, int, DDLPropertyBuffer*, short, char*)+0x362) [0x503a72]]
: [./defgen(get_table(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ULibCharSet)+0xed) [0x453c8d]]
: [./defgen(get_tables(ggs::gglib::ggunicode::UString&, ULibCharSet, bool)+0xf56) [0x455f46]]
: [./defgen(get_infile_params()+0x16c) [0x456dfc]]
: [./defgen() [0x457477]]
: [./defgen(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x4b1eff]]
: [./defgen(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x4b0daa]]
: [./defgen(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x4b22a8]]
: [./defgen(main+0x4a) [0x451bfa]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f4a7d213c05]]
: [./defgen() [0x451ad9]]
2018-07-16 13:01:31 ERROR OGG-00868 No viable key columns found for table SCHEMA1.DEFAULT_LOGO.
2018-07-16 13:01:31 ERROR OGG-01668 PROCESS ABENDING.
==================================================================================================================================================================
So I cannot progress past this point. I have verified that SCHEMA1.DEFAULT_LOGO has TRANDATA present, it does. It is a BLOB data type, I don't know if this affects anything? Should I be handling this differently? My main hang up is that I ahve added this into TABLEEXCLUDES and yet running defgen its not excluded? I don't need that table, nor its BLOB data, so why is it being included in my definitions when I am excluding it?
Some info:
OGG Version - 12.1.2.0.0
Oracle Version - 12c (12.1.0.2)
Host OS - Oracle Linux 7 x64
Thanks, Dave