Apply Error handling
To determine what privileges are missing or
are provided, login as the user “apply user” and query the
session_privs data dictionary view.
ORA-01403 No Data Found
An ORA-01403 error message is generated
when an Apply process tries to update an existing row and the
old_values in the row LCR do not match the current values at
this destination database object.
This situation could arise on account of
any of the situations below:
-
Supplemental logging is not specified for
columns that require supplemental logging at the source
database. In this case, LCRs from the source database may not
contain values for key columns.
-
There may be a problem with primary key in
the destination table. If no primary key exists for the table or
if the target table has a different primary key than the source
table, substitute key columns can be specified using the set_key_columns procedure in the
dbms_apply_adm
package. Error ORA-23416 may be encountered if a table being
applied does not have a primary key.
-
There is a data mismatch between a row LCR
and the table for which the LCR is applying a change. In this
case, the destination has to be updated to match the data values
before the error transaction can be executed again.
ORA-23605 Invalid Value for Streams
Parameter
This error occurs if an incorrect value is
used for a Streams parameter or if a row LCR does not contain
the correct old and new values.
ORA-23607 Invalid Column
This error is caused by an invalid column
specified in the column list of a row LCR. The column names in
the row LCR need to be verified. This error message usually is
generated if an Apply handler or rule-based transformation
attempts one of the following actions:
