OraFAQ Forum: Streams & AQ » ORA-26714: User error encountered while applying --> on streams

Home » Server Options » Streams & AQ » ORA-26714: User error encountered while applying --> on streams (oracle 11.1.0.6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-26714: User error encountered while applying --> on streams [message #395529]

Wed, 01 April 2009 14:22

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?

Report message to a moderator

Re: ORA-26714: User error encountered while applying --> on streams [message #395532 is a reply to message #395529]

Wed, 01 April 2009 15:28

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?

Report message to a moderator

Re: ORA-26714: User error encountered while applying --> on streams [message #395928 is a reply to message #395532]

Fri, 03 April 2009 02:21

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

Report message to a moderator

Re: ORA-26714: User error encountered while applying --> on streams [message #396094 is a reply to message #395928]

Fri, 03 April 2009 17:09

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?

Report message to a moderator

Re: ORA-26714: User error encountered while applying --> on streams [message #396103 is a reply to message #396094]

Fri, 03 April 2009 20:49

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 02 12:59:51 CST 2025