Streams Capture Aborted With Ora-01422 (Doc ID 1360300.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms


ORA-01422 Streams Capture builder process


krvxerpt: Errors detected in process 27, role builder.
krvxmrs: Leaving by exception: 604
Errors in file /oracle/diag/rdbms/db/trace/DB01_ms01_12341.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
LOGMINER: session#=2, builder MS01 pid=27 OS id=26431 sid=505 stopped




----- Error Stack Dump -----
ORA-01422: exact fetch returns more than requested number of rows
----- Current SQL Statement for this session (sql_id=26br4p1m0h6w0) -----
select ckpt_info from system.logmnr_restart_ckpt$ where session# = :1 and ckpt_scn = :2 and xidusn = :3 and xidslt = :4 and xidsqn = :5 for update
----- Call Stack Trace -----
dbkedDefDump <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction
<- dbgdRunActions <- dbgdProcessEventAct <- ions <- dbgdChkEventKgErr <- ksfpec
<- dbgePostErrorKGE <- 884 <- kgesev <- ksesec0 <- rpidru
<- rpiswu2 <- kprball <- krvxsrwgl <- krvxsrwtd_RestartWr <- iteToDisk
<- krvxspdrc_DoRestart <- Ckpt ...

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