| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
