Home » Server Options » Streams & AQ » queue rebuild fails after import (9.2.0.6)
queue rebuild fails after import [message #450154] Mon, 05 April 2010 06:05
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Queue Rebuild failed.

SQL> @ addCaseQSubscribers4.sql



PL/SQL procedure successfully completed.



BEGIN PROCESS_AGENT_PKG.REGISTERSUBSCRIBERLIST ( :ip_queue_nm, :opo_subscriber_count); END;



*

ERROR at line 1:

ORA-20999: PROCESS_AGENT_PKG(registerSubscriberList) ORA-20999:

PROCESS_AGENT_PKG(addSubscriber) ORA-24151: no evaluation context is associated

with rule CLRI.CASE_ACTIVITY_Q$6 or rule set CLRI.CASE_ACTIVITY_Q$6

ORA-06512: at "CLRI.PROCESS_AGENT_PKG", line 534

ORA-06512: at "CLRI.PROCESS_AGENT_PKG", line 105

ORA-06512: at line 1



We were trying to refresh the QA database from the production export dump.
After import we checked the dba_rules in QA database doesnot show any rule . This seems a reasons for many of the packages get invalidated after import.
I checked the production database that have 16 rules defined under dba_rules tables.
I am not sure abt the syntax for the creation of rules . Is there any way i can take the backup of rules from PROD or some creation of rule script so that i can create similar rules in QA.
Previous Topic: Replication Issue Using Streams
Next Topic: unable to create queue table
Goto Forum:
  


Current Time: Thu Mar 28 14:20:46 CDT 2024