Streams Capture Aborts : Ora-1422 From Builder Re Select From Logmnr_restart_ckpt$
Last updated on MAY 07, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
Streams capture aborts with error ORA-1280. Examining the alert.log file prior to the Capture process failing shows that the Logminer Builder process immediately prior to the above encountered ora-1422.
In the trace file of the Builder process, we see :
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
KSV 1422 error in slave process
In order to determine the sql being executed at the time of the error / to gain a better understanding of the issue , enable an errorstack to be generated at the point of the ora-1422 error (errorstack , level 3). This will give more information in the latest Builder trace file created. This can be done using :
alter system set events '1422 trace name errorstack level 3' ;
-- start the Capture process and reproduce the issue .
conn / as sysdba
alter system set events '1422 trace name errorstack off' ;
This may likely show that the following sql is being executed is :
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms