Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: Output Post Processor Fails Repeatedly with ORA-25205: the QUEUE APPLSYS.FND_CP_GSM_OPP_AQ does not Exist
Symptoms:
When running a concurrent request, the following error occurs in the request log file.
The Output Post Processor also goes down repeatedly.
ERROR
"+------------- 1) PUBLISH -------------+
Beginning post-processing of request 5387854 on node <node name> at 19-FEB-2008
16:59:44.
Post-processing of request 5387854 failed at 19-FEB-2008 16:59:45 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details."
In the manager log file the following error appears:
The Output Post Processor also goes down repeatedly.
ERROR
"+------------- 1) PUBLISH -------------+
Beginning post-processing of request 5387854 on node <node name> at 19-FEB-2008
16:59:44.
Post-processing of request 5387854 failed at 19-FEB-2008 16:59:45 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details."
In the manager log file the following error appears:
ORA-25205: the QUEUE APPLSYS.FND_CP_GSM_OPP_AQ does not exist
Log files:
Solution:
The issue is caused by the following setup: The advanced queues have not been started.
Run the SQL below:
SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS, OWNER
from DBA_OBJECTS
where OBJECT_NAME like '%FND_CP_GSM_OPP_AQ%';
to check status of queues
Run the SQL below:
SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS, OWNER
from DBA_OBJECTS
where OBJECT_NAME like '%FND_CP_GSM_OPP_AQ%';
to check status of queues
1. Start the queues by logging into SQLPLUS as applsys:
DBMS_AQADM.START_QUEUE(queue_name => 'FND_CP_GSM_OPP_AQ');
DBMS_AQADM.START_QUEUE(queue_name => 'AQ$_FND_CP_GSM_OPP_AQTBL_E', enqueue =>FALSE, dequeue
=> TRUE);
2. This will enable the queues. Confirm by bouncing the applications.
3. Retest the issue.
4. Migrate the solution as appropriate to other environments.
References:
Output Post Processor Fails Repeatedly with ORA-25205: the QUEUE APPLSYS.FND_CP_GSM_OPP_AQ does not Exist [ID 555717.1]
No comments:
Post a Comment