IR fails with Database Error ORA -1403, even before resolving the tables (Doc ID 2184320.1)

Last updated on JANUARY 24, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

IR fails with ORA 1403 error even before resolving the mapped tables.


Oracle GoldenGate Delivery for Oracle
Version 12.1.2.1.11 21831216 23267559_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 8 2016 17:10:04
..
REPLICAT repxxxx
USERIDALIAS ogg
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/repxxxx.dsc, APPEND
IGNOREDELETES
--DBOPTIONS integratedparams (TRACE_LEVEL 15999)
MAP Fxxx.CSxxxxx, TARGET Pxxxx.CSxxxx;
..
Source Context :
SourceModule : [iroci]
SourceID :
[/scratch/mmar/view_storage/mmar_23712847/oggcore/OpenSys/src/gglib/ggdbora/ir
oci.cpp]
SourceFunction : [IROCI_attach]
SourceLine : [642]
ThreadBacktrace : [12] elements
:
[/ogg_falcn1/12121/falrepp/libgglog.so(CMessageContext::AddThreadContext()+0x1
e) [0x7effb186e31e]]
:
[/ogg_falcn1/12121/falrepp/libgglog.so(CMessageFactory::CreateMessage(CSourceC
ontext*, unsigned int, ...)+0x340) [0x7effb1869030]]
:
[/ogg_falcn1/12121/falrepp/libgglog.so(_MSG_ERR_DB_SQL_ERROR(CSourceContext*,
int, char const*, CMessageFactory::MessageDisposition)+0x3b)
[0x7effb184f855]]
:
[/ogg_falcn1/12121/falrepp/replicat(IROCI_attach(OCISESS_context_def*)+0x2ab)
[0x715f81]]
:
[/ogg_falcn1/12121/falrepp/replicat(IROCI_init_context(OCISESS_context_def*,
int*, int*, unsigned int, short (*) [4], char const*)+0x9ee) [0x71b74e]]
:
[/ogg_falcn1/12121/falrepp/replicat(replicat_main(int, char**)+0xd33)
[0x5ccc43]]
:
[/ogg_falcn1/12121/falrepp/replicat(ggs::gglib::MultiThreading::MainThread::Ex
ecMain()+0x4f) [0x6a08bf]]
:
[/ogg_falcn1/12121/falrepp/replicat(ggs::gglib::MultiThreading::Thread::RunThr
ead(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a0bf4]]
:
[/ogg_falcn1/12121/falrepp/replicat(ggs::gglib::MultiThreading::MainThread::Ru
n(int, char**)+0x8b) [0x6a0cfb]]
: [/ogg_falcn1/12121/falrepp/replicat(main+0x3f)
[0x5cb16f]]
: [/lib64/libc.so.6(__libc_start_main+0xfd)
[0x3f9001ed5d]]
: [/ogg_falcn1/12121/falrepp/replicat() [0x518d19]]
.
2016-09-08 18:57:07 ERROR OGG-00870 Database error 1403 (ORA-01403: no
data found).
2016-09-08 18:57:07 ERROR OGG-01668 PROCESS ABENDING.

 

Changes

 New setup

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