IR fails with Database Error ORA -1403, even before resolving the tables
(Doc ID 2184320.1)
Last updated on JUNE 24, 2020
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 :
[/oggcore/OpenSys/src/gglib/ggdbora/ir
oci.cpp]
SourceFunction : [IROCI_attach]
SourceLine : [642]
ThreadBacktrace : [12] elements
:
[/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7effb186e31e]]
:
[/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7effb1869030]]
:
[/ogg/libgglog.so(_MSG_ERR_DB_SQL_ERROR(CSourceContext*,int, char const*, CMessageFactory::MessageDisposition)+0x3b)[0x7effb184f855]]
:
[/ogg/replicat(IROCI_attach(OCISESS_context_def*)+0x2ab)[0x715f81]]
:
[/ogg/replicat(IROCI_init_context(OCISESS_context_def*,int*, int*, unsigned int, short (*) [4], char const*)+0x9ee) [0x71b74e]]
:
[/ogg/replicat(replicat_main(int, char**)+0xd33)[0x5ccc43]]
:
[/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a08bf]]
:
[/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a0bf4]]
:
[/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a0cfb]]
: [/ogg/replicat(main+0x3f)[0x5cb16f]]
: [/lib64/libc.so.6(__libc_start_main+0xfd)[0x3f9001ed5d]]
: [/ogg/replicat() [0x518d19]]
.
2016-09-08 18:57:07 ERROR OGG-00870 Database error 1403 (ORA-01403: nodata found).
2016-09-08 18:57:07 ERROR OGG-01668 PROCESS ABENDING.
Changes
New setup
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |