Home » Server Options » Streams & AQ » ORA-26714: User error encountered while applying --> on streams (oracle 11.1.0.6.1)
ORA-26714: User error encountered while applying --> on streams [message #395529] Wed, 01 April 2009 14:22 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i have a problem with streams. now i am doing R&D on Streams.

i have configured one way streams from STRTST to STRDEV. i am replication one table in scott schema. all of sudden my streams is not working
i have checked at capture process at source(STRTST) and propagation process. when i check the status of APPLY at target(STRDEV), i was found some errors. i am not sure why this error occur. i need to trace this error. here is the error message.

how do i find root cause for this error. please help me to find out the problem.
SQL> l
  1* select QUEUE_NAME,STATUS,ERROR_NUMBER,ERROR_MESSAGE from dba_apply
QUEUE_NAME           STATUS      ERROR_NUMBER ERROR_MESSAGE
-------------------- ----------- ------------ ------------------------------
Q_TST_DEV_SCOTT_EMP  ABORTED            26714 ORA-26714: User error encounte
                                              red while applying



one more stupid question i have on streams parameters.
"db_domain"
is db_domain parameter is important while configuring streams.?
value of the parameter can be any thing?

Re: ORA-26714: User error encountered while applying --> on streams [message #395532 is a reply to message #395529] Wed, 01 April 2009 15:28 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
experts,

i have found root cause for this error. now i need to fix this problem.

at source side (STRTST) is trying to update one record. that record is not exist in target side(STRDEV). Here is the information.

SQL> select QUEUE_NAME,ERROR_NUMBER,ERROR_MESSAGE,ERROR_CREATION_TIME from dba_apply_error;

QUEUE_NAME         ERROR_NUMBER ERROR_MESSAGE             ERROR_CRE
------------------ ------------ ------------------------- ---------
Q_TST_DEV_SCOTT_EM        26787 ORA-26787: The row with k 01-APR-09
P                               ey ("EMPNO") = (7934) doe
                                s not exist in table SCOT
                                T.EMP
                                ORA-01403: no data found


how do i fix this error. is there any way to instruct apply process to check weather row exist then update it otherwise ignore to apply that message?
Re: ORA-26714: User error encountered while applying --> on streams [message #395928 is a reply to message #395532] Fri, 03 April 2009 02:21 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Try to use DBMS_APPLY_ADM.EXECUTE_ERROR (From source)

Ref: http://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/server.111/b28321/strms_mapply.htm#CHDCGGBC

Babu

Re: ORA-26714: User error encountered while applying --> on streams [message #396094 is a reply to message #395928] Fri, 03 April 2009 17:09 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Babu,

Thanks for reply. could you please tell me the actions i need to take care. what i am looking here is high level information.

is there any way to instruct oracle to ignore this kind of alerts in future?
Re: ORA-26714: User error encountered while applying --> on streams [message #396103 is a reply to message #396094] Fri, 03 April 2009 20:49 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


ASAIK, This kind of error occur in distributed transaction environment;

You may need to manually push the data to destination.

Babu
Previous Topic: catupgrd.sql is failing when trying to upgrade.
Next Topic: How to Check the Bidirectional replication
Goto Forum:
  


Current Time: Thu Mar 28 14:08:23 CDT 2024