Home » Server Options » Streams & AQ » queue rebuild fails after import (
queue rebuild fails after import [message #450154] Mon, 05 April 2010 06:05
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


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: Sat Jul 31 09:41:23 CDT 2021