My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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 ...


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

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